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 393
Drilling up
When you drill up, query drill removes dimensions from the query. For example, if you drill
up from Month to Quarter, Web Intelligence removes Month from the query. This has two
consequences:
• Query drill is incompatible with drill snapshots. For more information, see ”Query drill
and drill snapshots” on page 393.
• Web Intelligence does not allow you to drill up beyond any dimension that appears as
one of the report objects. For example, if your report displays Year, Quarter and
Revenue, you cannot drill up from Quarter to Year because this would remove quarter
from the list of report objects.
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 you receive a message telling you to clear the scope of
analysis before activating query drill.
You can see how Web Intelligence has modified the scope of analysis and query filters to
match the drill by viewing the Query Panel during a query drill session.
Note: The scope of analysis is read-only during a query drill session.
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 your drilled results” on page 394.)