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 83
8
Filtering data retrieval using query filters
Overview
You limit the data returned to a Web Intelligence document by applying filters when you
define the query. Using query filters enables you to secure the data you don’t want specific
user groups to see and limits the size of the documents stored on your network. When you
run the query or refresh the document data, Web Intelligence returns only the values that
meet the query filter definitions.
This chapter tells you about:
•
how query filters work
• the different types of query filter
• using predefined filters
• creating custom filters
• combining multiple filters on a single query
• editing and removing query filters
• applying query filters to business questions
This chapter explains how to apply filters to objects in a query using the Java Report Panel.
How query filters work
When you build a query on a universe, you can filter the query to limit the data Web
Intelligence returns to the document. Query filters retrieve a sub-set of the data from the
database and return the corresponding values to the document. You define filters that
match the criteria of specific business questions. For example, you can filter the [Year]
dimension to view only sales revenue for Year 2003; or filter the [Annual Income]
dimension to view only customers whose annual income is equal to or greater than
$1.5M.
Including query filters on the data definition of the query enables you to:
• retrieve only the data you need to answer a specific business question
• hide the data you don’t want specific users to see when they access the document
• minimize the quantity of data returned to the document to optimize performance
Example: In 4Q2002, which stores in my sales region gained margins above $13K?
As Regional Marketing Manager for Texas, you are only interested in analyzing margins
for Texas, but the sales universe includes data US-wide. In addition, you only want to view
information for stores where margins reached over your 4Q 2002 quarterly target figure: