NAMEWIDTH
The Essbase Report Writer NAMEWIDTH command determines the width of all row name columns in the report.
Syntax
{ NAMEWIDTH [ width ] }
Notes
This command determines the width of the column for all row member names in the report. Member names are truncated when necessary to fit in the column and the tilde character(~) signifies that there are letters not visible in the report. If each names column needs a different width, use the WIDTH command.
Default Value
If width is not given, then a default value of 17 is assumed.
Example
The following report script is designed for the Demo Basic cube, available in the gallery. The first report for Chicago displays the default width for the row names column, while the { NAMEWIDTH 25 }
command in the Boston report increases the width of the row names column to 25.
<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
<COLUMN (Year)
<ICHILDREN Year
<ROW (Product)
<CHILDREN Audio
!
{ NAMEWIDTH 25 }
Boston Sales Actual
<ICHILDREN Year
<CHILDREN 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
Boston Sales Actual
Qtr1 Qtr2 Qtr3 Qtr4 Year
======= ====== ====== ====== =======
Stereo 2,450 2,341 2,377 2,917 10,085
Compact_Disc 3,290 3,034 3,132 3,571 13,027