WIDTH

Specifies the width of columns in a report.

If the WIDTH command is followed by number with no column selections, number sets the width for all data columns. Otherwise, the width is set for each data column listed in the command. Column numbers are assigned starting at 0 for the first row-name column, incrementing by one for each row-name column, data column, and calculated column, in that order. The tilde character (~) follows member names or values that must be truncated to fit in the column to indicate part of the name or value is not displayed. If possible, space from adjacent columns is used to avoid truncating. The widths of names columns may be adjusted if their column numbers (0,1,...) are specifically included in the command. Alternatively, the NAMEWIDTH command may be used.

If the WIDTH command is not used, columns are wide enough to fit the widest value.

Syntax

{ WIDTH number [ column1 [ column2 [ columnN ] ] ] }

Parameters

number: New column width in characters.
column1column2columnN: Optional. Numbers designating the columns to resize, separated by spaces. Values: between 0 and 161, where 0 is the first row-name column. If column-numbers are not specified, all columns are resized to the width indicated by number.

Notes

The value of number must be zero or a positive integer.
WIDTH is a column formatting command. If you specify columns in the WIDTH command before designating them with a member selection, Essbase expands the report to that number of columns. See the information on "Column Formatting Commands".
After members for the report specification are selected, the numbers specified should not exceed the number of columnN.

Example

The following example is based on Sample Basic.

<PAGE (Measures, Market)
Illinois Sales
<SYM
{WIDTH 7}
{WIDTH 20 0}
     <COLUMN (Scenario, Year)
     Actual Budget Scenario
     Jan Feb Mar
<DESCENDANTS "100"
     !

Which resizes all data columns to a WIDTH of seven and the row name label column (column 0) to a WIDTH of 20.

                                            Sales Illinois 

                           Actual               Budget              Scenario       
                       Jan    Feb    Mar    Jan    Feb    Mar    Jan    Feb    Mar 
                    ====== ====== ====== ====== ====== ====== ====== ====== ====== 

100-10                 345    354    367    360    370    380    345    354    367 
100-20                 234    254    267    240    260    280    234    254    267 
100-30              #Missi #Missi #Missi #Missi #Missi #Missi #Missi #Missi #Missi