Lonehill System, Inc.

Business Analytics

Objective

To provide an engine that creates a Business Intelligence layer allowing users to create multi-dimensional views of the SYSPRO data.

The Value of SYSPRO Business Analytics

• Uses Microsoft OLAP and SQL technologies
• Scalable and open
• Easy wizard setup – no OLAP knowledge required
• Configurable analytics engine provided
• Customizable cubes for Financials, Distribution and Manufacturing
• SYSPRO database can be C-ISAM or SQL

Matching SYSPRO to Your Business

• Mini data warehouse without costs of traditional data warehouse
• Fully customizable views to suit your requirements
• Advanced customization through MS Analysis Services
• Add Business Rules through stored procedures
• Create logical breakups of underlying SQL tables and include breakups as dimensions
• Analyze data using any MS OLAP compliant viewer, e.g., MS Excel and MS Data Analyzer or Business Intelligence viewers such as Proclarity and COGNOS
• MS SQL Server 2000
• MS SQL Analysis Server
• MS OLAP compliant viewer

Prerequisites

• MS SQL Server 2000
• MS SQL Analysis Server
• MS OLAP compliant viewer