sap_variables
The following production rules are the enhancements that were defined to support a variable value specification in a MDX SELECT statement. Variable support comprises a new clause containing the SAP variables and their values.
<select_statement> : [WITH <formula_specification>] SELECT [<axis_specification> [, <axis_specification>…]] FROM <cube_specification> [WHERE <slicer_specification>] [<cell_props>] [SAP VARIABLES <sap_variable> [[,] <sap_variable>…]]
<sap_variable> : <variable_name> <sign> [<option>] <variable_value>
<sign> : INCLUDING | EXCLUDING
<option> : = | > | >= | < | <= | <>
<variable_value> : <unique_member_name> | <unsigned_numeric_literal> | <dimension> | <string_value_expression> | <member> : <member> | <character_string_literal> : <character_string_literal> | <unsigned_numeric_literal> : <unsigned_numeric_literal>
Example
Specifying a Single Value for a Variable
SELECT [Measures].members ON COLUMS, NON EMPTY [ODB_CUST].members ON ROWS FROM [ODBOSCEN1/MKTBRANCH] SAP VARIABLES [ODBBRANC] INCLUDING [ODB_BRANC].[CHEM]
Excluding a Single Value for a Variable
SELECT [Measures].members ON COLUMS, NON EMPTY [ODB_CUST].members ON ROWSFROM [ODBOSCEN1/MKTBRANCH] SAP VARIABLES [ODBBRANC] EXCLUDING [ODB_BRANC].[CHEM]
Specifying an Interval as a Value Area for a Variable
SELECT [Measures].members ON COLUMS, NON EMPTY [0CALYEAR].members ON ROWSFROM [ODBOSCEN1/MKTCUST] SAP VARIABLES [ODBCUST] INCLUDING [ODB_CUST].[B01]:[ODB_CUST].[C05]
Specifying a List of Values and Intervals for a Selection Variable
SELECT [Measures].members ON COLUMS, NON EMPTY [ODB_BRANC].members ON ROWSFROM [ODBOSCEN1/MKTPROD] SAP VARIABLES [ODBPROD] INCLUDING [ODB_PROD].[CP01230111] [ODBPROD] INCLUDING [ODB_PROD].[LP10101190] [ODBPROD] INCLUDING [ODB_PROD].[PP98010102]:[ODB_PROD].[PR48666001]