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 CISAM or SQL

Matching SYSPRO Business Analytics toYour 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

Prereqisites

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