15.3.1.2.4 Allocation Source Pane

The Allocation Source pane is used to provide dimensional constraints on your Source data. For any dimension, you may constrain your source data by selecting a leaf member, a roll-up member within a Hierarchy, or a Hierarchy Filter.

At least one leaf-level dimension member is required for hierarchies used in allocations.

For allocation rules that source data from the Management Ledger-level, you must select a Source scenario from the Allocation Source pane. The default for new allocation rules is <Use Application Preferences>. When you use this default value, the Scenario (also called Consolidation Code) is determined by the value that is set in Application Preferences for Profitability Management for the user who is running the rule. If you do not select <Use Application Preferences>, you must select a defined dimension member value (for example, Actual, Budget, Forecast, Forecast Prior). These values are provided with the data model, but you may add additional dimension members in the Consolidation Code dimension.

The Source value for the Scenario can also be provided as a task parameter if the rule is executed within the following:

  • A Simplified Batch
  • A standard ICC batch
  • From the command line

When the Source value for the Scenario is passed as a task parameter, it overrides the value set in Application Preferences. For details on passing task parameters, see OFS Analytical Applications Infrastructure User Guide.

Figure 15-12 Allocation Source Pane


The Allocation Source pane is used to provide dimensional constraints on your Source data. For any dimension, you may constrain your source data by selecting a leaf member, a roll-up member within a Hierarchy, or a Hierarchy Filter.

The Source tab is used to provide input data to an allocation rule include:

Table 15-1 Examples of using the Source tab

Desired Data Constraint
Get all expenses for all GL Accounts within a specific cost center Single leaf constraint on Organizational Unit plus single leaf constraint on Financial Element 457 – Non-Interest Expense
Get all current mortgage balances for adjustable rate products originated in the past year Hierarchy member constraint on the Product dimension plus a Data Filter constraint
Get all initial General Ledger balances plus all allocated balances for a specified set of cost centers for one GL Account Single leaf constraint on General Ledger Account plus a Hierarchy member constraint on Organizational Unit
Get ending balances for all balance sheet assets for the North, South, and East divisions (but not the West division except for the South-West sub-region) Single leaf constraint on Financial Element plus Hierarchy member constraint on the GL Account dimension plus an Organizational Hierarchy Filter

The dimensions listed in the Allocation Source pane are limited to your Key Processing Dimensions. The seeded key processing dimensions for all OFS analytical application are:

  • Financial Element
  • Organizational Unit
  • General Ledger Account
  • Common Chart of Accounts
  • Legal Entity Product

You may add your Key Processing Dimensions (see the OFS Analytical Applications Infrastructure Installation Guide for how to add processing dimensions). If you have enabled multi-currency, the Currency dimension is also displayed. For details on multi-currency calculations within Profitability Management, see Multi-Currency across OFSAA Applications.