Creation of Prompts and Filters

When we create Prompts and Filters, it is better to avoid using functions to get or modify the Prompt or Filter values such as Substring, IfNull, Cast, ValueOf and so on. Inclusion of such prompts in the dashboard pages or as filters in Requests might degrade the performance of the Requests/Dashboards associated with it. It is advisable to use the direct column values for creating Prompts and Filters.

It is a best practice to enforce the Dashboard Prompts to have default values associated with it, so that the Dashboard Requests (which have filters on the same columns) can benefit from the default values, as it will result in analyzing the request on a much smaller subset of the Fact/Aggregate Fact data.

For more information, see:

• Mandatory Prompts