Selecting Members

When you create runtime prompt variables, you can use Multiple Member Selection to provide users with a range of members from which they can choose a member or members at runtime. Limiting the members that users can select for a runtime prompt variable ensures that users choose valid members against which to validate or launch the business rule or sequence.

When you add actions and formulas to graphical business rules, you can also use Multiple Member Selection to select members that define the business rule range, the formula range, and the destination for copied values.

*  To select multiple members:

  1. In the Multiple Select dialog box, select a member you want to include from the database outline.

  2. Use the drop-down list below the arrow keys to select additional members based on their relationship to the member you selected in step 1. This prevents you from having to select each of the members individually.

    For example, assume you selected Year as your dimension and want to include Qtr1 and its child members in the selection. To do this, you select Qtr1 from the outline and Descendents (inc) from the drop-down list.

  3. Use the right arrow key to move all of the members you selected to the Selected list in the right side of the dialog box.

  4. Optional: Select the same or a different member from the outline, then use the drop-down list and the Excluded text box to exclude members based on their relationship to the member you select.

    For example, assume you want to exclude Qtr2 and its child members from the selection. To do this, you select Qtr2 from the outline and Descendents (inc) from the drop-down list. Then you use the down arrow key to move Qtr2 and its child members to the Excluded list.

  5. If you want to use aliases for the members names, select an alias table from the Alias Tables drop-down list, then select the Use Alias Names check box.

  6. If you are selecting members for graphical business rules, there is a Local Variables and a Global Variables tab from which you can select variables. To select variables, repeat steps 1-4 above for the Local and the Global Variables tab.

  7. Click OK after you move the members you want to include to the Selected list, and move members you do not want to include to the Excluded list.