Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
OLAP Catalog Union Views , 21 of 24
ALL_OLAP2_FACT_TABLE_GID
is a synonym for ALL$OLAP2UFACT_TABLE_GID
.
Each row represents information about a Grouping ID (GID) column in a fact table.
In the case of solved, embedded total fact table (where totals for every level combination are embedded in the table), there is a GID column corresponding to each dimension key in the fact table. For example, an embedded total fact table for sales data, which is dimensioned by product, geography and time, has three GID columns (one for each of the dimensions).
Note: This view only pertains to OLAP 2 metadata ( |
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|