Skip Headers
Oracle® OLAP Reference
10g Release 2 (10.2)

Part Number B14350-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_AW_LOAD_DIM_PARMS

ALL_AW_LOAD_DIM_PARMS lists the parameters in dimension load specifications.

Dimension load specifications determine how dimension members will be loaded from the dimension table into the analytic workspace.

Parameters are set for dimension load specifications by the DBMS_AWM.SET_AWDIMLOAD_SPEC_PARAMETER procedure.

Column Datatype NULL Description
owner varchar2(30)
Owner of the source dimension in the OLAP Catalog.
dimension_name varchar2(30)
Name of the source dimension in the OLAP Catalog.
load_name varchar2(60)
Name of the dimension load specification.
parm_name varchar2(16)
'UNIQUE_RDBMS_KEY' -- Whether or not the members of this dimension are unique across all levels in the source tables.

'DISPLAY_NAME' -- Display name for the target dimension in the analytic workspace.

'PLURAL_DISPLAY_NAME' -- Plural display name for the target dimension in the analytic workspace.

parm_value varchar2(4000)
Values of UNIQUE_RDBMS_KEY: NO-- Dimension member names are not unique across levels in the RDBMS tables. The corresponding dimension member names in the analytic workspace include the level name as a prefix. (Default) YES -- Dimension member names are unique across levels in the RDBMS tables. The corresponding dimension member names in the analytic workspace have the same names as in the source relational dimension.

Value of DISPLAY_NAME is the display name for the target dimension in the analytic workspace.

Value of PLURAL_DISPLAY_NAME is the plural display name for the target dimension in the analytic workspace.