Organizing a Report into Sections

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Organize a report into sections


You can organize data in a block using a section.

A section displays the grouped value and appears as a header outside the block, instead of remaining within the block. More importantly, a break merely groups data within a block, whereas a section groups the entire report. When you have multiple tables and charts in a single report, the sections group the data for all tables and charts according to the section value.

The advantages of sections are as follows:

  • You can project multiple blocks from the same micro cube within a single report, all sub-grouped to the sectioned level.
  • You can insert subtotal cells, repeated in each section, which are created by the simple process of drag-and-drop.

You can apply sorts to the results displayed in section cells to organize the order in which sections display in report tables.

Sorting sections allows you to logically organize the section headers in a report.

A Comparison Between Breaks and Sections

Breaks and sections separate data differently in Web Intelligence.

A section distributes the data into multiple free-standing cells called section headers. Each section cell contains one value for a dimension, with a block of data that corresponds to the dimension value.

A break divides the data within one block. One column contains the values for a dimension, detail, or measure, which are repeated for each other row of values in the block.

Report Data Fold and Unfold

You can hide and display report data by folding and unfolding report elements.

You can fold and unfold sections, breaks and tables if they have a header or a footer. Data is concealed and displayed in different ways depending on the report element.

Organize a Report into Sections

Log in to track your progress & complete quizzes