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 ] ] ] }
Parameter | Description |
---|---|
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 n 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
See Also