What is the difference between prompt and filter in cognos

Pages and dashboards become much more effective for data reporting and analysis when you add interactivity to them. A single action in one report can cause other reports to refresh simultaneously and show the data associated with the action. Global filters are used to control the display of one or more reports in a single portal page or in a dashboard.

For example, a global filter can be on a report that contains only a prompt or prompt controls. This allows for a single selection to drive a number of reports at once. When a prompt answer is changed, all related reports refresh dynamically to show the data that answers the prompt. For example, if you answer a prompt for a country with Brazil, all related reports on the page are filtered to show the data for Brazil. When this is used in a dashboard, the context is passed to all corresponding tabs.

Perform the following tasks to set up a page or a dashboard with global filters:. Prepare the Reports. Create the Global Filters. Assemble the Reports on a Page. Before you start creating a page or a dashboard with global filters, you must know which reports you can use, and have the reports ready.

If you include reports from only one package, the global filters share parameters using the model item. If you include reports from different packages, the following conditions must be met:. All reports must use the same parameter name in their filter statements.

We do not recommend using the default parameter name, such as Parameter1. The Report Studio reports must follow the naming convention used in one of the other studios. In Analysis Studio the convention is [hierarchy name] , such as Order Method. Note: If the page contains only Report Studio reports, we recommend using the p[attribute name]Prompt convention, for example, pCountryPrompt.

A global filter is a value that is shared across different reports. At least one of the reports that you are using for the dashboard needs to contain a prompt or prompt control.

The prompted report is embedded into a page or a dashboard using the Cognos Viewer portlet and linked with other reports in the page using the global filter portlet properties.

The prompts that are used as global filters control the display of your chosen linked reports. If this functionality is implemented in a single page, the prompts control linked reports in different sections of the page. If the page is a dashboard with multiple tabs, the prompts can control the report filtering across tabs. A macro is a fragment of code that you can insert in the Select statement of a query or in an expression. A macro may contain one or more macro functions. A macro is delimited by a number sign at the beginning and at the end.

Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Big Data. Rosece June 26, 0 Comments. Hi, I have a doubt regarding prompts. Rosece Posted June 26, 0 Comments.

Terence Curran Posted June 26, 0 Comments. Thanks MF, Adding the trim fix the problem but now the prompt doesn't display the drop down list , I have to type the product name. Ok - so the issue is embedded blanks. It's probably as a result of the underlying data type of the Product item.

The simple answer is to add a prompt. This has many advantages, one of which is that you have absolute control of how and where the prompt appears.