Forces a symmetric report, regardless of the data selection. Use SYM to change the symmetry of a report that Essbase would create as an asymmetric report.
Syntax
<SYM
Notes
This 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.
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 example is based on Sample Basic.
<PAGE (Measures, Market) Texas Sales <SYM <COLUMN (Scenario, Year) Actual Budget Jan Feb <ROW (Product) <IDESCENDANTS "100" !
This example produces the following report:
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
See Also