MicroStrategy ONE
Mapping SAP BW Variables to MicroStrategy Prompts
Variables in SAP BW allow users to enter values as parameters for the queries on a cube. SAP BW variables are represented as MicroStrategy prompts when they are imported into the MicroStrategy environment. For information on how SAP BW variables are converted into MicroStrategy prompts, see Relating Objects from SAP BW to MicroStrategy.
The mapping between variables and prompts can be viewed in the Cube Mapping tab of the MDX Cube Catalog or in the MDX Cube Editor. Both interfaces list all the variables that were converted to prompts.
To allow attribute element searches on MDX cube reports for SAP BW cubes that include variables, within your SAP BW system, you must either define the variables as optional, or provide a default answer for the required variables. The MicroStrategy prompt that is mapped to the SAP BW variable can be either optional or required.
See the following topics to learn how to define SAP BW variable as key date variables, support variable qualifications, and to use one prompt for variables in separate cubes:
You can also perform the following mapping and configuration tasks for SAP BW variables and their associated MicroStrategy prompts:
- To view any variable's properties, right-click its name in the Physical View column, and then choose Properties.
- To edit prompts created by the import process, right-click the prompt in the Logical View column, and choose Edit.
- To rename a prompt, right-click the prompt in the Logical View column and select Rename.
-
To map an SAP BW variable to a specific prompt in the MicroStrategy project, right-click the project and select Map.