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

Filtering data retrieval using query filters84
$130K. To create a document with only the information you need, you apply the following
query filters:
Year = 200
Quarter = Q$
State = Texas
Margin >= 130,000
To avoid displaying the filtered values Texas, 2002, and Q4 in the table columns Year,
Quarter, and State, you exclude the [Year], [Quarter], and [State] objects from the Result
Objects pane. When you generate the report, the report values correspond to Texas stores
with 4Q 2002 margins greater than or equal to $130K:
This enables you to filter the report for the specific values that interest you and to minimize
the values displayed in the table.
The difference between query filters and report filters
You can apply filters at two levels within a document:
• query filters – these filters are defined on the query; they limit the data retrieved from
the data source and returned to the Web Intelligence document
• report filters – these filters limit the values displayed on reports, tables, charts, sections
within the document, but they don’t modify the data that is retrieved from the data
source; they simply hide values at the report level
Query filters
You define query filters in Query View. Users without the security profile to edit the query
cannot modify the query filters you define. This ensures that the data saved with a
document is appropriate for those who view or analyze the data within that document.
Note: Query filters decrease the time it takes to run the reports in the document and limit
the size of the document to the data relevant to the users who consult it. Query filters also
ensure document security.
Report filters
Filters you apply to the data displayed in the report are called report filters. You use report
filters to limit the values displayed in the reports within a document. You can filter each
Store name Sales revenue Margin
e-Fashion Houston $307,914 $133,802
e-Fashion Houston Leighton $316,252 $136,055