Hierarchical Member Selection

The second window of Rule Definition (New Mode) displays all the information you have provided in the Linked to and Master info grids. You can view the filters you have selected in the Rule Condition grid.

Figure 10-6 Rule Condition (New Definition) window

From the Rule Condition grid, you can apply conditions for each of the BMM hierarchy filters.

Note:

In the case of Data Element, Group, or Hierarchy filters, you can only view the SQL query.

To apply a condition for a BMM hierarchy filter and view the SQL query in the Rule Condition grid:

1. Click the button adjacent to the filter details. The Hierarchy Browser window is displayed.

   Figure 10-7 Hierarchy Browser window

   
   

   

   
   
   You can select (pagination) icon to view more options under the available member.
2. Select a member/node and click to select the same. Click to select the member as Self, Self & Descendants, Self & Children, Parent, Siblings, Children, Descendants, or Last Descendants. For more information, see Hierarchical Member Selection Modes.
   In the Hierarchy Browser window you can also:
   • Click to sort members based on the path.
   • Click to sort hierarchy (top to bottom).
   • Click to sort based on level.
   • Click or to collapse or expand the members under a node, respectively.
   • Click or to collapse or expand the selected branch, respectively.
   • Click to focus only on the selected branch. The Available Values pane shows the members of the selected branch only. Click to go back to normal view.
   • Click to display member's numeric codes on the right. The icon changes to .
   • Click to display member's numeric codes on the left. The icon changes to .
   • Click to show only member names. This is the default view. The icon changes to .
   • Click to display member's alphanumeric codes on the right. The icon changes to .
   • Click to display member's alphanumeric codes on the left. The icon changes to .
   • Click to display only member names. This is the default view. The icon changes to .
   • Select a member and click or to re-arrange the members in the Selected Values pane.
   • Select a member and click to move it to the top or click to move it to the bottom.
   • Click to launch the Search panel. Here you can search based on Dimension Member Numeric Code, Dimension Member Name or Dimension Member Alphanumeric Code. You can also search in the grid based on member name using the Search field.

   Note:

   You can add up to 1000 members or nodes in the Selected Members pane under the target hierarchy.
3. Click to view the filter details. The Preview SQL Query window is displayed with the resultant SQL query. 0.