After defining an allocation source, the next step is to define the members that describe where to allocate the data and how to allocate to the destination.

Selecting Members for the Destination

For each dimension in the Destination column, select the members that are to receive the allocated data. If you select a parent member, the allocation will go to its all its level 0 descendants.

To select members for the destination:

1. Click in the Destination column next to a dimension to enable Member Selector, Members Entry, and Functions.

   

2. With the row for the dimension selected, click an option to define the destination members for the dimension:

   • Member Selector:

     Click Member Selector to open the Select Members dialog box, where you can select the members to add to the source dimension. See Using the Member Selector.

     In this example, seven members have been defined for the Entity dimension.

     

     Tip:

     Selecting an upper-level member selects all the descendants of that member. For example, if you choose "All Accounts", then your selection is really all the Level 0 descendants of "All Accounts". The rule will execute an allocation for each level-0 member. Selecting an upper-level member eliminates the need to pick each specific member individually.

   • Members Entry:

     If you have several members to add to the destination dimensions and you know the member names, instead of adding each member one-by-one from the Select Members dialog box, click Members Entry and enter the dimension member names.

     For example, if you have a list of members in an Excel spreadsheet, you can copy these members from Excel, and then paste them into the Members Entry dialog box. The members will be added to the dimensions in the source to which they were assigned when the dimensions were created. See Adding Members to a Dimension.

     

     Tip:

     To add members to all applicable dimensions in the destination, click on the Destination row, and then click Members Entry. To add multiple members to a specific dimension, click on the dimension row, and then click Members Entry.

Defining How to Allocate to the Destination

The following options are available when defining how to allocation to the destination. To specify an option, click in the Destination column next to a dimension, and then click Functions.

• Same As Source: Defines the members set for a destination dimension to be the same as the members set for the source dimension. See Setting the Destination to Same as Source.

• Allocate to Parent: Creates a source to destination relationship for every member selection in the source, and targets its value to the member's parent. See Allocating to Parent/Siblings.

• Allocate to Siblings: Creates a source to destination relationship for every member selection in the source, and targets its value to the member's siblings. See Allocating to Parent/Siblings.