SAS(R) 9.3 OLAP Server: User's Guide - Navigation
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
Product
Release
SAS Enterprise BI Server
9.3
SAS OLAP Server Monitor for SAS Management Console
9.3
SAS OLAP Cube Studio
9.1.3
SAS OLAP Server
9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
14Jun2011
AltStyle
によって変換されたページ
(->オリジナル)
/
アドレス:
モード:
デフォルト
音声ブラウザ
ルビ付き
配色反転
文字拡大
モバイル