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_OLAP2_AGGREGATION_USES

ALL_OLAP2_AGGREGATION_USES lists the aggregation operators associated with cubes that map to relational tables organized as star or snowflake schemas.

Column Data Type NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the cube.
CUBE_NAME VARCHAR2(30) NOT NULL Name of the cube.
DIMENSION_NAME VARCHAR2(30) NOT NULL Name of the dimensions of the cube.
HIERARCHY_NAME VARCHAR2(30)
Name of the hierarchies of the cube's dimensions.
DIM_HIER_COMBO_ID NUMBER NOT NULL Identifier of a hierarchy combination within the cube.
AGGREGATION_NAME VARCHAR2(240)
Name of the aggregation operator for this dimension. (See Table 1-10, "Aggregation Operators".
AGGREGATION_ORDER NUMBER
The order of precedence of the aggregation operator.
TABLE_OWNER VARCHAR2(30)
Owner of the table that contains the weightby factors for weighted operators. If the operator is not weighted, this column is null.
TABLE_NAME VARCHAR2(30)
Name of the table that contains the weightby factors for weighted operators. If the operator is not weighted, this column is null.
COLUMN_NAME VARCHAR2(30)
Name of the column that contains the weightby factors for weighted operators. If the operator is not weighted, this column is null.