AFTER

The Essbase Report Writer AFTER command displays a character following the data columns in the report.

This command displays only the first character of a string, even if more are specified. If you do not specify any columns in columnList, char is displayed after all data columns in the report.

Syntax

{ AFTER char [columnList] }

Parameters

char: A single-byte character enclosed in quotation marks.
columnList: Optional list of one or more column numbers, separated by spaces. If included, AFTER affects only these columns. If you do not specify columnList, all data columns are affected.

Notes

Double-byte characters are not supported.
If a value is equal to #MISSING, the string inserted after it does not print, even if you replace #MISSING with some other value (such as 0).

Example

The following report script is designed for the Demo Basic cube, available in the gallery. The {AFTER "%"} command displays the percent sign after each data value.

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual

<COLUMN (Year)
<ICHILDREN  Year

<ROW (Product)

{ AFTER "%" }
<ICHILDREN Audio
     !

This example produces the following report:

                      Chicago Sales Actual 

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

Stereo         2,591% 2,476% 2,567% 3,035% 10,669%
Compact_Disc   3,150% 3,021% 3,032% 3,974% 13,177%
  Audio        5,741% 5,497% 5,599% 7,009% 23,846%

Related Topics

BEFORE