UCOLUMNS
The UCOLUMNS Report Writer command in Essbase underlines all columns, including names and data, in the preceding row.
The underline width is based on column width. If char is provided, it is used as the underline character. Otherwise the default character "=" is used.
Syntax
{ UCOLUMNS ["char"] }
Parameters
Notes
Double-byte characters are not supported.
Example
The command {UCOLUMNS} in the following report script example underlines all the columns in the previous row which is the Television row.
<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
<COLUMN (Year)
<ICHILDREN Year
<ROW (Product)
Television
{ UCOLUMNS }
VCR
Compact_Disc
!
The above report script example 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