HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Organizing results on tables using breaks and sorts172

alphabetical characters, then the values are sorted in alphabetical order from top to

bottom. You can change this sort order at any time. For information on how to apply sorts,

see ”To apply an ascending or descending sort to a table or section” on page 169.

Inserting, removing, and prioritizing breaks

You can insert one or multiple breaks on a table or crosstab. You can insert breaks on any

columns or rows that display values for:

• dimensions - typically retrieve character-type data.

For example: customer names, line names, or dates.

• details – provide descriptive data about a dimension.

For example: [Age] is a detail object that is associated with the [Customer] dimension.

Note: You cannot insert a break on columns or rows that display a measure.

You can prioritize breaks on tables to organize groups of data on tables within other

groups. For example, if you want to group data on a table by country and then, within

each country, group that data by customer, you need to insert a break on the [Country]

dimension and on the [Customer] dimension, and then give first priority to the break on

[Country].

To insert or remove a break

1. Right-click the table cell containing the results you want to group together, and then on

the contextual menu, click

Break > Insert.

Click the table cell containing the results you want to group together, and then click the

Break button on the Report toolbar.

To display the

Report toolbar, right-click the main toolbar above the report, and then

click

Report on the contextual menu.

Web Intelligence groups the selected data together on the table, by inserting a break,

and inserts a footer at the end of each break

The selected column

for “State” is

Break button

The data for each state

is grouped together