Viewing OLAP Catalog Metadata , 24 of 25

ALL_OLAP2_FACT_TABLE_GID

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.