Organizing a Report into Sections

Objective

After completing this lesson, you will be able to organize a report into sections

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.

Report ElementResult when Folded
Section

When a section is folded, section details are hidden and free cells only are displayed.

In Reading mode, you can fold and unfold sections.

Table or Break

When a table or break is folded, the rows are concealed, and only headers and footers are displayed. Tables must have headers and footers to be folded and unfolded.

Vertical tables, horizontal tables and cross tables can be folded and unfolded.

In Reading mode, you can fold and unfold table or break.

Organize a Report into Sections

Log in to track your progress & complete quizzes