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 45
5
Analyzing results
Overview
Drill analysis allows you to look deeper into the reasons behind results displayed in
reports. This chapter includes information on:
•
how drill analysis works
• starting to drill
• drilling on tables
• drilling on section cells
• drilling on charts
• changing how drilled results are filtered
• drilling beyond report results
• saving drilled results and ending Drill mode
• using query drill
How drill analysis works
Drilling on reports lets you look deeper into data to discover the details behind a good or
bad summary result displayed on a table, chart, or section. For example if a table includes
sales results per quarter and you want to analyze the results for each month in Q4, you
can drill down on “Q4.” The drilled report displays the results for each month in Q4.
If you then want to analyze why a monthly result is significantly low or high in Q4, you
can drill across to other business indicators included in the scope of the document, such as
region or service. For example, if you drill by “Region,” the drilled report displays results
for the drilled month in Q4 broken out by region. You could then identify which region
was responsible for the low or high results in that specific month. Drilling thus enables you
to explore the reasons behind results displayed on reports by analyzing different slices of
data.
Starting to drill
To start analyzing reports using Drill, you need to switch to Drill mode.
Before your switch to drill mode, you need to verify that your drill options are set
appropriately. To find out how to modify your drill options, see ”Selecting your Drill
options” on page 24.