SUPALL
Suppresses the display of the page and column headings, all member names, page breaks, commas, and brackets.
Syntax
{ SUPALL }
Notes
With this command, you see the data of the report and any text displayed as the result of the TEXT command. This command is equivalent to SUPHEADING, SUPPAGEHEADING, SUPCOLHEADING, SUPNAMES, SUPBRACKETS, SUPFEED, and SUPCOMMAS.
Example
The following report script is designed for the Demo Basic cube, available in the gallery.
<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
<COLUMN (Year)
<CHILDREN Year
<ROW (Product)
<ICHILDREN Audio
!
{ SUPALL }
Boston Sales Actual
<CHILDREN Year
<ICHILDREN Audio
!
This 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