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 55
The InfoView Save page opens.
3. Save the document in the usual way.
For full information, see ”To save a new Web Intelligence document in InfoView” on
page 248.
The next time the document is opened, it opens in Drill mode.
To end drill mode
1. Verify you are working in Drill mode.
The Start Drill Mode button is pressed in when you are in Drill mode.
2. Click the Start Drill Mode button.
Web Intelligence returns the drilled report to results mode. The drill filters and the
hyperlinks on drillable values no longer appear.
Using query drill
You can set Web Intelligence to drill in query drill mode, which behaves differently from
the standard drill mode described so far in this chapter. When you activate query drill,
Web Intelligence drills by modifying the underlying query (adding and removing
dimensions and query filters) in addition to applying drill filters.
Example: Drilling down from Month to Week
In this example, Month is the lowest dimension currently available in the query from a time
hierarchy, and Week is the dimension immediately below it in the hierarchy.
If you drill down on Month = January, three things happen:
Web Intelligence adds Week to the query scope of analysis.
Web Intelligence adds a query filter to restrict Month to January.
Web Intelligence adds a drill filter to restrict Month to January.
If you drill up from Week to Month, the process is reversed:
Web Intelligence removes Week from the query scope of analysis.
Web Intelligence removes the query filter.
Web Intelligence removes the drill filter.
Note: Drill filters are not strictly necessary in query drill mode. Web Intelligence applies
them for consistency with standard drill mode. For example, the
DrillFilters() function returns
the correct value in query drill mode because Web Intelligence applies drill filters to match
the query filters.
For information on how to activate query drill, see ”Activating query drill” on page 57.