Adding Prompts to Filter Data

You can add prompts to a report to add interactivity for users. Prompts act as questions that help users to customize the information in a report to suit their own needs. For example, you create a prompt so that users can select a product type. Only products belonging to the selected product type are retrieved and shown in the report.

Prompts are composed of three interrelated components: parameters, prompt controls, and parameter values. Parameters are based on parameterized filters and form the questions to ask users. Prompt controls provide the user interface in which the questions are asked. Parameter values provide the answers to the questions.

Report Studio provides several ways to create prompts. You can

• use the Build Prompt Page tool

• build your own prompt and prompt page

• create a parameter to produce a prompt

• insert prompts directly into the report page

• in dimensional reporting, you can also define prompts using context filters

If you include reports from different packages in an interactive dashboard that uses global filters, ensure that you use the same parameter name for the prompt in all the reports. For more information about creating interactive dashboards, see the Administration and Security Guide.

You can also create prompts in the package. For more information, see the Framework Manager User Guide.

Syntax of Prompt Expressions

Prompt expressions use the following syntax, where p represents the parameter name.