Selection Relationship

The Selection Relationship list allows you to automatically select members based on their relationship to the selected (checked) members in the Dimension Members List. This can save you a lot of time. For example, you may want all the children of a specific member or members, or you may want the member and all its ascendants.

If you select the Dynamic option (selected by default), each time you perform a refresh on the report, the report will automatically pick up new members or remove members that have been deleted from the cube or model.

• Member Only
• Member and Children
• Children
• Member and Descendants
• Descendants
• Base Level
• Same Level
• Siblings
• Member and Ascendants
• Ascendants
• Member and Base Level
• Member Offset

  When selected, the Member Offset area is displayed. This feature enables you to display a member related to another member by specifying an offset from a given member to retrieve the previous or subsequent member.

  You can also specify a hierarchy level. By default (Member Level option), the member at the same level as the member specified is incremented. You can also choose a specific level.

  Note When you choose a specific level using the Level option, note that only the members that are above the selected member or at the same level in the hierarchy, will be displayed. If you specify a level that is below the selected member, the level will be ignored. See the second example below.

  • Example with the Member Level option: you select 2009.Q1 in the list of dimensions and you specify an offset of 2. The 2009.Q3 member will be displayed in the report.
  • Example with the Level option: you select Quarter 1 in the list of dimensions, then you specify an offset of 3, then you specify the level 2. The member displayed in the report will be the third member (increment based on member Quarter 1) at the same level of Quarter 1: Quarter 4. Since the second level of the hierarchy is below Quarter 1 level in the hierarchy, the level is therefore ignored.
• Member Property

  When selected, the Member Property area is displayed and enables you to select a property. This feature enables you to display the property value of the selected member, that is another member of the same dimension.

  For example, you check the member ACTUAL, then select Member Property from the Selection Relationship list, then select the COMPARISON property. In your report, the member BUDGET is displayed, as this is the comparison value for the ACTUAL member. If there is no property value for a member, the member is retrieved in the report cell.

• Dimension Property

  You can select Dimension Property when there are two dimensions in the current axis (row or column axis) and when you do not select any member in the Dimension Members area of the Member Selector. Once Dimension Property is selected, the Dimension Property area is displayed and enables you to select a dimension and a property for the dimension. This feature displays the property values for the displayed members of a dimension, based on another dimension's members. If no property value exists, the context member of the dimension is displayed in the report.

  For example, the row axis contains the two dimensions Entities and Reporting Currency. Open the Member Selector for the Reporting Currency dimension: select Dimension Property from the Selection Relationship list, then select the Entity dimension and the CURRENCY property. In your report, here is what is displayed: first column lists USA and France; the second column lists USD and EUR.

Using the Selection Relationship list, you can also create a blank member. This member behaves like any other member. Blank Member