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:

For detailed information about the different data tables, see Data Tables Used to Define SAS OLAP Cubes. Also, see the SAS Intelligence Platform: Data Administration Gujide for more information about managing data table sources.