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

Setting up documents for drill analysis368
Drilling down
You drill down to see the lower-level data that makes up the summary results displayed on
reports. This helps explain why high or low results occurred.
Example: Using drill analysis to find out why sales decreased dramatically in 2003
In this example, you receive a report that shows sales revenue results for the accessories
line at the eFashion retail store. The following crosstab shows that the Accessories line
decreased in 2003.
To analyze more precisely when the decrease occurred, you drill down on the cell value
2003, to view the detailed data for each quarter.
When you drill down on the cell value 2003, a filter appears in the
Drill toolbar to show
that the quarterly values you have drilled to are filtered for the year 2003. The drilled chart
clearly shows that the problem arose in Q4 of 2003.
To find out which of the of the categories within the Accessories line was responsible for
the drop in revenue, you drill down again on the cell value Accessories.
The drilled crosstab shows which categories were responsible for low revenue in Q4.
The Drill toolbar displays the filter on Year, to show that the quarterly
values displayed on the drilled chart are for the year 2003.