 |
|
| Defining the SAS OLAP Environment |
Data Tables
Data tables are frequently used to define data stores. They can be used to define data stores, summary data, a join, or a table that holds information that does not conform to any other data storage type. A detail, or base, table is any data table defined in the SAS metadata that contains the measures and levels for a cube. The detail table consists of unsummarized data that must include one column for each level and one numeric analysis column for each set of measures that will be generated. There are different types of data tables that can be used to build a SAS OLAP cube. You can use the following tables to construct SAS OLAP cubes:
-
detail tables (base tables)
-
star schemas (a fact table and associated dimension tables)
-
summary tables (N-way data set)
-
drill-through tables
-
aggregation tables
For detailed information on the different data tables, see Data Tables Used to Define SAS OLAP Cubes. Also, see the SAS Intelligence Platform: Data Administration Guide for further information on managing data table sources.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.