BEFORE

The Essbase Report Writer BEFORE command displays a character string before data columns in the report. Quotes without a character string clear the text displayed before data columns. For example, { BEFORE "" } turns off previously issued BEFORE commands.

Syntax

{ BEFORE "char" [ columnList ] }

Parameters

char: A single-byte character enclosed in quotation marks.
columnList: Optional. List of the column numbers, separated by spaces, that you want char to precede. Without columnList, char is displayed before all columns in the report.

Notes

Double-byte characters are not supported.

Example

The following report script is designed for the Demo Basic cube, available in the gallery. { BEFORE "$" } is used to display the dollar sign before all the data values.

<PAGE Market, Accounts, Scenario)
Chicago Sales Actual
 <COLUMN  Year)
 <ICHILDREN Year
<ROW (Product)
{ BEFORE "$" }
<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

AFTER