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 359
For example if you drill on the 2003 date for year, the values for Q1, Q2, Q3, and Q4
are the quarters for year 2003. This means that the quarterly values you drilled to are
filtered by 2003.
The
Drill toolbar allows you to select other values in order to filter the results differently. For
example, if you use the
Drill toolbar to select 2002, the Q1, Q2, Q3, and Q4 results
displayed on the drilled block would be quarters for year 2002.
Note: If you are drilling in query drill mode, the drill toolbar shows only the drilled value in
the list of values of the drilled dimension. For example, if you drill on 2002, you see 2002
only in the list of Year values. For more information on query drill, see ”Query drill” on
page 359.
If the drilled report includes dimensions from multiple data providers, a ToolTip appears
when you rest your cursor on the value displayed on the filter. The ToolTip displays the
name of the query and the dimension for the value.
You can opt to hide the
Drill toolbar when you start drill mode. This is useful if you do not
want to select filters during your drill session. You can also manually display or hide the
Drill toolbar once you have started Drill mode. For more information, see ”Using the Drill
toolbar” on page 385.
Query drill
Query drill is a special drill mode that you can activate for each document. Normally,
when you drill on a report, Web Intelligence adds drill filters to isolate the data into which
you are drilling. (For more information on drill filters, see ”Using filters when you drill” on
page 385.) When you drill in Query Drill mode, Web Intelligence modifies the underlying
query.
For more information, see ”Using query drill” on page 391.
Setting your drill options
You set your drill options in InfoView. When you modify your drill options, the
modifications are implemented the next time you start Drill mode.
The Drill toolbar displays
the value that filters the
drilled results
The ToolTip displays the
names of the dimension and
query for the value displayed
on the Drill toolbar