Exploding Report Rows 

Use

You use the Explode function to specify whether individual values only, a sum only, or individual values with totals and subtotals are to be displayed for the characteristics used in the report rows.

If you have defined more than one characteristic in a report row, you can define the order in which the characteristics are displayed in the report.

Procedure

  1. To explode a report row, position the cursor on the report row and choose Edit ® Rows ® Explode.
  2. The Explode characteristics dialog box lists the row characteristics for which you have entered an interval of values, a group, or a variable. You can use the Explode function for each of these characteristics.

In the standard system, the No explode indicator is set as the default. A row total only is displayed in the report for the characteristic.

    1. If you select Single values, only individual values are displayed in the report for the characteristic. Sums are not displayed in the report.

      2. It is advisable to select Single values for characteristics for which you do not usually calculate sums, such as statistical key figures or activity types.

    2. If you select Explode, the report displays single values, subtotals, and a grand total. Subtotals are calculated based on the hierarchical structure of the characteristic.

      3. You can specify the hierarchical sequence in which the characteristics are output in the report rows. The characteristic assigned number 1 appears at the highest level of the hierarchy. For each value defined for this characteristic, data is summarized for all of the characteristics below it in the hierarchy.

      You entered the characteristics cost center and account in a report row for cost centers 100, 200, and 300 and accounts 4000010 and 4000020. If you assign number 1 to cost center and number 2 to account, the report breaks down cost centers by accounts. If you switch the order, the report breaks down accounts by cost centers.

    3. You can use the function Display sort order to display the characteristics in the order you have defined.

Exploded report rows are displayed with one or more asterisks in the report definition, depending on the row summation level.

If you enter a group as the characteristic value for a report row, the hierarchical structure of this group is depicted in the report definition. If you set the Explode indicator for this row, all subtotals and the sum total are displayed for this group in the report definition, together with the corresponding number of asterisks. The lowest level in the group (usually the individual values) are not displayed in the report definition.

Suppose you define a report row for the characteristic account and enter the group (the set) ACCOUNTS as the characteristic value. (The group ACCOUNTS is a single-dimension set containing income and expense accounts.) If you select Explode for the ACCOUNTS group, the report definition displays a totals row for all accounts, and subtotals rows for the income and expense accounts. The individual account values, however, are not displayed in the report definition.

If you enter a set variable as the characteristic value, the row structure is only determined when you output the report. The default set assigned to the set variable displays in the report definition. When you execute the report, you can overtype this default set on the selection screen if you want.

Suppose you define a report row for the characteristic account and enter the set variable ACCT as the group characteristic value. The default set of the variable only has one summation level. In the report definition, the exploded row is displayed with only one asterisk.