1. User's Guide
  2. Working with Management Ledger Profitability
  3. Working with Management Ledger Allocations
  4. Creating and Managing Management Ledger Allocations
  5. Defining and Managing Calculation Rules in Management Ledger Models
  6. Creating Management Ledger Allocation Rules
  7. Defining a Source for Management Ledger Allocation Rules

Defining a Source for Management Ledger Allocation Rules

Creating Management Ledger Allocation Rules describes how to create and describe a new allocation rule. The next step is to define an allocation source, the dimensions with the expense or other data you are assigning to an allocation destination.

To define the source from which the calculation rule will retrieve data to be allocated:

  1. In an open allocation rule, click the Source tab (Figure 10-9).

    Figure 10-9 The Source Tab of the Management Ledger Allocation Rule Definition Area


    Enter required information as described in the following steps.

  2. Select the dimension and member that holds the data to be allocated.

  3. Optional: Filter the members in the Member Selection area. See "Filtering Dimension Members" at the end of this topic.

  4. When the rule source information is complete, click Save button (Save).

  5. The next step is to enter a Destination for the allocated data.

Figure 10-10 shows that Furnishings and Equipment in the Occupancy Expense Allocations rule set will pull data from the CC2001 and CC5001 members of the CostCenters dimension.

Figure 10-10 Management Ledger Allocation Source Definition Example


The Dimensions and Member Selection areas of the Source tab enable you to define a rule data source.

To define a destination for the allocation rule, see Defining a Destination for Management Ledger Allocation Rules.

To edit and delete rules, see Managing Management Ledger Rules.

Filtering Dimension Members

Follow these steps to filter members in the Member Selection area of the Rule Definition screen:

  1. At the bottom of the Rule Definition area, click the arrow in front of Filter to expand the Filter area.

  2. To add a filter, click Add button or select Actions and then select Add Filter.

    Select a parameter such as Name, an Operator such as = or <>, and then enter a Value such as the first few letters of a name. Click OK to display members that match Value and add the filter to the table.

  3. To edit a filter, select it and click Edit button. Change the filter as you want and then click OK.

  4. To delete a filter, select it and click Delete button. The filter is deleted.