Skip to Main Content
Return to Navigation

Defining Allocation Manager Rules

This topic provides an overview of allocation rules setup, fixed source and fixed basis options in allocations, lists prerequisites, and discusses how to:

Pages Used to Define Allocation Manager Rules

Page Name

Definition Name

Navigation

Usage

Fixed Dimension Setup

PF_AL_DIM_TBL

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Fixed Basis Dimensions, then select Fixed Dimension Setup

Determine the list of dimensions that you can use with fixed source and basis.

Allocation DataMap Setup

PF_AL_DM_TBL

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select DataMap Setup, then select Allocation DataMap Setup

Create a list of sources for the source, basis, or target and specify dimensions for your datamap. The purpose of this page is to reduce the of number datamaps from which to choose. In addition, you can give the datamaps more intuitive names. Add as many datamaps as necessary.

Select Dimensions

PF_AL_SELECT_DIM

Click the Select Dimensions button on the Allocation DataMap Setup page

Select the dimension metadata type.

Rules - Method

PF_AL_METHOD_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Rules, then select Method

Define an Allocation Manager rule and select the method.

Rules - Copy Rule

PF_AL_RULE_COPY

Click on the select Save As button on the Allocation Manager Rules - Method page.

Copy Allocation Manager rules.

Rules - Source

PF_AL_SOURCE_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Rules, then select Source

Define the allocation rule sources.

Fixed Source Dimension Setup

PF_AL_USE_FSRC_DIM

Click on theselect Choose Fixed Source Dimension link on the Allocation Manager Rules - Source page.

Select which dimensions for a fixed source.

Rules - Basis

PF_AL_BASIS_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Rules, then select Basis

Define the allocation rule basis.

Fixed Basis Dimension Setup

PF_AL_USE_FIX_DIM

Click on the Choose Fixed Basis Dimension link on the Allocation Manager Rules - Basis page.

Select which dimensions for a fixed basis.

Rules - Source to Basis Relationship

PF_AL_COM_DIM_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Rules, then select Source to Basis Relationship

Review all common dimensions between the source and the basis.

Rules - Target

PF_AL_TGT_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Rules, then select Target

Define the target, including the allocation mappings. The target is the destination to which the amounts that are defined by the source and basis are allocated.

Allocation Manager Rules - Residual

PF_AL_RESID_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Rules, then select Residual

Assign residual amounts after the source amount has been allocated to dimensions in the target datamap. You can specify the residual account to use and other dimensions as applicable.

Rules - Offset

PF_AL_OFFSET_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Rules, then select Offset

Specify offset target information based on dimensions in the target datamap.

Allocation Template

PF_AL_TMPLT_DEFN

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Allocation Template

Predefine a set of source, basis, and target datamaps that you can later associate with any allocation rule.

Understanding Allocation Rule Setup

The following list represents required and optional tasks necessary to set up allocation rules.

  1. Define datamaps for your source, basis, and target.

    This step is a required prerequisite.

    Note: PeopleSoft provides the Datamap Wizard to greatly simplify the creation of datamaps.

    The Datamap Wizard can be found using either of these navigation paths:

    EPM Foundation, Foundation Metadata, Metadata Wizards, Datamap Wizard

    EPM Foundation, Data Enrichment Tools, Allocation Manager, Datamap Wizard

    See Datamap Wizard Page.

  2. Select fixed dimensions to use with a fixed source or basis.

    This step is optional if you are not using a fixed source or basis.

  3. Select DataMaps for the allocation source, basis, and target.

    This step is required.

  4. Define an allocation rule and select the calculation method.

    This step is required.

  5. Define the allocation rule source.

    This step is required.

  6. Define the allocation rule basis.

    This step is required.

  7. Review all common dimensions between the source and the basis.

    This step is required.

  8. Define the allocation rule target, including the allocation mappings.

    This step is required.

  9. Assign post-allocation residual amounts.

    This step is optional.

  10. Specify offset target information.

    This step is optional.

With the exception of the first list item above, you use the Allocation Manager Rules component to set up all remaining tasks.

Note: You must set up the DataMaps and constraints you want to use in the allocation prior to creating an allocation rule.

See Defining Allocation Manager Rules, Setting Up Datamaps.

Streamlining Allocation Rule Setup with the Allocation Template

PeopleSoft EPM provides an allocation template that enables you to predefine a set of source, basis, and target DataMaps that you can later associate with any allocation rule, thereby saving time and ensuring DataMap consistency among various users setting up allocation rules.

When you define an allocation template you can associate it with an allocation rule using the Template field on the Method page, which is a part of the Allocation Manager Rules component. Once you select a template on the Method page, the appropriate source, basis, and target DataMaps automatically populate the Source, Basis, and Target pages.

See Allocation Template Page.

Understanding Allocation Manager Fixed Source and Fixed Basis Options

Allocation Manager gives you the flexibility of adding fixed source and basis values in an allocation rule without referencing a database table. For example, you may only have a few dimension values that you want to use in a rule, like a source amount of $100,000 that you want to allocate to the accounts in the Basis table. Or, you may want to perform an arithmetic allocation and multiply all values by a fixed rate of 0.25. In these cases, it is much simpler to input the value in the rule, without having to create a database table.

You use datamap metadata to define the tables that contain the source, basis, and target for your allocation in the Allocation Manager rule. However, in some cases you might not have source or basis data stored in tables in your database. To accommodate this situation, we deliver a set of metadata (the FIX_BASIS datamap, filters and constraints PF_AL_FIX_SOURCE , PF_AL_FIX_BASIS) that point to the same fixed source and basis table (PS_FP_AL_FIX_BASIS). You can tailor this table by adding your organization's dimensions to it on the Fixed Dimensions page. Use the Fixed Dimension page to list the dimensions and assign prompt tables and trees and select values for each dimension.

Note: Fixed source and basis is used with the Allocation Manager only. It is available with all allocation methods except period-based allocation.

Note: Before you create an Allocation Manager rule to associate with a SetID, create a PF_AL_FIX_BASIS and PF_AL_FIX_SOURCE filter and constraint for that SetID. You can model the setup for the PF_AL_FIX_BASIS and PF_AL_FIX_SOURCE filter and constraint using the sample data under the SHARE SetID.

Calculating Offset Target Information (Optional)

Allocation Manager enables you to calculate offsets for the target balance. Offset accounts aid in balancing source transaction and budget entries. You can use offsets to balance ledgers. You can create either single or multiple offsets. A single offset allows a single target entry for the entire offset and multiple offsets create identical set of target entries with the target measure values negated. Also, a separate offset entry can be created for each of the residual amounts. You must ensure at least one key value is different from the residual entry in order to avoid collisions. The same is true if a single offset entry is selected.

The following is an example of an arithmetic method offset allocation account:

Source

Basis

Target

Department

Amount

Department

Unit

Department

Amount

CORP

1000

DIV1

0.1

DIV1

100

DIV2

0.1

DIV2

100

DIV3

0.2

DIV3

200

OFST (Offset Account)

=400

In this example, the offset account is equal to 400, which is the same total for Divisions (DIV) 1, 2, and 3.

Prerequisites

Before setting up your Allocation Manager rules, you must:

Fixed Dimension Setup Page

Use the Fixed Dimension Setup page (PF_AL_DIM_TBL) to determine the list of dimensions that you can use with fixed source and basis.

Image: Fixed Dimension Setup page

This example illustrates the fields and controls on the Fixed Dimension Setup page. You can find definitions for the fields and controls later on this page.

Fixed Dimension Setup page

Note: You can only change dimensions. Do not change attributes or the measure.

Allocation DataMap Setup Page

Use the Allocation DataMap Setup page (PF_AL_DM_TBL) to create a list of sources for the source, basis, or target and specify dimensions for your datamap. The purpose of this page is to reduce the of number datamaps from which to choose. In addition, you can give the datamaps more intuitive names. Add as many datamaps as necessary.

Image: Allocation DataMap Setup page

This example illustrates the fields and controls on the Allocation DataMap Setup page. You can find definitions for the fields and controls later on this page.

Allocation DataMap Setup page

Use the Select Dimensions page (PF_AL_SELECT_DIM) to select the dimension metadata type.

Image: Select Dimensions page

This example illustrates the fields and controls on the Select Dimensions page.

Select Dimensions page

Rules - Method Page

Use the Rules - Method page (PF_AL_METHOD_DEFN) to define an Allocation Manager rule and select the method.

Image: Method page

This example illustrates the fields and controls on the Method page.

Method page

Rules - Source Page

Use the Rules - Source page (PF_AL_SOURCE_DEFN) to define the allocation rule sources.

Image: Source page

This example illustrates the fields and controls on the Source page.

Source page

Image: Source page with fixed source option and Tree node button

This example illustrates the fields and controls on the Source page with fixed source option and Tree node button. You can find definitions for the fields and controls later on this page.

Source page with fixed source option and Tree node button

Selecting a Source

If you are not using fixed source, you must specify the source to use in the allocation.

Using a Fixed Source

Rules - Basis Page

Use the Rules - Basis page (PF_AL_BASIS_DEFN) to define the allocation rule basis.

Image: Basis page

This example illustrates the fields and controls on the Basis page.

Basis page

Image: Basis page with fixed basis option

This example illustrates the fields and controls on the Basis page with fixed basis option. You can find definitions for the fields and controls later on this page.

Basis page with fixed basis option

Note: If you selected the copy method, only the Basis Adjustment field is available on this page.

Selecting a Basis

Using a Fixed Basis

Select the values for each of the dimensions that you selected on the Fixed Basis Dimension Setup page.

Rules - Source to Basis Relationship Page

Use the Rules - Source to Basis Relationship page (PF_AL_COM_DIM_DEFN) to review all common dimensions between the source and the basis.

Image: Source to Basis Relationship page

This example illustrates the fields and controls on the Source to Basis Relationship page.

Source to Basis Relationship page

This page lists the common dimensions. Common dimensions are very important as they are used to determine the divisor, therefore the ratio, for the spread even and prorata methods. For all methods, they determine how the source and basis are to be grouped before applying any mathematical formulas. Select from which source to base dimensions by selecting the Use check box.

The system determines the common dimensions using the descriptions of the datamaps for the source and basis. It considers that any source and basis fields with the same description represent the same information and are therefore a common dimension if the fields are marked as dimensions on both the source and basis. When looking for common dimensions, the system ignores case and spaces at the beginning and end of the description.

Rules - Target Page

Use the Rules - Target page (PF_AL_TGT_DEFN) to define the target, including the allocation mappings. The target is the destination to which the amounts that are defined by the source and basis are allocated.

Image: Target page

This example illustrates the fields and controls on the Target page. You can find definitions for the fields and controls later on this page.

Target page

Allocation Manager Rules - Residual Page

Use the Allocation Manager Rules - Residual page (PF_AL_RESID_DEFN) to assign residual amounts after the source amount has been allocated to dimensions in the target datamap. You can specify the residual account to use and other dimensions as applicable.

Image: Residual page

This example illustrates the fields and controls on the Residual page. You can find definitions for the fields and controls later on this page.

Residual page

The following table provides an example of an arithmetic allocation rule in which the residual source amount is set up with a target department value of RES (Residual). DIV1, 2, and 3 use a total of 400. The residual amount is 600, so that amount is placed in the RES account.

Source

 

Basis

 

Target

 

Source Department

Amount

Basis Department

Unit

Department

Amount

CORP

1000

DIV1

0.1

DIV1

100

   

DIV2

0.1

DIV2

100

   

DIV3

0.2

DIV3

200

       

RES (Residual Account)

600

Rules - Offset Page

Use the Rules - Offset page (PF_AL_OFFSET_DEFN) to specify offset target information based on dimensions in the target datamap.

Image: Offset page

This example illustrates the fields and controls on the Offset page.

Offset page

Image: Offset page with single row offset option

This example illustrates the fields and controls on the Offset page with single row offset option. You can find definitions for the fields and controls later on this page.

Offset page with single row offset option

Allocation Template Page

Use the Allocation Template page (PF_AL_TMPLT_DEFN) to predefine a set of source, basis, and target datamaps that you can later associate with any allocation rule.

Image: Allocation Template page

This example illustrates the fields and controls on the Allocation Template page. You can find definitions for the fields and controls later on this page.

Allocation Template page

Use the Allocation Template page to predefine a set of source, basis, and target DataMaps that you can later associate with any allocation rule.

Fields Common to this Page

Source

Basis

Target