SUPALL

The SUPALL command in Essbase Report Writer suppresses the display of the page and column headings, all member names, page breaks, commas, and brackets.

Syntax

{ SUPALL }

Notes

With SUPALL, you display the data of the report, and any text displayed as the result of the TEXT command. SUPALL command is equivalent to SUPHEADING, SUPPAGEHEADING, SUPCOLHEADING, SUPNAMES, SUPBRACKETS, SUPFEED, and SUPCOMMAS, combined.

Example

The following report script is designed for the Demo Basic cube, available in the gallery section of the Essbase file catalog.

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
      <COLUMN (Year)
      <CHILDREN Year
<ROW (Product)
<ICHILDREN Audio
     !

{ SUPALL }
Boston Sales Actual
      <CHILDREN Year
<ICHILDREN Audio
     !

The above example produces the following report.

Note:

The last three rows show the totals for Boston, without headings.

                 Chicago Sales Actual 

                     Qtr1   Qtr2   Qtr3   Qtr4 
                    ====== ====== ====== ======

Stereo               2,591  2,476  2,567  3,035 
Compact_Disc         3,150  3,021  3,032  3,974 
  Audio              5,741  5,497  5,599  7,009 

    2450     2341     2377     2917 
    3290     3034     3132     3571 
    5740     5375     5509     6488