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 57
Query drill and the scope of analysis
Query drill adds and removes dimensions from the scope of analysis in response to drill
actions. For this reason, you cannot set the scope of analysis manually when using query
drill. In addition, you cannot activate query drill if your document already has a scope of
analysis defined. In this case the option is unavailable. You must remove the scope of
analysis to make it available.
Query drill and other reports based on the same data provider
If your document contains other reports that contain dimensions on which you drill in query
drill mode, these reports are affected because the query drill modifies the dimensions they
contain.
Example: Drilling on a dimension that appears in another report
If you have two reports based on a query that contains Year, Quarter and Sales Revenue,
and you use query drill to drill down to Year = 2001 on the first report, Web Intelligence
also filters the data for Year in the second report to include 2001 only.
You can avoid this (at the cost of retrieving duplicate data into Web Intelligence) by
creating a new data provider and rebuilding the other report against it. Now when you
drill in query drill mode, the other report remains unaffected.
Query drill and drill snapshots
Do not use drill snapshots when working in query drill mode, because query drill means
that snapshots cannot be guaranteed to stay the same. (For more information on
snapshots, see ”Saving drilled results and ending Drill mode” on page 54.)
In query drill mode, snapshots change when you drill up beyond a dimension that you
included in a snapshot. Because the drill up removes the dimension from the underlying
query, it also removes the dimension from the snapshot.
Activating query drill
You activate query drill at the document level.
To activate query drill
1. Click Document > Properties on the Main toolbar.
The Document Properties dialog box appears.
2. Click Use query drill.
NOTE: If your report already has a scope of analysis defined, the option is
unavailable. You must remove the scope to make it available.