Strategy ONE

Convert Report Filters to Prompts

To convert report filters to prompts:

  1. Create a report filter qualification for an MDX cube report.
  2. Right-click the filter qualification and choosing Convert to Prompt.

When a report filter qualification is converted into a filter definition prompt, the type of filter definition prompt that is created depends on the type of filter qualification you convert. The following table below lists the prompt type created for different types of filter qualifications.

Filter Qualification Type Filter Definition Prompt Type Created

Attribute element list qualifications

An attribute element list prompt, based on the attribute of the attribute element list qualification. Any attribute elements selected as values for the filter qualification are converted into default answers for the attribute element list prompt.

Attribute form qualifications

An attribute prompt, based on the attribute of the attribute form qualification. The attribute form qualification is converted into the default answer for the attribute prompt.

Metric set qualifications

A metric prompt, based on the metric of the metric set qualification. The metric set qualification is converted into the default answer for the metric prompt.

Related Topics

Reporting on MDX Cubes

Analyzing Data with MDX Cube Reports

Prompts on MDX Cube Reports