Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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.

Data type






An integer expression that specifies the desired column width in number of characters. You can use an integer literal or an expression that returns an integer value. The default is 14.


Label Columns in REPORT

By default, the REPORT command produces a column of dimension values that label the rows down the left side of the report. The default width of this label column is controlled by the LCOLWIDTH option. However, when the values of a composite or a conjoint dimension are shown down the report, Oracle OLAP creates a separate column for each base dimension. The default width of these base dimension columns is controlled by the COLWIDTH option, which has a default value of 10 characters.

Maximum Column Width

You can set LCOLWIDTH to any value from 1 to 4000.


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 characters

Overriding LCOLWIDTH

You can override the LCOLWIDTH value for the label column by using the WIDTH attribute in a HEADING, REPORT, or ROW command.


Example 15-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'
REPORT ACROSS month: units

These statements produce the following output.

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