Accessing metadata via connection-level methods

Schemas retrieved with olap.getSchema()

0RMP_MC21 , 0CRM_VC14 , 0CRM_MC03 , 0CBR_IS09 , 0CRM_WFM2 , 0D_FI_C01 , ZDMAD , 0IC_C03 , 0RT_C41 , 0CBR_IS05 , 0PS_C06 , ZDMDTCL , 0COPA_C04 , 0CRM_WFM4 , 0CRM_MC11 , FABCUBE5 , $INFOCUBE , 0RTL_MC01 , 0ISET_WBS , 0RTL_C01 , 0CBR_IS04 , 0D_FI_C02 , 0CRM_WFM5 , 0D_DECU , 0PC_C01 , 0SEM_C01 , 0SEM_C06 , 0RT_C72 , 0PA_C01 , 0CRM_C03 , 0NF_DS03 , 0CRM_CIC1 , 0PU_O43 , 0CBR_IS08 , 0CSAL_C03 , 0CSALMC03 , 0COPC_C09 , ZCSAL_C03 , 0CP_SLSC5 , LOVC_PAC1 , 0BCS_VC11 , 0FIAR_O03 , 0PAPA_C02 , 0CRM_C04 , 0BWVC_C33 , 0UCMA_C01 , 0RT_C01 , 0PS_C05 , 0CCA_C11 , ACHIMCUB1 , 0ECCS_C01 , 0CRM_WFM3 , 0CBR_IS07 , 0PA_C03 , 0RTL_MC02 , 0PS_C02 , 0PS_C07 , 0D_SD_C03 , 0CRM_VC12 , ACHIMCUB3 , 0RT_C02 , 0PE_C01 , 0SEM_C07 , 0OPA_C11 , 0ISET_PRJ , 0SD_C04 , 0MSA_C05 , 0D_PU_C01 , 0RPM_DS01 , 0CCA_C03

Cubes retrieved with olap.getCube()

$DATE

Measures of the Cube using cube.getFeature()

CAPACITY,

TaggedValues of first Measure

CATALOG_NAME $INFOCUBE
SCHEMA_NAME null
CUBE_NAME $DATE
MEASURE_NAME CAPACITY
MEASURE_UNIQUE_NAME [Measures].[CAPACITY]
MEASURE_CAPTION CAPACITY
MEASURE_GUID null
MEASURE_AGGREGATOR 001
DATA_TYPE INT4
NUMERIC_PRECISION 0
NUMERIC_SCALE 0
MEASURE_UNITS null
DESCRIPTION null

Dimensions retrieved with cube.getCubeDimensionAssociation() and getDimension()

0LOGSYS

First Dimension's TaggedValues

CATALOG_NAME $INFOCUBE
SCHEMA_NAME null
CUBE_NAME $DATE
DIMENSION_NAME 0LOGSYS
DIMENSION_CARDINALITY 000034
DIMENSION_GUID null
DIMENSION_ORDINAL 0
DIMENSION_TYPE 3
DIMENSION_CAPTION Source System
DIMENSION_UNIQUE_NAME [0LOGSYS]
DEFAULT_HIERARCHY [0LOGSYS]
DESCRIPTION null

First Dimension's Attributes

Dimension Attributes from dimension.getFeature()

[20LOGSYS]

TaggedValues of Dimension Attribute

PROPERTY_TYPE 1
CATALOG_NAME $INFOCUBE
SCHEMA_NAME null
CUBE_NAME $DATE
DIMENSION_UNIQUE_NAME [0LOGSYS]
HIERARCHY_UNIQUE_NAME [0LOGSYS]
LEVEL_UNIQUE_NAME
MEMBER_UNIQUE_NAME null
PROPERTY_NAME [20LOGSYS]
PROPERTY_CAPTION Key
DATA_TYPE CHAR
CHARACTER_MAXIMUM_LENGTH 0
CHARACTER_OCTET_LENGTH 0
NUMERIC_PRECISION null
NUMERIC_SCALE null
DESCRIPTION null
, [50LOGSYS]

Hierarchies from Dimension

Source System

TaggedValue from Hierarchy

CATALOG_NAME $INFOCUBE
SCHEMA_NAME null
CUBE_NAME $DATE
DIMENSION_UNIQUE_NAME [0LOGSYS]
DIMENSION_TYPE 3
HIERARCHY_NAME Source System
HIERARCHY_UNIQUE_NAME [0LOGSYS]
HIERARCHY_GUID null
HIERARCHY_CAPTION Source System
HIERARCHY_CARDINALITY 000034
DEFAULT_MEMBER [0LOGSYS].[All]
ALL_MEMBER [0LOGSYS].[All]
DESCRIPTION null

Level retrieved with hierarchy.getHierarchyLevelAssociation() and getCurrentLevel()

LEVEL00 , LEVEL01
, DATE_FL , FROM , NUMBER , TO_DEST , 0CALDAY , Measures
, ...and 1258 other Cube(s).


Accessing metadata via object finder methods

Find method findCube(String schemaname,String CubeName)

Found cube:

$0D_SD_C03

Find method findDimensionFirst(Cube cube,String dimensionName)

Found dimension:

0D_COUNTRY

Find method findHierarchy(Dimension dimension,String hierarchyName)

Found hierarchies

0D_COUNTRY , PM_COUNTRY


Accessing metadata via JMI methods

Iterating the Dimensions of a Cube via Cube Dimension Associations

0D_COUNTRY , 0D_CO_CODE , 0D_DEBCRED , 0D_DIS_CHAN , 0D_DIV , 0D_DOCCLASS , 0D_MATERIAL , 0D_PAYER , 0D_PLANT , 0D_REGION , 0D_SALE_GRP , 0D_SALE_ORG , 0D_SHIPTO , 0D_SOLD_TO , 0D_VERSION , 0D_VTYPE , 0CALMONTH , 0CALYEAR , 0FISCVARNT , 0BASE_UOM , 0STAT_CURR , Measures

Iterating the Hierarchies of a Dimension

0D_COUNTRY , PM_COUNTRY

Iterating the Levels of a Hierarchy via Hierarchy Level Associations

LEVEL00 , LEVEL01


Accessing member data for a Level

CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_UNIQUE_NAME LEVEL_NUMBER MEMBER_NAME MEMBER_UNIQUE_NAME MEMBER_ORDINAL MEMBER_TYPE MEMBER_GUID MEMBER_CAPTION CHILDREN_CARDINALITY PARENT_LEVEL PARENT_UNIQUE_NAME PARENT_COUNT DESCRIPTION
$INFOCUBE null $0D_SD_C03 [0D_COUNTRY] [0D_COUNTRY] [0D_COUNTRY].[LEVEL01] 01 AU [0D_COUNTRY].[AU] 0 01 null Australia 0 0 null 0 null
$INFOCUBE null $0D_SD_C03 [0D_COUNTRY] [0D_COUNTRY] [0D_COUNTRY].[LEVEL01] 01 CA [0D_COUNTRY].[CA] 000001 01 null Canada 0 0 null 0 null
$INFOCUBE null $0D_SD_C03 [0D_COUNTRY] [0D_COUNTRY] [0D_COUNTRY].[LEVEL01] 01 DE [0D_COUNTRY].[DE] 000002 01 null Germany 0 0 null 0 null
$INFOCUBE null $0D_SD_C03 [0D_COUNTRY] [0D_COUNTRY] [0D_COUNTRY].[LEVEL01] 01 FR [0D_COUNTRY].[FR] 000003 01 null France 0 0 null 0 null
$INFOCUBE null $0D_SD_C03 [0D_COUNTRY] [0D_COUNTRY] [0D_COUNTRY].[LEVEL01] 01 GB [0D_COUNTRY].[GB] 000004 01 null England 0 0 null 0 null
$INFOCUBE null $0D_SD_C03 [0D_COUNTRY] [0D_COUNTRY] [0D_COUNTRY].[LEVEL01] 01 US [0D_COUNTRY].[US] 000005 01 null USA 0 0 null 0 null
$INFOCUBE null $0D_SD_C03 [0D_COUNTRY] [0D_COUNTRY] [0D_COUNTRY].[LEVEL01] 01 # [0D_COUNTRY].[#] 000006 01 null # 0 0 null 0 null