OLAP

SAS Enterprise BI Server provides a powerful multidimensional (OLAP) database designed to provide fast access to large volumes of summarized data. A wizard-driven interface enables OLAP cube designers and data architects to quickly and easily create consistent data sources for business users.

Also included is a Web-based data exploration interface that makes it simple for business users to look at large volumes of data quickly from multiple angles. They can get high-level views of data, as well as increasing levels of detail, all based on consistent, accurate information.

Key Benefits

• Provides a high-level view of key business performance at the intersection of selected business dimensions.
• Users can get the answers they need without constantly involving IT.
• A single, shared layer of metadata ensures traceability from the operational data source through the ETL process to the destination OLAP cube.

Key Features

• Easy-to-use interfaces for building and maintaining OLAP cubes.
• Cubes can be created based on any data stored in any database on any operating system.
• OLAP cubes can be stored on any major hardware platform, from Microsoft Server 2003, HP/UX, AIX and Solaris, up to z/OS on mainframes.
• OLAP data storage and navigation are integrated into the SAS BI reporting environment.
• Fully compliant with Microsoft's OLE DB for OLAP standard so users can choose their favorite front-end for accessing summarized information.
• Full-featured interactive OLAP client applications allow users to take advantage of OLAP functions as needed to match their needs and skills.