HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Performing On-Report Analysis with Web Intelligence 47
When you drill on measures, you drill one dimension down each dimension in the
table. For example, if you drill on Sales revenue for Year and State, the drill table
shows sales revenue results for Quarter and City:
To drill down on a dimension value on a table
1. Verify you are working in Drill mode.
The Start Drill Mode button is pressed in when you are in Drill mode.
2. Click the value you want to analyze.
For example, click the name of a customer or product, or click a date.
Drillable values are indicated by hyperlinks.
The drilled results appear on the table.
A filter drop-down box appears at the top of the report. This indicates that the value
you drilled is filtering the results displayed on the drilled table.
For example, if you drill on [Texas], then the filter displays “Texas” to indicate that the
results displayed on the drilled table are only for Texas.
To drill up on a dimension value on a table
1. Verify you are working in Drill mode.
The Start Drill Mode button is pressed in when you are in Drill mode.
2. Right-click the drillable dimension, then click Drill Up on the Drill menu.
Dimensions where you can drill up display the drill up arrow.
Or
Click the Drill Up icon in the column header of the dimension value you want to
analyze.
The drilled report now displays data one dimension level up.
If a filter has been created in the Drill toolbar due to a drill down action, the filter is
removed when you drill up.
To drill across dimensions using Drill by
1. Verify you are working in Drill mode.
Table before drill
Table after drill