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
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