Creating Asymmetric Reports
Data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud
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 22-15, are characterized by repeating, identical groups of members.
Figure 22-15 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. 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.](img/ff_sym_rpt.gif)
Asymmetric reports, as shown in Figure 22-16, 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 22-16 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. 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.](img/ff_asym_rpt.gif)
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.