Making Selections
Only members, substitution variables, and attributes to which you have access are displayed. The Selections pane only displays if you invoke the member selector for multiple member selection.
If valid intersection rules are used, only valid members are displayed in application forms and in runtime prompts for Calculation Manager rules. In ad hoc forms, both on the Web and in Oracle Smart View for Office, the application doesn't filter by valid intersections rules in point of view and page axis. Only cells in grids honor valid intersection rules in ad hoc forms.
To make selections:
- Click
. - Optional: Perform these tasks:
-
To enter search criteria (member name or alias only), press Enter (from the desktop) or click Search (on mobile).
Note:
The search isn't case-sensitive. You can search for a word, multiple words, or wildcard characters. See Using Wildcards in Searches.
-
To change display options such as viewing variables and attributes, showing alias names, showing member counts, sorting alphabetically, refreshing the member list, or clearing selections, click
next to Search, and then select from the list of display options.
-
To filter the members that are displayed in the member list, under
next to Search, select Add Filter, and then select from the list of filter options.
Note:
Android users can click
to view and select filter options.
-
- Make selections by clicking a member in the member list.
To understand how related members are selected, see Member Relationships.
Note:
-
Selected members display a check mark and are moved to the Selections pane, if applicable.
-
To expand a parent member to see its child members, click the expansion icon to the right of the parent member name. Clicking the expansion icon will not select the parent member.
-
To clear selections you have made, click
and then select Clear Selection.
At times, you may find that a point of view and page axis member you want to select is suppressed. This occurs because a dimension selection in the point of view and page axis has invalidated other dimensions due to valid intersections that were applied. To resolve this issue, use the Clear Selection option to clear the point of view and page axis members you previously selected. Then you can use the point of view and page axis again to select members that were previously suppressed.
-
To show all the members that are suppressed due to valid intersection rules, click
and then select Show Invalid Members. Invalid members are displayed but are unavailable for selection.
-
- Optional: Perform these tasks:
-
To further refine which related members are selected in the Selections pane, click
to the right of the member to display the member
relationships menu:
Click the relationship name to select the related members, excluding the selected member. Click the include icon
to the right of the relationship name to select the related
members, including the selected member.
For descriptions of the relationships, see Member Relationships.
-
If substitution variables or attributes are defined, below the member selection area, click
next to Members, and then select Substitution Variables or Attributes to select members for substitution variables or attributes. Members are displayed as children. Only members to which the user has read access are displayed in forms.
-
To move or remove members in the Selections pane, click
next to Selections.
-
To highlight the location of a selected member within the dimension hierarchy, double-click the member name in the Selections pane.
Note:
To highlight the location of a selected member on a mobile device, tap the member name in the Selections pane, and then tap Locate under
next to Selections.
-