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 371
You work as regional manager for California in a retail clothing store, and have been sent
the following report that shows quarterly sales revenue by state:
You are only interested in analyzing the results in the state of California. In addition, you
want to analyze the sales revenue broken down by each product line you sell. To drill on
California data, you place your pointer on the table cell that says California.
If you drilled down now, however, you would drill to results for each city within California,
because [City] is the dimension below [State]. Instead, you select Drill by from the drill
menu and then you navigate through the dimensions on the Products hierarchy by
selecting the sub-menus until you reach the [Lines] dimension.