You define the Expand range parameter when you want your report or input schedule to handle expansions. This parameter points to a set of ranges that contain the appropriate expansion definitions.
The Expand range parameter uses the values in the Parameter/Expansion table. The parameter table consists of:
The name of the expansion parameter in the first column.
As many columns as the number of desired expansions. For example, if you want two expansions in the columns, and three expansions in the rows, you have five columns after the expansion parameter name.
Up to eight rows, each one defining one parameter for each expansion.
The following table describes the subparameters for the Expand range parameter. You must define the first three subparameters, and the others are optional.
Parameter |
Description |
---|---|
ExpandIn |
This parameter can be either COL or ROW, indicating whether the expansion is to be performed on the columns or on the rows. |
Dimension |
This parameter contains the name of the dimension for which a dynamic set of members is generated. |
MemberSet |
For this parameter, you define the set of members to expand for the selected dimension. For more information, see MemberSet Parameter. |
BeforeRange |
(Optional) Use to specify a range of cells to insert at the beginning of the current expansion. For more information, see BeforeRange Parameter. |
AfterRange |
(Optional) Use to specify a range of cells to insert at the end of the current expansion. For more information, see AfterRange Parameter. |
Suppress |
(Optional) Set the Row expansion parameter to Y to suppress the rows that retrieve zero values. Set the Column expansion parameter to Y to suppress all columns that retrieve zero values. For more information, see Suppress Parameter. |
Insert |
(Optional) Set this parameter to Y for any row or column expansion to perform a runtime insertion of a suppressed row or column after the expansion. You can insert a suppressed row or column by right-clicking the desired key cell and selecting EVDRE: Insert member. The displayed dialog box allows you to select a member whose data you want to display in the row or column. For more information, see Insert Members. |
When the system expands a report, it follows the sequence of events below:
Expands the member sets to apply (this includes the members of the formatted sets, if defined)
Performs the system suppressions
Refreshes the system data
Applies the default format
Applies the formatting and sorting instructions
Inserts the before and after ranges of sorting, with their formats
Applies the formats of the formatted sets
Inserts the before and after ranges of the expansions, with their formats
The sequence ensures that the formatting instructions of the format range do not override the formats of the before and after ranges, as well as of the formatted sets. If some portions of the report are already formatted, the format instructions do not break the predefined formats.
You can define the Expand range parameter when you want your report or input schedule to handle expansions. The Expand range parameter points to a set of ranges that contain the appropriate expansion definitions.
If the EvDRE function is =EVDRE($B$3,A14:B20,A23:C29)
, the Expand range parameter points to the data in cells A23:C29.
A |
B |
C |
|
22 |
PARAMETER |
EXPANSION1 |
EXPANSION2 |
23 |
ExpandIn |
COL |
ROW |
24 |
Dimension |
RPTCURRENCY |
ACCOUNT |
25 |
MemberSet |
MEMBERS |
BAS |
26 |
BeforeRange |
||
27 |
AfterRange |
||
28 |
Suppress |
Y |
Y |
29 |
Insert |