Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
Creating an Analytic Workspace From Relational Tables, 6 of 6
When you are viewing the catalogs, it will help you to understand how references are formed to OLAP catalog metadata definitions in the database. They are constructed as a concatenation of the number of characters for each part of the name followed by the various parts. References to various metadata objects that appeared in "Analytic Workspace Metadata Catalogs" are described here.
The CBID
property in the catalogs references the cubes defined in the OLAP catalog. It has the following format:
owner_chars cube_chars owner_name cube_name
The following example identifies a cube owner of XADEMO
(6 characters) and a cube name of ANALYTIC_CUBE
(13 characters).
6 13 XADEMO ANALYTIC_CUBE
The MEASID
property in the catalogs references the measures defined in the OLAP catalog. It has the following format:
owner_chars cube_chars meas_chars owner_name cube_name meas_name
The following example identifies a cube owner of XADEMO
(6 characters), a cube name of ANALYTIC_CUBE
(13 characters), and a measure name of F_SALES
(7 characters):
6 13 7 XADEMO ANALYTIC_CUBE F.SALES
The DIMID
property in the catalogs references the dimensions defined in the OLAP catalog. It has the following format:
owner_chars dim_chars owner_name dim_name
The following example identifies a dimension owner of XADEMO
(6 characters) and a dimension name of GEOGRAPHY
(9 characters):
6 9 XADEMO GEOGRAPHY
The HIERID
property in the catalogs references the hierarchies defined in the OLAP catalog. It has the following format:
owner_chars dim_chars hier_chars owner_name dim_name hier_name
The following example identifies a dimension owner of XADEMO
(6 characters), a dimension name of GEOGRAPHY
(9 characters), and a hierarchy name of STANDARD
(8 characters):
6 9 8 XADEMO GEOGRAPHY STANDARD
The LVLID
property in the catalogs references the hierarchy levels defined in the OLAP catalog. It has the following format:
owner_chars dim_chars lvl_chars owner_name dim_name lvl_name
The following example identifies a dimension owner of XADEMO
(6 characters), a dimension name of GEOGRAPHY
(9 characters), and a level name of L3
(2 characters):
6 9 2 XADEMO GEOGRAPHY L3
The LVLAID
property in the catalogs references the level attributes defined in the OLAP catalog. It has the following format:
owner_chars dim_chars lvl_chars attr_chars owner_name dim_name lvl_name attr_name
The following example identifies a dimension owner of XADEMO
(6 characters), a dimension name of GEOGRAPHY
(9 characters), a level of L4
(2 characters), and an level attribute name of GEOG_STD_CITY_LLABEL
(20):
6 9 2 20 XADEMO GEOGRAPHY L4 GEOG_STD_CITY_LLABEL
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|