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 analysis362
You can select a predefined level for the scope of analysis or define your own custom
level.
• Predefined – the scope of analysis is the same for each dimension in the report.
For example, if you set the scope of analysis at two levels, each dimension in the report
will contain additional data two levels down.
• Customized – you specify the dimensions in each class to which you want to be able
to drill.
Setting a custom scope of analysis reduces the length of time it takes Web Intelligence
to run the query or refresh the reports. For example, a document might contain up to a
thousand rows of data. If you know that you or other users will need to analyze only
certain dimensions in the reports (for example, [Customer] or [Geography]), you can
specify those dimensions in a custom scope of analysis.
For step-by-step instructions on how to define the scope of analysis for a Web Intelligence
document, see ”Setting the scope of analysis” on page 40.
If your security profile allows, you can drill beyond the data included in the scope of
analysis to retrieve more detailed information from the data source on which the document
is based. See ”Retrieving more levels of data to the report” on page 374.
About drill paths and hierarchies
When you analyze data in drill mode, you move along a drill path. These paths are based
on the dimension hierarchies set by the designer of the universe. Universe designers
organize objects in classes in a hierarchy with the most summary objects at the top and the
most detailed at the bottom. So if you want to make a high-level report, you know that your
query should include objects at the top of the list. If you want to see more detailed
information, you can then switch to Drill mode and drill down on each dimension value
displayed in the reports.
For example, if the data from [Quarter] did not sufficiently explain a result, you could drill
down to [Month] or [Week], depending on how the universe designer set up the hierarchy.
When you drill to a different level, measures, such as a [Revenue] or [Margin], are
recalculated accordingly.
Drill paths usually follow the same hierarchy order as the classes on a universe. For
example, a class called Time typically includes the [Year] dimension at the top of the class,
followed by the [Quarter], [Month], and [Week] dimensions. The hierarchies for drill
within the Time hierarchy typically follow the same order, because users want to drill