Fixes the number of total columns in the final report regardless of how many actual columns are originally selected.
{ FIXCOLUMNS number }
| number | Number of columns that you want to be displayed in your final report. |
This command fixes the number of total columns in the final report regardless of how many actual columns are originally selected. Only the first number of columns, which includes row name columns and data columns, are displayed.
This command is often used in conjunction with the ORDER command to select and reorder a specific subset of the requested columns, cutting off the unwanted excess columns.
The following examples are based on Sample Demo.
The command { FIXCOLUMNS 3 } causes only 3 columns, the row name column
and two data columns, to be displayed even though there are additional
columns for the data values of Qtr3, Qtr4 and Year.
<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
<COLUMN (Year)
<ICHILDREN Year
<ROW (Product)
{FIXCOLUMNS 3}
<ICHILDREN Audio
!
This example produces the following report:
Chicago Sales Actual
Qtr1 Qtr2
======== ========
Stereo 2,591 2,476
Compact_Disc 3,150 3,021
Audio 5,741 5,497
|
This example used FIXCOLUMNS and ORDER to create a non-symmetric report.
<PAGE (Market, Accounts)
<COLUMN (Year, Scenario)
<ROW (Product)
{ ORDER 0,1,3,5,6 FIXCOLUMNS 5 }
Chicago Sales
Jan Feb Mar
Actual Budget
<ICHILDREN Audio
!
Chicago Sales
Jan Feb Mar Mar
Actual Actual Actual Budget
======== ======== ======== ========
Stereo 923 834 834 900
Compact_Disc 1,120 1,050 980 1,000
Audio 2,043 1,884 1,814 1,900
|
If the command { BLOCKHEADERS } had also been used, the output would be:
Chicago Sales
Jan Feb Mar Mar
Actual Actual Actual Budget
======== ======== ======== ========
Stereo 2,591 2,476 2,348 2,438
Compact_Disc 3,150 3,021 3,115 3,028
Audio 5,741 5,497 5,825 5,003
|
Note that without the FIXCOLUMNS, the column headers would have been:
Jan Feb Mar
Actual Budget Actual Budget Actual Budget
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |