The OLAP Procedure

USE_DIMENSION Statement

Specifies a shared dimension to be included in the cube.
Syntax
Details
Required Arguments

Syntax

USE_DIMENSION [dim-name | "/folder/dim-name" ]
[OLAP_SCHEMA=schema-name ] FACTKEY=fact-table column;

Details

Required Arguments

dim-name | "/folder/dim-name"
provides the name of the dimension or the location and name of the dimension referenced.
OLAP_SCHEMA= schema-name
specifies the name of the OLAP schema. The OLAP schema option is required if the shared dimension's schema is different from the schema specified in the METASVR statement.
FACTKEY= fact-table column
provides the name of the key column in the fact table that corresponds to the DIMKEY key column in the dimension table.
Note: HIERARCHY, LEVEL, and PROPERTY statements are not needed or allowed for the shared dimension. The structure of the dimension was defined when the shared dimension was originally built.
Note: If the EMPTY_CHAR= or EMPTY_NUM= options are specified in the PROC OLAP statement, those values do not apply to the shared dimension. These options might be specified in the original DIMENSION statement for which this dimension is shared.

See Also

Using a Shared Dimension in a Cube
Copyright © SAS Institute Inc. All rights reserved.