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

Analyzing results46
Note: You can only drill on reports, if you security profile allows you.
To switch to drill mode
1. Verify that the report you want to analyze is selected.
2. Click the Start Drill Mode button on the main toolbar.
A hyperlink appears on each drillable result.
• ”Drilling on tables” on page 46
• ”Drilling on sections” on page 48
• ”Drilling on charts” on page 50
Drilling on tables
You can drill on:
• dimensions - typically retrieve character-type data.
For example: customer names, line names, or dates
• measures – the result of calculations on data in the database
For example: [Revenue] is the calculation of the number of items sold multiplied by item
price
When you drill on dimensions, the measures in the drilled table are calculated
according to the dimensions to which you have drilled. For example, if you drill down
Year to Quarter, the measures in the drilled table are calculated for quarter instead of
year:
Table before drill
Table after drill