Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
PDF · Mobi · ePub |
The LCOLWIDTH option controls the default width of the label column in reports. For output from ROW command and HEADING, LCOLWIDTH affects the first column. For output from REPORT, LCOLWIDTH affects the first column except when the first column is a data column or part of a set of columns that represent the base dimensions of a composite or a conjoint dimension.
Note:
For an individual column, the LCOLWIDTH value is always overridden by a WIDTH attribute in a HEADING, REPORT, or ROW commandSee also:
COLWIDTHINTEGER
LCOLWIDTH = n
An INTEGER
expression that specifies the desired column width in number of characters. You can set LCOLWIDTH to any value from 1 to 4000. The default is 14
.
Note:
The maximum width of a line in a report is 4000 characters. Therefore, the combined width of all the columns of a report cannot be greater than 4000 charactersExample 17-35 Setting Default Column Widths
Suppose you want to look at unit sales for six months. Since the longest product name is 10 characters, you do not need the default width of 14 for your label column. Also, since the sales figures are not large, you do not need a width of 10 characters for your data columns. You can set LCOLWIDTH and COLWIDTH to give smaller default column widths.
LIMIT district TO 'Atlanta' LIMIT month TO 'Oct95' TO 'Mar96' LCOLWIDTH = 10 COLWIDTH = 6 REPORT ACROSS month: units
These statements produce the following output.
DISTRICT: ATLANTA ------------------UNITS------------------ ------------------MONTH------------------ PRODUCT Oct95 Nov95 Dec95 Jan96 Feb96 Mar96 ---------- ------ ------ ------ ------ ------ ------ Tents 503 345 259 279 305 356 Canoes 317 282 267 281 309 386 Racquets 1,365 1,270 1,357 1,125 1,304 1,263 Sportswear 3,065 2,327 1,955 2,591 2,829 3,137 Footwear 3,445 3,247 2,831 3,089 3,282 3,475