| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
ALL_OLAP2_FACT_TABLE_GID shows the Grouping ID column for each hierarchy in each fact table. For more information, see "Grouping ID Column".
| 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_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension. |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension |
HIERARCHY_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the hierarchy. |
DIM_HIER_COMBO_ID |
NUMBER |
NOT NULL |
ID of the dimension-hierarchy association. |
FACT_TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the fact table. |
FACT_TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the fact table. |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the GID column. |
