Help Topics

Adding Members to the Selection by Relationship


You can add dimension members to a selection which are ordered by relationship. You can add the dimension members in terms of children, descendants, or siblings relationships, or by directly specifying the level.

For example, if we have two years' data for 2000 and 2001, and the hierarchy has years > quarters > months > weeks with an outline resembling the following:

This image shows a tree structure with year 2001 as the root. It has a leaf member of 2001.Q1, which has 2001.01, 2001.02, 2001.03, and 2001.04 as its leaf members. Each monthly member then has weekly members as its leaves.

The results of members selection of 2001.Q1 by relationship are shown below:

Option

Select Children

Select Descendants

Select Siblings

Select Generation

Select Leaves

Results of Selected Members for 2001.Q1

2001.01
2001.02
2001.03

2001.01.06
2001.01.13
2001.01.20
2001.01.27
2001.01
2001.02.03
2001.02.10
2001.02.17
2001.02.24
2001.02
2001.03.03
2001.03.10
2001.03.17
2001.03.24
2001.03.31
2001.03

2001.Q2
2001.Q3
2001.Q4

2000.Q1
2000.Q2
2000.Q3
2000.Q4
2001.Q1
2001.Q2
2001.Q3
2001.Q4

2001.01.06
2001.01.13
2001.01.20
2001.01.27
2001.02.03
2001.02.10
2001.02.17
2001.02.24
2001.03.03
2001.03.10
2001.03.17
2001.03.24
2001.03.31

To add members by relationship:

  1. Open Member Filter.
  2. Select a member in the Dimension Hierarchy list box.
  3. Click the Advanced button. A drop down list appears.
  4. From the drop down list, select the relationship to add: children, descendants, siblings, generation, or leaves. For example, you could choose children of Q1.
    The added members appear in the list as identified by the selected relationship. For example, if you chose children of Q1, the selection would appear in the list as "Children of Q1."
    To view the complete list of those members, click the Advanced button and select Preview.
  5. Click the OK button to return to the application.

The application updates immediately to reflect the changes. The selected members will appear in the application in the same order that they appear in the Member Filter.


Related Topics: