References to OLAP Catalog Metadata

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.

Cubes

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

Measures

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

Dimensions

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

Hierarchies

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

Levels

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

Level Attributes

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