In SAP NetWeaver Business Warehouse,variablesare a means of parametrizing queries.
Variables can also be used in Open Analysis Interfaces using various BW-specific enhancements to the MDX syntax. In this context, variables are called SAP variables.
For more information about BW-specific enhancements, see:
The open analysis interfaces provide variables as placeholders for the following objects:
Name in SAP NetWeaver Business Intelligence | Name in OLE DB for OLAP Specification |
---|---|
Characteristic values, hierarchy nodes, pre-calculated value sets |
MEMBER_UNIQUE_NAME |
Hierarchies |
HIERARCHY_UNIQUE_NAME |
Formula variables |
Number values |
Variables for characteristic values, hierarchy nodes and pre-calculated value sets differ in the following ways with regard to the SAP VARIABLES schema rowset REFERENCE_HIERARCHY:
More information:BW-Specific Enhancement: SAP VARIABLES Schema Rowset.
Variables can be displayed as follows:
single value such as a MEMBER_UNIQUE_NAME
interval as value area
complex selection of values (such as a list of single values or intervals connected to one another with OR).
Selection options (special selection options can be entered via <option>, seeBW-Specific Enhancement: MDX Syntax)
For more information about variables in BW, see the Business Explorer documentation under the following links: