SUPCOLHEADING

The SUPCOLHEADING command in Essbase Report Writer suppresses display of default column headings.

Syntax

{ SUPCOLHEADING }

Notes

Unless a custom heading is defined, Report Writer displays only the page heading members at the top of the page, and row members on the left side of each row. The keyword >*COLHDR with the TEXT command is not affected by SUPCOLHEADING, and may still be used to generate column headings where desired.

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)
Boston Sales Actual
      <COLUMN (Year)
      <CHILDREN Year
<ROW (Product)
<ICHILDREN Audio 
     !
     
{ SUPCOLHEADING }
Boston Sales Actual
      <COLUMN (Year)
      <CHILDREN Year
<ROW (Product)
<ICHILDREN Audio 
     !

The above example produces the following reports:

                         Boston Sales Actual 

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

Stereo              2,450    2,341    2,377    2,917 
Compact_Disc        3,290    3,034    3,132    3,571 
  Audio             5,740    5,375    5,509    6,488 

                         Boston Sales Actual 

Stereo              2,450    2,341    2,377    2,917 
Compact_Disc        3,290    3,034    3,132    3,571 
  Audio             5,740    5,375    5,509    6,488