OLAP

SAS Enterprise BI Server provides a powerful multidimensional 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.