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 109
The Pivot tab has sections for the row(s), column(s) and body of the crosstab.
3. Select objects in the Available Objects area, click Row(s), Column(s) or Body and
click >> to add the objects to the rows, columns or body of the crosstab.
4. Click Row(s), Column(s) or Body and click << to remove objects from the rows,
columns or body of the crosstab.
5. Drag objects in the Row(s), Column(s) or Body area to set the object order.
6. Click OK.
To swap rows or columns on a crosstab
1. Select the crosstab.
2. Right-click and select Swap axis from the menu.
Web Intelligence swaps the rows and columns of the crosstab.
Modifying the data included in tables and cells
Once you have created a table or free standing cell you can modify the data in it by
adding or removing objects, clearing the data that the table or cell contains, or deleting
the table or cell.
To add objects to a table
1. Make sure that the Document Properties pane is displayed to the left of the selected
report.
To display the Document Properties pane, click the Show left pane arrow at the top
left of the report.
2. Select Available Objects from the drop down list at the top of the Left panel.
3. Select the object you want to add and drag it over to the table so that a red bar
appears where you want to place the object.
4. Release the object.
Web Intelligence adds the object to the table.
NOTE: You can add more objects to your document by modifying the query, if you
have the appropriate security profile. Refer to Building Queries Using the Web
Intelligence Query – HTML.
To clear table or cell contents
1. Select the cell or column within a table.
2. Display the Formula bar by selecting View from the menu, then selecting Toolbars,
then Formula.