When SAP BW Variables are configured on BEx Query Cube InfoProviders, you are prompted to provide the replacement value for the SAP BW Variable before submitting the query.
Prompting occurs when you click Finish when completing the Document Creation wizard, or when you click OK after modifying a query using the Data Layout interface.
To provide SAP BW Variable values when prompted:
In Database Variables ServerName, read the record for each variable.
It is important to know the variable type, a characteristic value or a hierarchy node.
Click the Edit cell for a variable record.
The Dimension Browser dialog box is displayed. If the record is a characteristic value, you must select one explicit value at the lowest level of the dimension hierarchy. If the variable is a hierarchy node, you can select a value in the dimensional hierarchy.
Select a characteristic value for the variable type, and click OK.
Repeat steps 2 and 3 until all variables are assigned values for the query.