1. User's Guide
  2. Free-Form Mode
  3. Creating Asymmetric Reports

Creating Asymmetric Reports

Follow the procedure in this topic to create asymmetric free-form report..

Cloud data source types: Oracle Analytics Cloud - Essbase, Planning

On-premises data source types: Oracle Essbase, Oracle Hyperion Planning

Reports can contain symmetric or asymmetric column groups. The symmetry the symmetry of column groups is determined automatically, based on the members you select.

Symmetric reports, as shown in Figure 27-19, are characterized by repeating, identical groups of members.

Figure 27-19 Symmetric Report


The report shows Qtr1, Qtr2, and Qtr3 members nested under both Budget and Actual. Budget and Actual are nested under both East and West dimensions.

Asymmetric reports, as shown in Figure 27-20, are characterized by groups of nested members that differ by at least one member. There can be a difference in the number of members or in the names of members.

Figure 27-20 Asymmetric Report


The report shows Qtr1, Qtr2, and Qtr3 members nested under both Budget and Actual under East dimension but only under Actual for the West dimension.

You can create asymmetric reports as follows:

  • Enter member names in free-form mode.

  • Zoom in with Within Selected Group selected on the Member Options page of the Options dialog box.

  • Suppress rows that contain missing values, zero values, or underscore characters during data retrievals.

Note:

Retrieving data into an asymmetric report may take a long time on large reports.