Information Catalog Manager Administration Guide

Metadata mappings between the Information Catalog Manager and OLAP server

Table 28 shows the mapping of OLAP server metadata to the Information Catalog Manager common object types. OLAP server metadata refers to metadata for DB2 OLAP Server, DB2 OLAP Integration Server, or Hyperion Essbase Server.

When you publish DB2 OLAP Integration Server metadata, a linked relationship is created between a "dimensions within a multi-dimensional database" object type in the information catalog and a table object in the DB2 OLAP Integration Server.

The left column of the table shows the name of the Essbase API structure. The right column shows the Information Catalog Manager object and object type properties.

Table 28. Mapping of OLAP server metadata to the Information Catalog Manager common object types
OLAP server metadata Information Catalog Manager metadata
Outline Multidimensional databases
Four part name of the OLAP object in the following format: server.application.database.outline Name
Message indicating width and depth limits Long description
OLAP server (part 1 of Name) Database host server name
OLAP database (part 3 of Name) Database or subsystem name
N/A Database type

The value of this property is MULTIDIMENSIONAL.

usOutlineType in ESB_OUTLINEINFO_T Database extended type

The value for this property can be NORMAL or CURRENCY.

N/A Database status

The value for this property is PRODUCTION.

Dimensions in an outline Dimension within a multidimensional database
Dimension alias from EssOtlGetMemberAlias or name Name
OLAP server Database host server name
OLAP database Database or subsystem name
OLAP application Using application name
Dimension name Dimension name
usCategory in ESS_MBRINFO_T Dimension class or type
Members in a dimension Members within a multidimensional database
Member alias from EssOtlGetMemberAlias or name Name
OLAP server Database host server name
OLAP database Database or subsystem name
OLAP application Using application name
Dimension name Dimension name
Member name Member name
last calc string or calc string from EssGetMemberCalc Derived from
usShare in ESS_MBRINFO_T This property is treated as a shared member (a member with multiple parents).


[ Top of Page | Previous Page | Next Page ]