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

Building Reports Using the Web Intelligence Java Report Panel 41
you can pull this data in to the report to allow you to access more detail at any time. This
process of refining the data to lower levels of detail is called drilling down on an object.
In the universe, the scope of analysis corresponds to the hierachical levels below the object
selected for a query. For example, a scope of analysis of one level down for the object
Year, would include the object Quarter, which appears immediately under Year.
You can set this level when you build a query. It allows objects lower down the hierarchy
to be included in the query, without them appearing in the Results Objects pane. The
hierarchies in a universe allow you to choose your scope of analysis, and correspondingly
the level of drill available.
You can also create a custom scope of analysis by selecting specific dimensions to the
Scope of Analysis pane.
Note: You cannot define a scope of analysis when working in Query Drill mode. Query
Drill defines the scope automatically in response to drill actions.
Setting levels of analysis
When you set the scope of analysis for a query, you include dimensions one or more levels
down the hierarchy tree for each dimension that you have added to the Result Objects
pane.
When you run the query, the dimensions included in the scope of analysis are returned to
the cube for that document, but are not projected onto the reports that the document
contains. They can be added to the reports at any time, without having to run the query
again. Values for the dimensions in the scope of analysis can also be viewed by switching
a report to Drill mode, and then drilling down to them from the values displayed on the
report. (For full information on performing drill analysis, see ”Setting up documents for drill
analysis” on page 355.)
How many scope of analysis levels can you set?
You can set the following levels for scope of analysis:
Level Description
None Only the objects that appear in the Results Objects
pane are included in the query.
One level down
Two levels down
Three levels down
For each object in the Results pane, one, two, or
three objects lower down the hierarchy tree are
included in the query. The data from these objects
is stored in the cube until you add them to the
document.
Custom All objects added manually to the Scope of
Analysis panel are included in the query.