UCHARACTERS

The UCHARACTERS Report Writer command in Essbase underlines all non-blank characters in the preceding row.

To underline names cleanly, the UCHARACTERS command treats a single space between two non-space characters as a character to underline. For example, in the name Sales_Revenue, the underscore is changed to a space on output, UCHARACTERS changes the space to "_". Default underline character "=" is used.

Syntax

{ UCHARACTERS ["char"] }

Parameters

"char": Optional. A single-byte character, enclosed in quotation marks, used as the underline character.

Notes

Double-byte characters are not supported.

Example

The following report script example is based on Demo Basic, available in the gallery in the Essbase file catalog.

{UCHARACTERS} underlines all the characters in the previous (Television) row.

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

      <COLUMN (Year)
      <ICHILDREN Year

<ROW (Product)
Television

{ UCHARACTERS }

VCR
Compact_Disc
     !

The report script example above produces the following report:

                              Chicago Sales Actual 

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

Television          4,410    4,001    4,934    6,261   19,606 
==========          =====    =====    =====    =====   ====== 
VCR                 3,879    3,579    4,276    4,877   16,611 
Compact_Disc        3,150    3,021    3,032    3,974   13,177