MDX Leveling

Definition

OLE DB defines interfaces for access to data types that can be stored in different data stores.

In accordance with OLE DB for OLAP criteria, SAP NetWeaver Business Intelligence has implemented a large part of the specified leveling rules. To get the latest information about BW-specific special features, third-party client applications can check the settings specified in the property set DBPROPSET_DATASOURCEINFO for BW-OLE DB for OLAP providers.

Use

SAP NetWeaver Business Warehouse supports the following leveling rules:

Leveling Rule	Property ID and Values
Type of DataSource The DataSource type is always 'multi-dimensional'.	ID: DBPROP_DATASOURCE_TYPE Value: DBPROPVAL_DST_MDP
Flattening Flattening is fully supported.	ID: MDPROP_FLATTENING_SUPPORT Value: MDPROPVAL_FS_FULL_SUPPORT
Named Level Levels with names are supported.	ID: MDPROP_NAMED_LEVEL Value: MDPROPVAL_NL_NAMEDLEVELS
Join Cubes Join Cubes are not supported.	ID: MDPROP_MDX_JOINCUBE Value: MDPROPVAL_MJC_SINGLECUBE
Number of Axes 10 axes are currently supported. Additional restrictions apply to the number of Dimensions and Hierarchies that are allowed to be used at the same time in a MDX command: A maximum of 48 Dimensions, in addition to the MEASURES Dimension A maximum of one Hierarchy for each Dimension.	ID: MDPROP_AXES
Refreshing Cell Data Refreshing cell data is not supported.	ID: MDPROP_AGGREGATECELL_UPDATE Value: MDPROPVAL_AU_UNSUPPORTED
RangeRowsets RangeRowsets are only read.	ID: MDPROP_RANGEROWSET Value: MDPROPVAL_RR_READONLY
Filters/Slicer Axis BW supports several tuples in a filter, providing that these tuples belong to precisely one and the same dimension or that they can be created as a CROSSJOIN(s) across sets to one and the same Dimension. In addition, you can use the AGGREGATE function to enable multiple filters (see Examples for CALCULATED MEMBER).	ID: MDPROP_MDX_SLICER Value: MDPROPVAL_MS_MULTIPLETUPLES
Outer Reference Outer reference is not supported.	ID: MDPROP_MDX_OUTERREFERENCE Value: Zero
Using Attributes (MDX: Properties) BW supports queries using dimension properties in a MDX statement.	ID: MDPROP_MDX_QUERYBYPROPERTY
Case commands Case commands are not supported.	ID: MDPROP_MDX_CASESUPPORT Value: Zero
String Comparison BW only supports the "equal" and "unequal" comparison operators for strings.	ID: MDPROP_MDX_STRING_COMPOP Value: Zero
Descendants Flags SELF, BEFORE and AFTER are supported in all combinations.	ID: MDPROP_MDX_DESCFLAGS Value: MDPROPVAL_MD_SELF MDPROPVAL_MD_BEFORE MDPROPVAL_MD_AFTER
Set Functions As well as the standard functions, the following functions are also supported: TOPPERCENT, BOTTOMPERCENT, TOPSUM, BOTTOMSUM, DRILLDOWNMEMBER, DRILLDOWNLEVEL, DRILLDOWNMEMBERTOP, DRILLDOWNMEMBERBOTTOM, DRILLDOWNLEVELTOP, DRILLDOWNLEVELBOTTOM, DRILLUPMEMBER, DRILLUPLEVEL, PERIODSTODATE, LASTPERIODS, YTD, QTD, MTD, WTD.	ID: MDPROP_MDX_SET_FUNCTIONS Value: MDPROPVAL_MSF_TOPPERCENT MDPROPVAL_MSF_BOTTOMPERCENT MDPROPVAL_MSF_TOPSUM MDPROPVAL_MSF_BOTTOMSUM MDPROPVAL_MSF_DRILLDOWNMEMBER MDPROPVAL_MSF_DRILLDOWNLEVEL MDPROPVAL_MSF_DRILLDOWNMEMBERTOP MDPROPVAL_MSF_DRILLDOWNMEMBERBOTTOM MDPROPVAL_MSF_DRILLDOWNLEVELTOP MDPROPVAL_MSF_DRILLDOWNLEVELBOTTOM MDPROPVAL_MSF_DRILLUPMEMBER MDPROPVAL_MSF_DRILLUPLEVEL MDPROPVAL_MSF_YTD MDPROPVAL_MSF_QTD MDPROPVAL_MSF_MTD MDPROPVAL_MSF_WTD
Member Functions As well as the standard functions, the following functions are also supported: COUSIN, PARALLELPERIOD, OPENINGPERIOD, CLOSINGPERIOD.	ID: MDPROP_MDX_MEMBER_FUNCTIONS Value: MDPROPVAL_MMF_COUSIN MDPROPVAL_MMF_PARALLELPERIOD MDPROPVAL_MMF_OPENINGPERIOD MDPROP_MMF_CLOSINGPERIOD
Numerical Functions As well as the standard functions, the following functions are also supported: MEDIAN, VAR, STDDEV, RANK; AGGREGATE, COVARIANCE, CORRELATION, LINREGSLOPE, LINREGVARIANCE, LIGREGR2, LINREGPOINT	ID: MDPROP_MDX_NUMERIC_FUNCTIONS Value: MDPROPVAL_MNF_MEDIAN MDPROPVAL_MNF_VAR MDPROPVAL_MNF_STDDEV MDPROPVAL_MNF_RANK MDPROPVAL_MNF_AGGREGATE MDPROPVAL_MNF_COVARIANCE MDPROPVAL_MNF_CORRELATION MDPROPVAL_MNF_LINREGSLOPE MDPROPVAL_MNF_LINREGVARIANCE MDPROPVAL_MNF_LIGREGR2 MDPROPVAL_MNF_LINREGPOINT
Formulas WITH SET/MEMBER and CREATE SET/MEMBER are supported in the local and in the SESSION context.	ID: MDPROP_MDX_FORMULAS Value: MDPROPVAL_MF_WITH_NAMEDSETS MDPROPVAL_MF_CREATE_NAMEDSETS MDPROPVAL_MF_WITH_CALCMEMBERS MDPROPVAL_MF_CREATE_ CALCMEMBERS MDPROPVAL_MF_SCOPE_SESSION
Numerical Functions in SET Commands BW supports statements with Dimensions.	ID: MDPROP_MDX_NONMEASURE_EXPRESSONS Value: MDPROPVAL_NME_ALLDIMENSIONS

Leveling Rule

Property ID and Values

Type of DataSource

The DataSource type is always 'multi-dimensional'.

ID: DBPROP_DATASOURCE_TYPE

Value: DBPROPVAL_DST_MDP

Flattening

Flattening is fully supported.

ID: MDPROP_FLATTENING_SUPPORT

Value: MDPROPVAL_FS_FULL_SUPPORT

Named Level

Levels with names are supported.

ID: MDPROP_NAMED_LEVEL

Value: MDPROPVAL_NL_NAMEDLEVELS

Join Cubes

Join Cubes are not supported.

ID: MDPROP_MDX_JOINCUBE

Value: MDPROPVAL_MJC_SINGLECUBE

Number of Axes

10 axes are currently supported.

Additional restrictions apply to the number of Dimensions and Hierarchies that are allowed to be used at the same time in a MDX command:

A maximum of 48 Dimensions, in addition to the MEASURES Dimension
A maximum of one Hierarchy for each Dimension.

ID: MDPROP_AXES

Refreshing Cell Data

Refreshing cell data is not supported.

ID: MDPROP_AGGREGATECELL_UPDATE

Value: MDPROPVAL_AU_UNSUPPORTED

RangeRowsets

RangeRowsets are only read.

ID: MDPROP_RANGEROWSET

Value: MDPROPVAL_RR_READONLY

Filters/Slicer Axis

BW supports several tuples in a filter, providing that these tuples belong to precisely one and the same dimension or that they can be created as a CROSSJOIN(s) across sets to one and the same Dimension.

In addition, you can use the

AGGREGATE

function to enable multiple filters (see Examples for CALCULATED MEMBER).

ID: MDPROP_MDX_SLICER

Value: MDPROPVAL_MS_MULTIPLETUPLES

Outer Reference

Outer reference is not supported.

ID: MDPROP_MDX_OUTERREFERENCE

Value: Zero

Using Attributes (MDX: Properties)

BW supports queries using dimension properties in a MDX statement.

ID: MDPROP_MDX_QUERYBYPROPERTY

Case commands

Case commands are not supported.

ID: MDPROP_MDX_CASESUPPORT

Value: Zero

String Comparison

BW only supports the "equal" and "unequal" comparison operators for strings.

ID: MDPROP_MDX_STRING_COMPOP

Value: Zero

Descendants Flags

SELF, BEFORE and AFTER are supported in all combinations.

ID: MDPROP_MDX_DESCFLAGS

Value: MDPROPVAL_MD_SELF MDPROPVAL_MD_BEFORE MDPROPVAL_MD_AFTER

Set Functions

As well as the standard functions, the following functions are also supported:

TOPPERCENT, BOTTOMPERCENT, TOPSUM, BOTTOMSUM, DRILLDOWNMEMBER, DRILLDOWNLEVEL, DRILLDOWNMEMBERTOP, DRILLDOWNMEMBERBOTTOM, DRILLDOWNLEVELTOP, DRILLDOWNLEVELBOTTOM, DRILLUPMEMBER, DRILLUPLEVEL, PERIODSTODATE, LASTPERIODS, YTD, QTD, MTD, WTD.

ID: MDPROP_MDX_SET_FUNCTIONS

Value: MDPROPVAL_MSF_TOPPERCENT MDPROPVAL_MSF_BOTTOMPERCENT MDPROPVAL_MSF_TOPSUM MDPROPVAL_MSF_BOTTOMSUM MDPROPVAL_MSF_DRILLDOWNMEMBER MDPROPVAL_MSF_DRILLDOWNLEVEL MDPROPVAL_MSF_DRILLDOWNMEMBERTOP MDPROPVAL_MSF_DRILLDOWNMEMBERBOTTOM MDPROPVAL_MSF_DRILLDOWNLEVELTOP MDPROPVAL_MSF_DRILLDOWNLEVELBOTTOM MDPROPVAL_MSF_DRILLUPMEMBER MDPROPVAL_MSF_DRILLUPLEVEL MDPROPVAL_MSF_YTD MDPROPVAL_MSF_QTD MDPROPVAL_MSF_MTD MDPROPVAL_MSF_WTD

Member Functions

As well as the standard functions, the following functions are also supported:

COUSIN, PARALLELPERIOD, OPENINGPERIOD, CLOSINGPERIOD.

ID: MDPROP_MDX_MEMBER_FUNCTIONS

Value: MDPROPVAL_MMF_COUSIN MDPROPVAL_MMF_PARALLELPERIOD MDPROPVAL_MMF_OPENINGPERIOD MDPROP_MMF_CLOSINGPERIOD

Numerical Functions

As well as the standard functions, the following functions are also supported:

MEDIAN, VAR, STDDEV, RANK; AGGREGATE, COVARIANCE, CORRELATION, LINREGSLOPE, LINREGVARIANCE, LIGREGR2, LINREGPOINT

ID: MDPROP_MDX_NUMERIC_FUNCTIONS

Value: MDPROPVAL_MNF_MEDIAN MDPROPVAL_MNF_VAR MDPROPVAL_MNF_STDDEV MDPROPVAL_MNF_RANK MDPROPVAL_MNF_AGGREGATE MDPROPVAL_MNF_COVARIANCE MDPROPVAL_MNF_CORRELATION MDPROPVAL_MNF_LINREGSLOPE MDPROPVAL_MNF_LINREGVARIANCE MDPROPVAL_MNF_LIGREGR2 MDPROPVAL_MNF_LINREGPOINT

Formulas

WITH SET/MEMBER and CREATE SET/MEMBER are supported in the local and in the SESSION context.

ID: MDPROP_MDX_FORMULAS

Value: MDPROPVAL_MF_WITH_NAMEDSETS MDPROPVAL_MF_CREATE_NAMEDSETS MDPROPVAL_MF_WITH_CALCMEMBERS MDPROPVAL_MF_CREATE_ CALCMEMBERS MDPROPVAL_MF_SCOPE_SESSION

Numerical Functions in SET Commands

BW supports statements with Dimensions.

ID: MDPROP_MDX_NONMEASURE_EXPRESSONS

Value: MDPROPVAL_NME_ALLDIMENSIONS