HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Building Reports Using the Web Intelligence Java Report Panel 113
10
Building prompt filters on data providers
Overview
This chapter tells you how to build prompts to filter Web Intelligence documents. Each time
you refresh the document data, the prompts appear for you to specify the filter values you
want Web Intelligence to return to the document.
Prompts enable multiple users to return different data to the same document every time they
refresh the document data. You can create prompts that require you to specify an account
number, a date, a range of customer names, and so on.
This chapter explains how:
•
prompt filters work
• you add prompts to a document
• you apply multiple prompts to a single document
• you edit and remove prompts
What are prompts?
A prompt is a dynamic filter that displays a question every time you refresh the data in a
document. You answer prompts by either typing or selecting the value(s) you want to view
before you refresh the data. Web Intelligence retrieves only the values you specified from
the database and returns those values to the reports within the document. Prompts allow
multiple users viewing a single document to specify a different sub-set of the database
information and display it in the same report tables and charts. Prompts also reduce the
time it takes for the data to be retrieved from the database.
Example: Enable users in the Accounts department to specify the period for which
they want to view customer payment information
In this example, the document has a prompt filter on [Invoice Date] so that account
managers can specify a period, for which they want to display the payment status of
invoices by customer: