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 85
report to display a different subset of the same data. The data hidden by the report filters
remains saved with the Web Intelligence document. You can modify the report filters to
display different data in the report or remove the report filters altogether to display all the
data defined in the query. You define report filters in Report View.
For information on using report filters, see ”How report filters work” on page 239.
Note: When you add a report filter, it is possible to create an aggregation context that
Web Intelligence is unable to process because you have made some of the objects in the
report incompatible. For more information on incompatible objects, see ”About
Incompatible objects in data providers” on page 52.
What makes up a filter?
To create a filter, you need to specify three elements:
• a filtered object
• an operator
• a value(s) or comparison object
Example: Filtering the data source to retrieve only values for the Accessories product
line
For example, to display data only for the Accessories product line, you select:
When you run the query, Web Intelligence applies the operator to the filtered object and
retrieves the value(s) from the database that correspond to the value(s) you specified.
You can filter multiple objects in a query. For example, you can create another filter on the
[Sales Revenue] measure to focus your data to a more specific range of results. When you
run the report again, Web Intelligence applies both query filters.
What objects can I filter on the query?
You can define custom query filters on any dimension, measure, or detail object listed on
the Data tab in Query View. You can also use predefined filters created by your
administrator at the universe level. Predefined filters appear with the universe objects and
are indicated by the filter icon.
a value: Accessories
filtered object: [Lines]
an operator: Equal to