Show TOC

Export Parameter: LevelsLocate this document in the navigation structure

Export Parameter: Levels

Short text

Result: LEVELS

Significance

The Levels export parameter returns DIMENSIONS as a result.

The parameter consists of a table with the following fields:

Name

Description

CAT_NAM

CATALOG name, to which the CUBE belongs

CUBE_NAM

CUBE name

DIM_UNAM

Dimension unique name

HRY_UNAM

Hierarchy unique name

LVL_NAM

Hierarchy level unique name

LVL_UNAM

Hierarchy level unique name

LVL_UID

Unique ID (UUID) in compressed form

LVL_CAP

Caption

LVL_NUMBER

Distance of member from root node (root = 0)

LVL_CARDINALITY

Level cardinality (estimated number of members)

LVL_TYPE

Level type (year,month,day..)

DSCRPTN

Description