• Contents
  • About
  • What's New in the SAS 9.2 OLAP Server
  • OLAP Introduction and Overview
    • What Is OLAP?
    • What Is a Cube?
    • Understanding the Cube Structure
    • Why You Should Use Cubes
  • Defining the SAS OLAP Environment
    • SAS OLAP Environment — Overview
    • SAS Metadata Server
    • SAS Application Server
    • SAS Workspace Server
    • SAS OLAP Server
    • SAS Management Console
    • SAS OLAP Server Monitor
    • SAS OLAP Cube Studio
    • OLAP Schema
    • SAS Libraries
    • Data Tables
    • Authorization Permissions
  • Organization and Management of Your Data
    • Cube Data Organization
    • OLAP Schemas
    • SAS Libraries and Tables
    • Managing Folders In SAS OLAP Cube Studio
    • SAS OLAP Cube Jobs
  • Planning for Cubes
    • Overview
    • Data Tables Used to Define SAS OLAP Cubes
    • Aggregation Design
    • Aggregation Storage
    • SAS OLAP Cube Size Specifications
    • Naming Guidelines and Rules for the SAS OLAP Server
    • SAS Formats Available for Measures
    • Statistics Available for Measures
  • Building and Administering Cubes
    • SAS OLAP Cube Studio and the OLAP Procedure
    • Connecting and Reconnecting to a Metadata Server
    • Cube Designer Wizard
    • Defining Data Sources For a Cube
    • Defining Drill-Through Tables
    • Defining Dimensions and Levels
    • Specifying the TIME Dimension
    • Specifying GIS Map Information for a Dimension
    • Defining Cube Hierarchies
    • Defining Measures For A Cube
    • Defining Member Properties
    • Defining Aggregations While Building a Cube
    • Saving the Cube Metadata or Creating the Physical Cube
    • Saving the OLAP Procedure (Long Form versus Short Form)
    • Viewing Cubes in SAS OLAP Cube Studio
  • Modifying and Maintaining Cubes
    • Editing a Cube
    • Renaming A Cube Object
    • Deleting Cubes and Cube Objects
    • Refreshing Cube Metadata
    • Tuning Cube Aggregations
    • Specifying Tuning and Performance Options in Cube Aggregations
    • Specifying Calculated Members and Measures
    • Multiple Language Support and Dimension Table Translations
    • Adding SAS System Options to a Cube
    • Synchronizing Column Changes
    • Accessing OLAP Cubes from SAS: SQL Pass-Through Facility for OLAP
    • Impact Analysis and Reverse Impact Analysis
    • Disabling and Enabling Cubes
    • Cube Security
  • Updating SAS OLAP Cubes
    • Overview
    • Updating a Cube In-Place
    • Incremental Updates of Cubes and Cube Generations
    • Coalescing Cube Aggregations
    • Updating a Cube In a Production Environment
    • Archiving and Deleting Cube Generations
    • Updating the Captions and Descriptions for a Cube
    • Adding New Members to an Incrementally Updated Cube
    • Reorganization of Cube Levels
    • Updating Member Properties
    • Specifying Drill-Through Tables
    • NWAY Considerations
    • Updating Multiple Language Support Cubes
    • Format Search Path and SAS Source Code Considerations
    • Exporting Cubes that Have Been Updated
    • Input Data Tables for Cube Updates
    • Schema and Repository Considerations
    • Physical Storage and Metadata Considerations
    • Connecting to a Workspace Server
    • Proc OLAP Options
    • Proc OLAPOPERATE Options and SAS OLAP Monitor
    • Updating Cubes in SAS OLAP Cube Studio
  • Cube Building and Modifying Examples
    • Defining A Connection Profile
    • Building a Cube from a Detail Table
    • PROC OLAP Example for a Detail Table
    • Building a Cube from a Star Schema
    • Building a Cube from a Summary Table
    • Tuning Aggregations For a Cube
    • Adding Data to a Cube with Cube Update
    • Adding Calculated Members To A Cube
    • Setting Member Authorizations On A Dimension
    • Setting Identity Driven Security
    • Viewing a Cube in SAS OLAP Cube Studio
    • Creating a Time Dimension in SAS OLAP Cube Studio
    • Synchronizing Column Changes
    • Specifying an ESRI GIS Map For a Cube Dimension
    • Creating Multiple Hierarchies For a Cube
    • Set IGNORE_MISSING_DIMKEYS for a Star Schema
    • Implementing Drill-through to Detail Data in a SAS OLAP Cube
    • Exporting a Cube From SAS OLAP Cube Studio
    • Importing a Cube Into SAS OLAP Cube Studio
  • Using SAS OLAP Cubes
    • Using a Cube with ADO MD
    • Using a Cube with OLE DB for OLAP
    • Using a Cube with Additional SAS Products
    • Using a Cube with Third-Party Clients
  • Importing and Exporting SAS OLAP Cubes
    • Importing and Exporting SAS OLAP Cubes
    • ExportCubes and ImportCubes Batch Tools
    • Export SAS Package and Import SAS Package
    • Validating Data After It Is Moved
    • Cube Promotion and Migration Resources
  • PROC OLAP
    • The OLAP Procedure
    • Syntax: OLAP Procedure
    • PROC OLAP Statement
    • METASVR Statement
    • DIMENSION Statement
    • LEVEL Statement
    • PROPERTY Statement
    • HIERARCHY Statement
    • MEASURE Statement
    • AGGREGATION Statement
    • DROP_AGGREGATION Statement
    • DEFINE Statement
    • UNDEFINE Statement
    • USER_DEFINED_TRANSLATIONS Statement
    • REORGANIZE_LEVEL Statement
    • Loading Cubes
    • Maintaining Cubes
    • Specialized Options for PROC OLAP
  • The OLAPOPERATE Procedure
    • The OLAPOPERATE Procedure
    • Syntax: OLAPOPERATE Procedure
    • Connection Options
    • Disconnecting from an OLAP Server
    • Listing Active Sessions on an OLAP Server
    • Listing Session Queries on an OLAP Server
    • Listing Session Rowsets on an OLAP Server
    • Closing a Session
    • Cancelling a Query Result Set
    • Disabling a Cube
    • Enabling a Cube
    • Enabling and Disabling Cubes for a Cube Update
    • Refreshing a Cube
    • Stopping an OLAP Server
  • Resources and Reference Topics
    • OLAP Server Resources
    • OLAP Schema Resources
    • Cube Resources
    • Table Resources
    • Dimension Resources
    • Level Resources
    • Hierarchy Resources
    • Measure Resources
    • Member and Member Properties Resources
    • Calculated Members and Measures Resources
    • Aggregation Resources
    • Incremental Cube Update Resources
    • Drill–Through to Detail Resources
    • GIS Mapping Resources
  • SAS OLAP Cube Studio Accessibility Features
    • SAS OLAP Cube Studio Accessibility Features
  • Recommended Reading
  • Glossary


ProductRelease
SAS Enterprise BI Server4.2
SAS OLAP Server Configuration9.2
SAS OLAP Server Monitor for SAS Management Console9.2
SAS OLAP Cube Studio4.2_M2
Type
Usage and Reference
Copyright Date
February 2009
Last Updated
01Oct2009