Show TOC

Function documentationMemberSet Parameter Locate this document in the navigation structure

 

This parameter defines the set of members to expand for the corresponding dimension. The default value is DEP.

Features

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 Note

Do not add any spaces between the values.

End of the note.

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 Note

If you combine the keywords MEMBERS or ALL with PARENTAFTER, the parent members appear after the children.

End of the note.

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:

  • GDEP - Group Dependents G

  • BAS - Group Base-level members

  • GALL - Group All members below current parent

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 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.

End of the note.

Activities

To define the MemberSet parameter, take the following steps:

  1. From Interface for Excel, open the EvDRE report or input schedule you are building.

  2. Find the Expand range parameter fields.

  3. 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.

  4. Save the report or input schedule.

Example

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