MicroStrategy ONE

Using prompts in 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.

If you are using SAP BW, in addition to the prompts described above, an MDX cube report can also contain prompts that represent SAP BW variables. For more information, see Prompts in MDX cube sources and Supporting key date variables in SAP BW.

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.

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. Both of these techniques are described below:

  • Converting report filters to prompts: After you create a report filter qualification for an MDX cube report, you can convert the filter qualification into a prompt in the Report Editor by right-clicking the filter qualification and selecting Convert to Prompt. This process is described in Converting report filters on MDX cube reports to prompts.

  • Prompt Generation Wizard: This procedure is the same as for a standard MicroStrategy prompt. Prompts in MDX cube reports can only access objects that are included in an MDX cube report's associated MDX cube. Therefore, when using the Prompt Generation Wizard to create prompts for an MDX cube report, it is important that the prompt only contain objects from the associated MDX cube. Steps to create this type of prompt are the same as for standard reports.

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.

For information on using prompts in MDX cube reports as well as the supported prompt types, see the MDX Cube Reporting Help.