MicroStrategy ONE
Prompts on MDX Cube Reports
MicroStrategy automatically converts SAP BW variables into prompts when SAP BW cubes are imported into a project. In addition to these inherited prompts, you can create standard prompts for MDX cube sources in the same way as you can in MicroStrategy reports that access a data warehouse.
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.
You can display prompt details for MDX cube reports just as you can for standard reports by opening the Developer Preferences dialog, choosing Reports, Show report details, and then Include prompt details. This feature is especially useful if you want to display a summary of the variable elements that are used to answer the variable prompts.
There are two ways to create a standard prompt for an MDX cube report. You can convert report filters to prompts or create new prompts using the Prompt Generation Wizard for supported prompt types:
You can select attributes and metrics for your prompt definitions by browsing to the Data Explorer for your MDX cube source.
When you save a prompted report, whether it has inherited prompts converted from SAP BW variables or standard prompts, you can to save it as a static or prompted report. See the Basic Reporting Help for details on saving a prompted report.