• Contents
  • About
  • Title Page
  • What's New in the SAS 9.3 OLAP Server
  • OLAP Introduction and Overview
    • OLAP Introduction and Overview
    • 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 SAS OLAP 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 Cubes 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 for Cubes
    • 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
    • Securing Cubes
  • 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 Multilingual 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 Server 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–Level Permissions
    • 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
    • Building a Shared Dimension
  • 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
  • The OLAP Procedure
    • Syntax: OLAP Procedure
      • PROC OLAP
      • METASVR
      • DIMENSION
      • USE_DIMENSION
      • HIERARCHY
      • LEVEL
      • PROPERTY
      • MEASURE
      • AGGREGATION
      • DROP_AGGREGATION
      • DEFINE
      • UNDEFINE
      • USER_DEFINED_TRANSLATIONS
      • REORGANIZE_LEVEL
    • Overview: OLAP Procedure
    • Maintaining Cubes
    • Specialized Options for PROC OLAP
    • Understanding Shared Dimensions
    • Developing and Managing Shared Dimensions
  • The OLAPOPERATE Procedure
    • Syntax: OLAPOPERATE Procedure
    • Overview: 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
    • Listing Session Cubes on an OLAP Server
    • Closing a Session
    • Canceling 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
    • Quiescing an OLAP Server
    • Pausing an OLAP Server
    • Resuming an OLAP Server
  • Glossary


ProductRelease
SAS Enterprise BI Server9.3
SAS OLAP Server Monitor for SAS Management Console9.3
SAS OLAP Cube Studio9.1.3
SAS OLAP Server9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
14Jun2011