Release 2 (9.2)
Part Number A95295-01
 Home |
 Book List |
 Contents |
 Index |
 Master Index |
 Feedback |
| Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
Creating an Analytic Workspace From Relational Tables, 5 of 6
You can discover the names of objects by browsing through the metadata catalogs, which are variables named ___CWM.object.CAT in the analytic workspace. Note that three underscores prefix the name.
Table 9-1 lists the names of the basic catalogs. To see a full listing of the catalogs, issue a LISTNAMES VARIABLE command.
| Variable Name | Description |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The Catalog catalog provides detailed information about each measure folder. Each folder or catalog is represented by a member of the ___cwm.cat.ent dimension. The following example shows the entries for the xademo_cat catalog.
report ___cwm.cat.cat -----___CWM.CAT.CAT------ -----___CWM.CAT.ENT------ ___CWM.CAT.PRP 95 -------------------- ------------------------- CATALOG_NAME XADEMO_CAT PARENT_CATALOG_ID NA DESCRIPTION XADEMO CWM Business Area
The Cube catalog provides detailed information about each cube. Each cube in the xademo schema is represented by a member of the ___cwm.cb.ent dimension. The following example shows the catalog entries for analytic_cube. The Description field shows that this cube contains five measures (sales, quota, cost, units, and promo), which are dimensioned by time, channel, product, and geography.
report ___cwm.cb.cat ----------------___CWM.CB.CAT---------------- ----------------___CWM.CB.ENT---------------- ___CWM.CB.PRP 1 -------------------- --------------------------------------------- OWNER XADEMO CUBE_NAME ANALYTIC_CUBE DISPLAY_NAME Analytics DESCRIPTION Sales, Quota, Cost, Units, Promo <TIME CHANNEL PRODUCT GEOGRAPHY> CBID 6 13 XADEMO ANALYTIC_CUBE
The Measure catalog provides detailed information about measures. Each measure in the xademo schema is represented by a member of the ___cwm.meas.ent dimension.
The following example lists the catalog entries for the f.sales measure. They show that the data from the sales column of the xademo_analytic_facts table is mapped to a workspace variable named __meas5. Note that two underscores begin the name.
report ___cwm.meas.cat ---------------___CWM.MEAS.CAT--------------- ---------------___CWM.MEAS.ENT--------------- ___CWM.MEAS.PRP 5 -------------------- --------------------------------------------- OWNER XADEMO CUBE_NAME ANALYTIC_CUBE MEASURE_NAME F.SALES DISPLAY_NAME F.SALES DESCRIPTION Dollar Sales DATA_TYPE DECIMAL FACT_TABLE_OWNER XADEMO FACT_TABLE_NAME XADEMO_ANALYTIC_FACTS COLUMN_NAME SALES CBID 6 13 XADEMO ANALYTIC_CUBE MEASID 6 13 7 XADEMO ANALYTIC_CUBE F.SALES EXPRESS_OBJ_NAME __MEAS5
The Dimension catalog provides detailed information about dimensions. Each dimension in the xademo schema is represented by a member of the ___cwm.dim.ent dimension. The following example lists the catalog entries for the geography measure. They show that the workspace geography dimension is named __dim3, and the workspace objects that support the geography hierarchies have an A3. prefix.
report ___cwm.dim.cat ---___CWM.DIM.CAT--- ---___CWM.DIM.ENT--- ___CWM.DIM.PRP 3 ------------------------------ -------------------- OWNER XADEMO DIMENSION_NAME GEOGRAPHY DISPLAY_NAME Geography PLURAL_NAME Geographys DESCRIPTION Geography Dimension Values DEFAULT_DISPLAY_HIERARCHY STANDARD DIMENSION_TYPE NA DIMID 6 9 XADEMO GEOGRAPHY EXPRESS_DIM_NAME __DIM3 EXPRESS_LVLDIM_NAME A3.LEVELDIM EXPRESS_LVLREL_NAME __LREL3 EXPRESS_HIERDIM_NAME A3.HIERDIM EXPRESS_PARENTREL_NAME A3.PARENTREL EXPRESS_HIERLVLREL_NAME A3.LVLREL EXPRESS_HIERLVLDEPTH_NAME A3.LVLDEPTHVAR EXPRESS_GID_NAME A3.GID EXPRESS_INHIER_NAME A3.INHIERARCHY
The Hierarchy catalog provides detailed information about dimension hierarchies. Each hierarchy of each dimension in the xademo schema is represented by a member of the ___cwm.hier.ent dimension. The following example lists the catalog entries for the two geography hierarchies, standard and consolidated.
report ___cwm.hier.cat ------------------___CWM.HIER.CAT------------------ ------------------___CWM.HIER.ENT------------------ ___CWM.HIER.PRP 4 5 ------------------ ------------------------- ------------------------- OWNER XADEMO XADEMO DIMENSION_NAME GEOGRAPHY GEOGRAPHY HIERARCHY_NAME STANDARD CONSOLIDATED DISPLAY_NAME Standard Consolidated DESCRIPTION Standard GEOGRAPHY Executive Consolidated hierarchy GEOGRAPHY hierarchy DIMID 6 9 XADEMO GEOGRAPHY 6 9 XADEMO GEOGRAPHY HIERID 6 9 8 XADEMO GEOGRAPHY 6 9 12 XADEMO GEOGRAPHY STANDARD CONSOLIDATED
The Level catalog provides detailed information about dimension levels. Each level of each dimension hierarchy is represented by a member of the ___cwm.lvl.ent dimension. The following example lists the catalog entries for the two of the four geography levels. From this catalog, you can learn that geography members at the city level are stored in a workspace dimension named __rdblvldim9, and geography members at the country level are stored in a workspace dimension named __rdblvldim10.
report ___cwm.lvl.cat -----------------------___CWM.LVL.CAT------------------------ -----------------------___CWM.LVL.ENT------------------------ ___CWM.LVL.PRP 9 10 ----------------------- ------------------------------ ------------------------------ OWNER XADEMO XADEMO DIMENSION_NAME GEOGRAPHY GEOGRAPHY LEVEL_NAME L4 L3 DISPLAY_NAME Cities Countries/Areas DESCRIPTION Cities of standard GEOGRAPHY Countries/Areas of standard hierarchy GEOGRAPHY hierarchy LEVEL_TABLE_OWNER XADEMO XADEMO LEVEL_TABLE_NAME XADEMO_GEOGRAPHY XADEMO_GEOGRAPHY DIMID 6 9 XADEMO GEOGRAPHY 6 9 XADEMO GEOGRAPHY LVLID 6 9 2 XADEMO GEOGRAPHY L4 6 9 2 XADEMO GEOGRAPHY L3 RDBMS_LVLDIM_NAME __RDBLVLDIM9 __RDBLVLDIM10 RDBMS_TO_EXPRESS_LVLREL __RDBEXPREL9 __RDBEXPREL10 _NAME
The Level Attribute catalog provides detailed information about level attributes. Each level attribute for each dimension level is represented by a member of the ___cwm.lvla.ent dimension. This dimension can be quite large, so you might want to use a command like the following to limit your view to the level attributes for a single dimension:
limit ___cwm.lvla.ent to (___cwm.lvla.cat(- ___cwm.lvla.prp, 'DIMENSION_NAME') eq 'GEOGRAPHY')
The following example lists the catalog entries for one of the geography level attributes. From this catalog, you can learn that the long names for cities are stored in a variable named __rdbattrvar19.
report ___cwm.lvla.cat ----------___CWM.LVLA.CAT---------- ----------___CWM.LVLA.ENT---------- ___CWM.LVLA.PRP 19 ------------------------- ----------------------------------- OWNER XADEMO DIMENSION_NAME GEOGRAPHY ATTRIBUTE_NAME GEOG_STD_CITY_LLABEL DISPLAY_NAME Long City Name(s) DESCRIPTION Long Labels for Cities values of the STANDARD GEOGRAPHY hierachy DETERMINED_BY_LEVEL_NAME L4 COLUMN_NAME GEOG_STD_CITY_LLABEL DATA_TYPE TEXT DIMID 6 9 XADEMO GEOGRAPHY LVLID 6 9 2 XADEMO GEOGRAPHY L4 LVLAID 6 9 2 20 XADEMO GEOGRAPHY L4 GEOG_STD_CITY_LLABEL RDBMS_ATTRVAR_NAME __RDBATTRVAR19
|
 Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|
