This method delivers a list of variables with processing through'Manual Entry' to a QUERY_CUBE .
The following information is delivered for every variable:
CAT_NAM: Name of CATALOGS (InfoCubes) to which the QUERY_CUBEbelongs
CUBE_NAM: Name of CUBE in which the variable is used
VAR_NAM: Variable name. Restricted by delimitter '['.
VAR_CAP: Short description of variables
VAR_UID: Variable GUID
VAR_ORDINAL: Sort sequence of variables within the query
VAR_TYPE: Type of variables. This field displays for what kindof object the variable stands for as a placeholder. The field can adoptthe following values:
,, ,,SAP_VAR_TYPE_MEMBER
,, ,,SAP_VAR_TYPE_HIERARCHY
,, ,,SAP_ VAR _TYPE_NUMERIC
,,
DATA_TYPE: ABAP Data type of variables. This is either CHAR fortypes SAP_VAR_TYPE_MEMBER and SAP_VAR_TYPE_HIERARCHY or FLTP for typeAP_ VAR _TYPE_NUMERIC
CHR_MAX_LEN: Max. length of a variable value.
VAR_PROC_TYPE: Processing type of variable. On the MDPROVIDERBAPI, only variables with the processing type 'Manual Entry' aredelivered. The value for this column is always _PROC_TYPE_USER_INPUTwith 2.0
VAR_SELC_TYPE: Selection type for variables. This field displayswhether the variable allows an individual value, an interval or acomplex selection of characteristic values. Possible values are:
,,,,SAP_ VAR _SEL_TYPE_VALUE
,,,,SAP_ VAR _SEL_TYPE_INTERVAL
,,,,SAP_ VAR _SEL_TYPE_COMPLEX
,,,,
VAR_ENTRY_TYPE: Mandatory entry for variables. This column canhave one of the following values:
,,,,
,,,, SAP_ VAR _INPUT_TYPE_OPTIONAL
,,,, SAP_ VAR _INPUT_TYPE_MANDATORY
,,,, SAP_ VAR _INPUT_TYPE_MANDATORY_NOT_INITIAL
REF_DIM: For variables of type SAP_VAR_TYPE_MEMBER, this fieldspecifies which dimension values you can select from for the variables.
REF_HRY: For variables of type SAP_VAR_TYPE_MEMBER, this fieldspecifies which hierarchy values you can select from for the variable.
DFLT_LOW: Maintained proposed value for variables, should oneexist
DFLT_HIGH: Maintained to-proposed value, should one exist
DFLT_LOW_CAP: Text for maintained proposed value, should oneexist
DFLT_HIGH_CAP: Text for maintain until- proposed value, shouldone exist
DSCRPTN: Long text for variables
The MDX Grammar has been enhanced with a SAP specific variable clause.This has the following general structure:
<(><<)>select_statement> ::= [WITH <(><<)>formula_specification>]
,,,,,,SELECT [<(><<)>axis_specification>[,<(><<)>axis_specification>]…]
,,,,,,FROM [<(><<)>cube_specification>]
,,,,,,WHERE [<(><<)>slicer_specification>]
,,,,,,[<(><<)>cell_props>]
,,,,,,[<(><<)>sap_variables>]
<(><<)>sap_variables> : SAP VARIABLES <(><<)>sap_variables_list>
,,,,,,,,|<(><<)>sap_variables_list> ',' <(><<)>sap_variable>
<(><<)>sap_variable> :,,<(><<)>variable_name> <(>
<<)>variable_value_list>
<(><<)>variable_value_list>: ,,<(><<)>variable_value_specification>
,,,,,,,,|<(><<)>variable_value_list> <(>
<<)>variable_value_specification>
<(><<)>variable_value_specification>:,,<(>
<<)>var_single_value_specification>
,,,,,,,,,,|<(><<)>var_interval_value_specification>
<(><<)>var_single_value_specification> : <(><<)>sign> <(>
<<)>variable_value>
<(><<)>var_interval_value_specification> :,,<(><<)>sign> <(>
<<)>variable_value>':'< variable_value>
<(><<)>sign> :,,INCLUDING,,
,,,,|EXCLUDING,,
<(><<)>variable_value> :,,,,<(><<)>member>
,,,,,,,,|<(><<)>unsigned_numeric_literal>Example ,,1. This example sets an individual value for the variable[ODBBRANC]
select [DUYZ7E3E5GH2F0W4D7OGO6RKD].members on columns,
non empty [ODB_CUST].members on rows from [ODBOSCEN1/MKTBRANCH]
SAP VARIABLES [ODBBRANC] INCLUDING [ODB_BRANC].[CHEM]
,,2. This example excludes an individual variable
select [DUYZ7E3E5GH2F0W4D7OGO6RKD].members on columns,
non empty [ODB_CUST].members on rows from [ODBOSCEN1/MKTBRANCH]
SAP VARIABLES [ODBBRANC] EXCLUDING [ODB_BRANC].[CHEM]
3. This example specifies an interval
select [2M19UOW3BTEMXNZMHSSSEP631].members on columns, non empty[0CALYEAR].members on rows from [ODBOSCEN1/MKTCUST]
SAP VARIABLES [ODBCUST] INCLUDING [ODB_CUST].[B01] :[ODB_CUST].[C05]
4. This example specifies a complex selection
select [4G3SFZOHUNDFDZN137S0IQ425].members on columns, non empty[ODB_BRANC].members on rows from [ODBOSCEN1/MKTPROD] SAP VARIABLES[ODBPROD] INCLUDING [ODB_PROD].[CP01230111] INCLUDING
[ODB_PROD].[LP10101190] INCLUDING[ODB_PROD].[PP98010102]:[ODB_PROD].[PR48666001] |