SYM

The SYM command in Report Writer forces a symmetric report, regardless of the data selection in the report script. Use SYM to change the symmetry of a report that Essbase would otherwise create as an asymmetric report.

Syntax

<SYM

Notes

The SYM command is used to set the report type as symmetric. Under default conditions (for example, when neither the ASYM nor SYM commands have been used), Essbase will print an asymmetric report (with BLOCKHEADERS) when all column dimensions include the same number of selected members and all members for each column dimension are on the same line. Otherwise, a symmetric report (with PYRAMIDHEADERS) is produced. If the <SYM keyword is used, all report headers will appear in a symmetric format, even if there are equal numbers of members in each row of the column header. A symmetric report will also result if at least one of the column member lists is broken out onto more than one line.

When the <SYM keyword is used, the report will always be generated as a symmetric report, even with equal numbers of members selected in each column dimension. This is especially useful when you want to create a symmetric report without having to repeatedly type the lower-level members of symmetric/asymmetric reports. For a more detailed explanation see the <ASYM command. To turn off symmetric-only mode, use the <ASYM command.

Default Value

By default, Essbase prints a symmetric report (with PYRAMIDHEADERS) when column dimensions do not include the same number of selected members or the members for each column dimension are not on the same line.

Example

The following report script example is designed to work with Sample Basic, which is available in the gallery section of the Essbase file catalog. It generates an asymmetric report followed by a symmetric report.

<PAGE (Measures, Market)
Texas Sales
<ASYM
     <COLUMN (Scenario, Year)
     Actual Budget
     Jan Feb
<ROW (Product)
<IDESCENDANTS "100"
     !
     
<PAGE (Measures, Market)
Texas Sales
<SYM
     <COLUMN (Scenario, Year)
     Actual Budget
     Jan Feb
<ROW (Product)
<IDESCENDANTS "100"
     !

The above report script example produces the following reports:

                    Sales Texas 

                   Actual   Budget 
                      Jan      Feb 
                 ======== ======== 

100-10                452      580 
100-20                190      230 
100-30           #Missing #Missing 
  100                 642      810 

                             Sales Texas 

                       Actual            Budget      
                      Jan      Feb      Jan      Feb 
                 ======== ======== ======== ======== 

100-10                452      465      560      580 
100-20                190      190      230      230 
100-30           #Missing #Missing #Missing #Missing 
  100                 642      655      790      810

Related Topics

ASYM