SAS^® OLAP Server

In the Spotlight SAS OLAP Server Fact Sheet •   Product Overview •   Key Benefits •   Complete Features List •   Technical Requirements What is SAS OLAP Server? SAS OLAP Server is a multidimensional data store designed from the outset to provide quick access to presummarized data, generated from vast amounts of detailed data. Why is SAS OLAP Server important? Decision makers need fast access to accurate information. Instantaneous access to summarized data is expected so timely decisions can be based on knowledge instead of gut feelings. For whom is SAS OLAP Server designed? SAS OLAP Server is designed for CIOs who want to deploy a fast enterprisewide source for reliable summaries of strategic information, IT managers with large numbers of end users requiring rapid self-service navigation through summarized data, and department heads whose teams require frequent access to summaries to support business analysis and decisions. Key Benefits Delivers fast, stable performance for business intelligence applications. Designed from the outset as dedicated storage for summarized data, SAS OLAP Server quickly delivers information to business intelligence applications, irrespective of the amount of underlying data. Summarizing data at multiple levels of detail before storing provides the summarized data that business intelligence applications require without the need for additional “on-the-fly” processing. Frees IT from constantly creating ad hoc reports and data summaries. Because summarized data is organized along business lines, users can get the reports they need without involving IT. This frees IT from the constant work of creating reports and data summaries to support users who need to follow a train of thought at various levels of detail. Provides a transparent and integrated ETL process. With a simplified ETL process, it is easy to build consistent OLAP cubes from disparate systems. Integrated metadata ensures that consistent information is delivered across the enterprise and enables IT to quickly justify data integrity. Key Features Powerful, multidimensional database. SAS OLAP Server, designed to handle large volumes of business intelligence data, supports multidimensional (MOLAP) and hybrid (HOLAP) data stores and includes native support for open industry standards. Fast, efficient processing of queries. The solution includes a multithreaded query engine and parallel storage, which allows data to be spread across multiple-disk systems, providing parallel-read access for query threads. Easy-to-use GUIs for building and maintaining OLAP cubes. SAS OLAP Cube Studio, a stand-alone cube-building tool, can be used to easily define data measures, dimensions and aggregations. The same component is integrated with a powerful extract-transform-load process designer, so you can build cubes from cleansed data sources and load them for later use and updating. Capabilities for supporting real-world OLAP problems. Several dimensions facilitate the use of SAS OLAP Server in everyday business, including time dimensions for calculating time-based measures, ragged and unbalanced hierarchies, and parallel drill hierarchies. Integrated metadata. All metadata is stored in a single, open location — SAS Metadata Server. SAS OLAP Server is fully integrated into the open security model maintained in SAS Metadata Server and used throughout the entire SAS platform. For a complete list of key benefits and features, refer to the SAS OLAP Server fact sheet .

Ready to put The Power to Know® to work for you? Sign up for one of our free e-newsletters. Contact your local SAS office or call us toll free at 1-800-727-0025 (U.S. and Canada). Contact SAS for pricing information and to learn more about our products and solutions.				Subscribe today for FREE news updates from SAS