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). |