Create consistent OLAP cubes using an integrated ETL process. Say no to plagiarism. Get a tailor-made essay on "Why Violent Video Games Shouldn't Be Banned"? Get an Original Essay Using a streamlined ETL process, SAS OLAP Server makes it easy to create consistent OLAP cubes from disparate systems. Integrated metadata ensures consistent information is distributed across the enterprise and allows IT to quickly justify data integrity. Quickly populate your BI applications with stable, summarized data. SAS OLAP Server quickly delivers information to business intelligence applications, regardless of the amount of underlying data. Summarizing data at different levels of detail before archiving provides the summary data required by business intelligence applications without the need for additional “on-the-fly” processing. Frees IT from constantly creating ad hoc reports and data summaries. Because summary data is organized along business lines, users can get the reports they need without involving IT, freeing them from the constant work of creating reports and summarizing data. Multidimensional, industrial-strength database: Designed to handle large volumes of business intelligence data. Supports multidimensional (MOLAP) and hybrid data stores (HOLAP). The routines allow SAS procedures to query the SAS OLAP server using SQLPass-Through with coverage from multidimensional data to the underlying detailed data. Native support for open industry standards: OLE DB for OLAP. Fully compliant implementation of the MDX query language for communicating with third-party customers. With the open architecture of SAS software, cubes can be viewed via the web, via Microsoft Excel as pivot tables, as well as via SAS or other standards-based browsers. Fast query processing: Multithreaded query engine. Data can be distributed across multiple disk systems, providing parallel read access for query threads. Load balanced server cluster management. Easy-to-use GUI for creating and maintaining OLAP cubes: Included with SAS OLAP Server, SAS OLAP Cube Studio makes it easy to define data dimensions and aggregations. SAS OLAP Cube Studio is integrated with SAS Data Integration Studio so you can create cubes from cleansed data sources and load them for later use and refresh. The Java-based wizard makes it easy to design, create, update and optimize OLAP cubes. Create a set of dimensions once, then share them with other cubes, providing consistent hierarchies and saving system resources. Update the set and apply it to shared cubes. Optimize summarized data to conserve system resources: Rarely accessed data can be stored in a compressed format. Frequently queried data can be cached for faster access. Dimensions, hierarchies, and metrics (metadata) are stored in the cube itself, while the data remains in the database and is queried only at run time, reducing data duplication and cube processing time. Centralized metadata with security credentials preserved during drill-through: All metadata is stored in one open location – the SAS metadata server. SAS OLAP Server is fully integrated into the open security model maintained in SAS Metadata Server used in all SAS products and solutions. Multilingual support: Use translated captions via caption tables. Natural language format support for measures. data-aware sorting. Powerful interfaces for monitoring.