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 BI-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 Intelligence 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 |
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 BI 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) BI 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 BI 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 |
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 |
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 |
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 |
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 |
Numerical Functions in SET Commands BI supports statements with Dimensions. |
ID: MDPROP_MDX_NONMEASURE_EXPRESSONS Value: MDPROPVAL_NME_ALLDIMENSIONS |