DIMEND

Specifies a dimension format to be processed after cycling through all the members in the dimension.

Syntax

<DIMEND dimList

dimList List of members, separated by commas, that represents the dimensions for which the format is intended.

Description

The dimension format is made up of one or more format commands to be processed after cycling through all the members in the dimensions.

Any formatting commands in the report script encountered immediately before the DIMEND command become formats for all dimensions listed in the dimList of the command.

When the report is produced, after processing all members from the specified dimension(s) associated with the format, including the processing of any groups of members from other dimensions which are nested inside the specified dimension(s), the DIMEND format is then processed.

Notes

Formats are associated with the next member that follows them, and are processed just prior to any output of that member. Therefore, without this command, in some situations it would be impossible to define a format to be processed after a specified member, especially if it was the last member in a group.

Example

The UCOLUMNS format command underlines the columns in the report after every cycle through the Market dimension. In the report, you see the children of Qtr1 for East followed by the children of Qtr1 for the West. After West, before starting over with East again, the processing of UCOLUMNS displays the underlines in the report.

<PAGE (Accounts, Scenario)
Sales Actual
 <COLUMN (Product)
 /* Applied after dimension processing*/
 <ICHILDREN Audio
<ROW (Market,Year)
 East West
  <CHILDREN Qtr1
{ UCOLUMNS }
<DIMEND(Market) 
/* Puts underline after Market */
 !
 

This example produces the following report:

                                Sales Actual
                          Stereo  Compact_   Audio 
                         ======== ======== ======== 
East        Jan             2,788    3,550    6,338 
            Feb             2,482    3,285    5,767 
            Mar             2,569    3,458    6,027 
West        Jan             4,102    4,886    8,988 
            Feb             3,723    4,647    8,370 
            Mar             3,808    4,788    8,596 
=========== ============ ======== ======== ========

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com