The
following table lists the PROC OLAP statements and options that you use to
load a cube from a detail table. The detail table has a column for each level
and at least one numeric analysis column from which one or more measures can
be generated. The PROC OLAP code that is used for a cube that is built from
a detail table will use the DATA= option to specify the data source for the
cube.
Statements and Options Used to Load Cubes from a Detail Table
Statements |
Options |
Required or Optional? |
PROC OLAP |
DATA= |
Required |
|
CUBE= |
Required |
|
PATH= |
Required |
|
DESC= |
Optional |
|
NO_NWAY |
Optional |
|
WORKPATH= |
Optional |
|
DT_TABLE |
Optional |
METASVR |
OLAP_SCHEMA= |
Required |
|
REPOSITORY= |
Optional |
|
HOST= |
Optional |
|
PORT= |
Optional |
|
PROTOCOL= |
Optional |
|
USERID= |
Optional |
|
PW= |
Optional |
DIMENSION |
HIERARCHIES= |
Required |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
|
TYPE=TIME |
Required only for TIME dimensions |
|
SORT_ORDER= |
Optional |
LEVEL |
|
The LEVEL statement is optional unless you want to specify time periods
for each level in a TIME dimension. If you specify a time period for one level,
then you must specify a time period for all levels. To specify a time period,
you use the TYPE= option. |
HIERARCHY |
LEVELS= |
Required |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
MEASURE |
STAT= |
Required |
|
COLUMN | ANALYSIS= |
Required |
|
AGGR_COLUMN= |
Required if you use the AGGREGATION statement with the /TABLE= option |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
|
UNITS= |
Optional |
|
FORMAT= |
Optional |
|
DEFAULT= |
Optional |
PROPERTY |
prop-name |
Required |
|
LEVEL= |
Required |
AGGREGATION |
|
The AGGREGATION statement is optional unless you are creating additional
aggregations. In that case, you must specify the names of the contiguous levels
to be used to create the aggregation. Use the TABLE= option for cubes that
contain aggregated data from tables other than the input data source. |
The
following table lists the PROC OLAP statements and options that you use to
load a cube from a star schema. A star schema is a set of input tables that
are defined in a repository. The set of tables includes a single fact table
and one or more dimension tables. The fact table must contain at least one
numeric analysis column for each set of measures that will be generated. To
specify the data source for a star schema you must use the FACT=, DIMTBL=,DIMKEY=,
and FACTKEY= options
Statements and Options Used to Load Cubes from a Star Schema
Statements |
Options |
Required or Optional? |
PROC OLAP |
FACT= |
Required |
|
CUBE= |
Required |
|
PATH= |
Required |
|
DESC= |
Optional |
|
NO_NWAY |
Optional |
|
WORKPATH= |
Optional |
|
DT_TABLE |
Optional |
METASVR |
OLAP_SCHEMA= |
Required |
|
REPOSITORY= |
Optional |
|
HOST= |
Optional |
|
PORT= |
Optional |
|
PROTOCOL= |
Optional |
|
USERID= |
Optional |
|
PW= |
Optional |
DIMENSION |
HIERARCHIES= |
Required |
|
DIMTBL= |
Required for cubes that support one locale. If the cube will contain
multiple national languages, replace this option with DIMTABLELIBREF= and
DIMTABLEMEMPREF=. |
|
FACTKEY= |
Required |
|
DIMKEY= |
Required |
|
DIMTABLELIBREF |
Required if you build a cube that will contain multiple national languages.
Replaces DIMTBL=. |
|
DIMTABLEMEMPREF |
Required if you build a cube that will contain multiple national languages.
Replaces DIMTBL=. |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
|
TYPE=TIME |
Required only for TIME dimensions |
|
SORT_ORDER= |
Optional |
LEVEL |
|
The LEVEL statement is optional unless you want to specify time periods
for each level in a TIME dimension. If you specify a time period for one level,
then you must specify a time period for all levels. To specify a time period,
you use the TYPE= option. |
HIERARCHY |
LEVELS= |
Required |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
MEASURE |
STAT= |
Required |
|
COLUMN | ANALYSIS= |
Required |
|
AGGR_COLUMN= |
Required if you use the AGGREGATION statement with the /TABLE= option |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
|
UNITS= |
Optional |
|
FORMAT= |
Optional |
|
DEFAULT= |
Optional |
PROPERTY |
prop-name |
Required |
|
LEVEL= |
Required |
AGGREGATION |
|
The AGGREGATION statement is optional unless you are creating additional
aggregations. In that case, you must specify the names of the contiguous levels
to be used to create the aggregation. Use the /TABLE= option for cubes that
contain aggregated data from tables other than the input data source. |
The following table lists the PROC OLAP statements and options
that you use to load cubes from a fully summarized data source (a crossing
of all dimensions also known as an NWAY). Unlike a detail table or star schema,
a fully summarized cube does not use either the DATA= or FACT= option to specify
the data that is used to build the cube. Instead the TABLE= option is used
on the AGGREGATION statement.
Statements and Options Used to Load Cubes from Fully Summarized Data
Statements |
Options |
Required or Optional? |
PROC OLAP |
CUBE= |
Required |
|
PATH= |
Required |
|
DESC= |
Optional |
|
NO_NWAY |
Optional |
|
WORKPATH= |
Optional |
|
DT_TABLE |
Optional |
METASVR |
OLAP_SCHEMA= |
Required |
|
REPOSITORY= |
Optional |
|
HOST= |
Optional |
|
PORT= |
Optional |
|
PROTOCOL= |
Optional |
|
USERID= |
Optional |
|
PW= |
Optional |
DIMENSION |
HIERARCHIES= |
Required |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
|
TYPE=TIME |
Required only for TIME dimensions |
|
SORT_ORDER= |
Optional |
LEVEL |
|
The LEVEL statement is optional unless you want to specify time periods
for each level in a TIME dimension. If you specify a time period for one level,
then you must specify a time period for all levels. To specify a time period,
you use the TYPE= option. |
HIERARCHY |
LEVELS= |
Required |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
MEASURE |
STAT= |
Required |
|
COLUMN | ANALYSIS= |
Required |
|
AGGR_COLUMN= |
Required |
|
DESC= |
Optional |
|
CAPTION= |
Optional |
|
UNITS= |
Optional |
|
FORMAT= |
Optional |
|
DEFAULT= |
Optional |
PROPERTY |
prop-name |
Required |
|
LEVEL= |
Required |
AGGREGATION |
names of the contiguous levels to be used to create the aggregation |
Required (additional AGGREGATION statements without the TABLE= option
can be used to create aggregations other than the automatically defined NWAY). |
|
TABLE= |
Required |
![](../../../../common/63294/HTML/default/images/spacer.gif) |
![](../../../../common/63294/HTML/default/images/spacer.gif) |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.