This parameter defines the set of members to expand for the corresponding dimension. The default value is DEP.
You can define one or more of the following for this parameter:
A comma-delimited list of members, for example, Cash,AccRec,Inventory.
A valid keyword that describes the members relative to the corresponding dimension member specified in the PageKeyRange.
A filter that describes the members to return.
Note
Do not add any spaces between the values.
Using Keywords
The following table describes the valid keywords that you can use alone, or combine with other keywords and hard-coded members in a comma-delimited list. The default expansion order is children, then parent.
Note
If you combine the keywords MEMBERS or ALL with PARENTAFTER, the parent members appear after the children.
Keyword |
Description |
---|---|
MEMBERS [,PARENTAFTER] |
All members in the dimension |
BASMEMBERS |
All base members in the dimension |
BAS |
All base members below the current member. You can enter BAS(parent) to return the base members of a specified parent, rather than using the parent from the page key range or current view. For example, BAS(TotalAssets) returns the base level members of TotalAssets. |
DEP |
All children of the current member. You can enter DEP(parent) to return the dependent members of a specified parent, rather than using the parent from the page key range or current view. For example, DEP(2008.Q1) returns the dependents of 2008.Q1. |
ALL [,PARENTAFTER] |
All dependents of the current member. You can enter ALL(parent) to return all members of a specified parent, rather than using the parent from the page key range or current view. |
SELF |
The current member. If you define the MemberSet as SELF, the expansion occurs on the current member. If you leave MemberSet blank, the system suppresses the expansion. |
NOEXPAND |
Do not expand |
GDEP, GBAS, GALL |
If you use a dynamic hierarchy, the ENTITY dimension supports the following member set expansion keywords:
The system activates these keywords only when the active application has a dimension type GROUP. The GDEP keyword generates the list of ENTITIES defined as dependents of the GROUP set in the page key, as found in the dynamic hierarchy stored in the OWNERSHIP cube for the current CATEGORY and TIME combination(s). This keyword also supports a direct assignment of the GROUP to use, with the following syntax: GDEP(GroupName). |
Defining filters
The filter criteria is based on one or more properties in the dimension. For assistance in defining a filter, you can right-click on the MemberSet cell and select EvDRE: Build Filter. Use the dialog box to define a query based on the property. For example, you can define a query like: ACCTYPE=INC GROUP=Balance Sheet AND CALC=Y
Note
The value of the property must be enclosed in double quotes.
The criteria can be equal (=) or different than (<>).
Do not use parentheses.
You cannot combine Filters based on properties with hard-coded members or other keywords like BAS, and so on.
The expressions are not case-sensitive.
To define the MemberSet parameter, take the following steps:
From Interface for Excel, open the EvDRE report or input schedule you are building.
Find the Expand range parameter fields.
In the MemberSet row, enter one of the following in the applicable cells:
A comma-delimited list of members for the associated dimension
A keyword that describes the members in the hierarchy to retrieve Filter criteria for each expansion column.
Filter criteria for each expansion column. To display the Filter dialog box, right-click on the MemberSet cell and select EvDRE: Build Filter. In the Filter dialog box, select the properties and values for the associated dimension.
Save the report or input schedule.
In the following example, the column expansion returns data for January and February of 2008, and the row expansions return data for all members in the RptCurrency dimension for each base-level member in the Account dimension.
22 |
PARAMETER |
EXPANSION 1 |
EXPANSION 2 |
EXPANSION 2 |
23 |
ExpandIn |
COL |
ROW |
ROW |
24 |
Dimension |
Time |
Rptcurrency |
ACCOUNT |
25 |
MemberSet |
2008.jan,2008.feb |
Members |
BAS |
26 |
BeforeRange |
Sheet1$C$33:$E$33 |
Sheet1$C$37:$E$37 |