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 391
If the drilled report is filtered for Year 2003, and you then refresh the document and select
year 2002 to answer the prompt, Web Intelligence retrieves results for 2002 instead of
2003.
The drilled report then displays values for 2002.
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.