This chapter provides an overview of organizational structure requirements and discusses how to:
Set up general options.
Define business units.
Define elimination entities.
Define account types, accounts, and account nodes.
Define ledger templates.
Establish ledgers.
Define models and scenarios.
Create trees.
Before you can define consolidation rules and establish consolidation models, you must define the supporting data that describes your organizational structure, including:
General options |
These include installation options, country and state information, accounting calendars, timespans, currency-related tables, user defaults, units of measurement, market rates, and so on. |
Business units |
These include all hierarchical entities on the consolidation tree. |
Elimination entities |
Entities used to book intercompany eliminations. |
Account types, accounts, and account nodes |
These include the accounts, their account types (categories such as Asset, Liability and so on), and the account nodes to be used on account rollup trees. |
Ledger templates and ledgers |
The ledger used for consolidation. |
Models and scenarios |
Models and scenarios by which to group and process consolidation data. |
Trees |
These include trees to establish the account rollup and consolidation entity hierarchy. |
The topics in this chapter are covered in detail in the PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook The information covered in this chapter provides supplemental details that are specific to Global Consolidations.
There are several supporting objects that you must establish within PeopleSoft Enterprise Performance Management that are used by Global Consolidations. These include installation options, country and state information, accounting calendars, timespans, currency-related tables, user defaults, units of measurement, market rates, and so on. Refer to PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook for details.
See Setting Up EPM Infrastructure, Business Rules, and Security.
This section provides an overview of business units and discusses how to establish business units for Global Consolidations.
Business units in Global Consolidations can be legal entities, a portion of a legal entity, or a collection point for consolidation-specific entries. Several categories of business units are used in Global Consolidations. It is important to understand how they differ and the terms used to refer to them.
Represents a strategic view of an organization that is used for reporting and analysis by PeopleSoft EPM. Because ledger records are associated with a business unit, each set of ledger data that you load into PeopleSoft EPM must be associated with a warehouse business unit. Each of your subsidiary business units must be defined as a warehouse business unit. |
|
A warehouse business unit that is associated with a consolidation ledger. This is the highest level business unit, to which all subsidiary amounts are consolidated. To designate that a business unit is a common consolidation business unit, on the Warehouse Business Unit page, in the Business Unit Type group box, select the Consolidated check box. The system uses this business unit to determine the setID, which is the key in defining the common calendar and common chart of accounts for the consolidation model. This is the business unit that you specify when entering the parameters for running the consolidation engines. Even though consolidations can be performed on any dimension, or ChartField, a common consolidation business unit is always required. |
You must define a warehouse business unit for each subsidiary, affiliate, and consolidation tree node. You will also need to establish warehouse business units to hold elimination results for each node on the consolidation tree.
See Defining Elimination Entities.
Page Name |
Definition Name |
Navigation |
Usage |
BUS_UNIT_TBL_PF1 |
EPM Foundation, Business Metadata, Business Framework, Warehouse Business Units |
Establish warehouse business units and specify their base currency and type. |
Access the Warehouse Business Unit page (EPM Foundation, Business Metadata, Business Framework, Warehouse Business Units).
This page is described in detail in the PeopleSoft Enterprise Performance Management Fundamentals PeopleBook. The Business Unit Type group box is particularly important to PeopleSoft Global Consolidations, and includes these options:
Select to indicate a business unit to which you are associating a consolidation ledger. For example, when you are defining a common consolidation business unit, you would select this check box. Typically you would not select this check box for subsidiary business units. |
|
Select to disable this business unit from running processes; as a result, the business unit does not appear as a valid business unit in the drop-down list boxes on run control pages. When consolidating by business unit, you may select this check box for business units on your consolidation tree that are used as summarization nodes or as elimination business units, as long as you do not intend to use those business units for additional processing. Selecting this check box in Add mode disables the Create BU button. In general, elimination entities for ledger business units should be marked as non-processing to ensure that elimination entities are not selected when the system populates the ledger preparation rule with business units to be processed. |
This example shows a simple consolidation tree and how business units are hierarchically arranged on the tree:
In the example, AMERI and USCON are summarization nodes, so they should be set up as non-processing business units. Business units E1000, E1300, and E1330 are elimination business units, and they should also be set up as non-processing business units. The root node, business unit 10000 in this example, is the common consolidation business unit.
Note. It is not a requirement for the common consolidation business unit to be the root node on the consolidation tree.
See Also
Establishing Warehouse Business Units Manually
Guidelines for Consolidation Trees
This section provides an overview of elimination entities and discusses how to establish elimination entities.
Elimination entities are used to book the journal entries that result from consolidation processing. These entities are part of your consolidation tree; there must be a single elimination entity for each branch or parent node on the tree. The elimination entity doesn't necessarily represent an actual object within your organization, rather it is a logical object that the system uses to book elimination journals. The objects that you use as elimination entities must be previously defined.
For example, if you are consolidating by business unit, you would need to establish a warehouse business unit for each elimination business unit (by using the Warehouse Business Unit page). Likewise, if consolidating by department, each elimination department would need to be established (by using the EPM Foundation OW-E Department Dimension Maintenance page).
Defining Warehouse Business Units as Elimination Entities
When you define a warehouse business unit that is solely used an elimination entity, select the Non-Processing option in the Business Unit Type section.
This is an example of a warehouse business unit that will be defined as an elimination entity:
Note that the Business Unit Type is Non-Processing.
Page Name |
Definition Name |
Navigation |
Usage |
GC_ELIM_TBL |
Global Consolidations, Define Consolidations, Common Definitions, Elimination Entity |
Establish elimination entities by identifying the entities to which elimination journal entries that result from consolidation processing are booked. |
Access the Elimination Entity page (Global Consolidations, Define Consolidations, Common Definitions, Elimination Entity).
To access the page, specify the setID, consolidation dimension, ledger template, and value. The value is equivalent to the name of the elimination entity, and represents its value within the consolidation dimension.
Specify the effective date and status.
This section provides an overview of account types, accounts, and account nodes and discusses how to:
Define account types.
Define accounts.
Define account nodes.
Accounts categorize monetary values stored in ledgers and classify the nature of a transaction. Typically you can load subsidiary ledger accounts by using the extract, transform, and load (ETL) tool within PeopleSoft EPM, but you may need to create the accounts used by your consolidation ledger.
Account types categorize accounts that normally appear on a balance sheet versus those that appear on an income statement, and also specify whether or not accounts are balance forward accounts. You need to define your organization's account types and assign the balance forward flag appropriately. When you define a new account, you associate it with an account type.
Account nodes are used with account trees to associate detailed accounts with the tree. In this example, the account nodes CASH, RECEIVABLES, INTERUNITREC, and INVENTORIES are all assigned ranges of detailed accounts.
See Also
Establishing Warehouse Business Units Manually
Setting Up Account Information
Page Name |
Definition Name |
Navigation |
Usage |
ACCT_TYPE |
EPM Foundation, Business Metadata, Business Framework, Account Types |
Define account types to assign to each account. Account types typically designate balance sheet or income statement accounts. |
|
ACCOUNT_TBL1 |
EPM Foundation, Business Metadata, Business Framework, Accounts |
Define accounts. |
|
PF_ACCT_NODE_DFN |
EPM Foundation, Business Metadata, Business Framework, Account Nodes |
Define the account nodes that you use to assign accounts to an account tree. |
Access the Account Types page (EPM Foundation, Business Metadata, Business Framework, Account Types).
The Balance Forward check box, in combination with the Consolidation Ledger Format Option, controls how the account data is stored and processed.
When you define accounts by using the Accounts page, the accounts adopt the balance forward attribute of the account type that you assign to them. |
Access the Accounts page (EPM Foundation, Business Metadata, Business Framework, Accounts).
Monetary Account Type |
Select the account type associated with this account. |
Within the Account region, indicate which application this account is associated with.
GL Account |
Select for your Global Consolidation accounts. This indicates that the account is a transaction-based account. |
The remaining fields on this page do not apply to PeopleSoft Global Consolidations.
Access the Account Nodes page (EPM Foundation, Business Metadata, Business Framework, Account Nodes).
On the Account Nodes page, define account nodes which you will later associate with trees and assign accounts to. The Account Nodes page displays an Effective Date, Status, and Description for each node.
This section provides an overview of ledger templates and discusses how to:
Define consolidation ledger templates.
Define source subsidiary ledger templates.
Define spreadsheet/manual entry ledger templates.
See Also
Defining Performance Ledger Templates
A ledger template is similar to metadata; it describes the physical structure of ledger record objects, and designates which database records a ledger uses. In addition, for consolidation ledgers, it defines the ledger format and consolidation processing method.
Ledgers for which you need to establish ledger templates are:
Consolidation ledgers.
Contain the consolidated ledger data. The source subsidiary ledger data is moved into the consolidation ledger during the ledger preparation process. The data in the consolidation ledger is updated when you run the consolidation processes.
Source subsidiary ledgers.
Contain subsidiary data prior to consolidations. The ledger preparation process converts the subsidiary ledger data to the common consolidation ledger structure, then moves the data into the consolidation ledger. Each subsidiary ledger with a unique structure must have its own separate ledger template. Source subsidiary ledgers can be standard general ledgers, budgeting ledgers, performance ledgers, etc.
Spreadsheet/manual entry ledgers.
Contain subsidiary data prior to consolidations that is entered using the spreadsheet upload or manual entry page. This data is also source subsidiary ledger data, but is managed separately from data that is automatically loaded.
On the consolidation ledger template, you specify whether the consolidation ledger uses a financial statement format or a trial balance format.
Consolidation ledgers using the financial statement format store and process ledger data in this manner:
Balance sheet account types, including balance sheet memo items, are end-of-period balances, and no period activity amounts are calculated. The Balance Forward check box on the Account Type page should be selected for balance sheet account types.
Income statement, other change in capital, and income statement memo account types are period activity amounts. The Balance Forward check box on the Account Type page should not be selected for income statement account types.
The balance sheet is fully balanced (all changes in equity, such as net income, are closed to the balance sheet each period).
All changes to equity on the balance sheet are included in the income statement or statement of change in shareholders equity.
That is, last period equity plus this period change in equity equals this period equity.
Consolidation ledgers using the trial balance format store and process ledger data in this manner:
All account types are stored as period-activity amounts.
(End-of-period balances for balance sheet account types can be calculated for inquiry and reporting purposes.)
The entire set of accounts (all account types except memo items) are used in balancing monetary amounts; the balancing account type rule specifies which accounts must balance.
The Balance Forward check box on the Account Type page determines how data is displayed on inquiry pages when the Amount Type of End of Period/Period Activity is selected:
If the Balance Forward check box is selected, the data for that account type is displayed as an end of period balance.
If the Balance Forward check box is not selected, the data for that account type is displayed as a period activity amount.
Processing Options for Consolidation Ledgers
For trial balance format ledgers, you specify whether to run the consolidation processes using year-to-date (YTD) data or data for a single period.
If the processing method is set to use YTD data, all periods less than or equal to the period specified in the run control are processed for the specified fiscal year.
A reversal batch is also created for the next period with the amounts reversed, so that when you process that next period, duplicate data is not created (because you will be running for all periods up to and including that period, each time that you run). When posting the journals for the run, you must make sure that the reversal batch is also posted. With this method, if you plan to run the engines by using the proforma option, which includes journals that have not been posted, the journals created in prior periods are included.
If the processing method is set to use period data, only the specified period is processed.
This method is more efficient, but includes only ledger data for the period specified in the run control. With this method, if you plan to run the engines by using the proforma option, which includes journals that have not been posted, the journals created in prior periods are not included.
For financial statement format ledgers, the system uses the end-of-period balance for balance forward accounts, and the period activity amounts for non-balance forward accounts.
Note. After you establish the processing method and ledger format, don't change them.
See Also
Defining Performance Ledger Templates
Page Name |
Definition Name |
Navigation |
Usage |
LEDGER_TEMPLATE1 |
EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Ledger Template |
Define the database records used for a ledger template. |
|
LEDGER_TMPLT_CF |
EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Ledger Template, ChartFields |
Define the database records used for ChartFields for this ledger template. Note. This page is used only by certain ledger types. It is not used if the EPM Ledger Type (PeopleSoft Enterprise Performance Management ledger type) field is set to Consolidation Source Ledger. |
|
LEDGER_TMPLT_EDPST |
EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Ledger Template, Edit and Post Variables |
Define the database records used for edit and post variables. Note. This page is not used if the EPM Ledger Type field is set to Consolidation Source Ledger. |
|
GC_LEDGER_TEMPLATE |
EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Ledger Template, Consolidation Variables |
Define the database records used for consolidation-specific objects. This page is available only for ledger templates used in consolidations, such as consolidation ledgers and consolidation source ledgers. Select the Used in Consolidations check box on the Ledger Template page, or set the EPM Ledger Type field to Consolidation Source Ledger or Consolidation Ledger, to access this page. |
Access the Ledger Template page (EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Ledger Template).
Note. General instructions for defining ledger templates appear in the PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook The following information applies specifically to ledger templates created for use with Global Consolidations.
To define a ledger template for a consolidation ledger (CLED):
Access the Ledger Template page, specifying the ledger template ID.
Select the Detail Ledger option.
Consolidation ledgers must be detail ledgers.
Select Consolidation Ledger in the EPM Ledger Type field.
Select the Used in Consolidations check box, if applicable.
This is optional for a consolidation ledger. Select Used in Consolidations only if this consolidation ledger will be used as input to another consolidation.
Select the ledger record (table) name.
This is the database record that you create for the consolidation ledger (GC_CLED_MGT_F00 or a clone based on this record).
Select the journal line record.
This is the database record that you create for the journal table (GC_JRNL_MGT_F00 or a clone based on this record).
Completing the Ledger Template - ChartFields Page
Select the ChartFields tab to access the Ledger Template - ChartFields page and enter values for the location of tables for the ChartFields.
Completing the Ledger Template - Edit and Post Variables Page
Select the Edit and Post Variables tab to access the Ledger Template - Edit and Post Variables page.
The database records are GC_CLED_MG1_T, GC_CLED_MG2_T, GC_CLED_MG3_T, and GC_CLED_MG4_T, for temp tables 1–4, respectively or cloned versions of these temp tables if your consolidation ledger structure was modified.
Completing the Ledger Template - Consolidation Variables Page
Select the Consolidation Variables tab to access the Ledger Template - Consolidation Variables page, and select the database record that you defined for each of these objects.
The Source Staging and Source TSE Record tables are not used by a consolidation ledger (CLED) and should be left blank; the remaining fields are required.
The Staging Journal variable is required when publishing consolidation journal data back to a ledger in PeopleSoft General Ledger. The value in this field should be the name of the journal publish table. The default value is GC_JPUB_MGT_TBL.
Select the ledger format option and the processing method.
Financial-statement-based ledger formats must use the Use period data processing method.
Select flow processing if you want to use data flows for consolidations.
After selecting the flow processing option, enter the Flow Activity Record, Flow Input Record, Flow Activity Work, and Flow Activity Work2 data base records that you defined for each of these objects.
The Flow Activity Record value is GC_FLOW_MGT_F00.
The Flow Input Record value is GC_FLIN_MGT_F00.
The Flow Activity Work value is GC_FLOW_MG2_T.
The Flow Activity Work2 value is GC_FLOW_MG3_T.
See Also
Establishing Required Record Objects
Understanding Ledger Templates
Understanding Journal Publishing
You also must define ledger templates for all subsidiary ledgers used as source data for consolidations. This information is used by the ledger preparation engine to locate the source data during processing.
Note. General instructions for defining ledger templates appear in the PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook The following information applies specifically to ledger templates created for use with PeopleSoft Global Consolidations.
This illustrates the Ledger Template page for a subsidiary ledger:
To define a source subsidiary ledger template:
Complete the Ledger Template page:
Select the EPM ledger type.
Select Consolidation Source Ledger for non-PeopleSoft source ledgers. The other ledger types listed are PeopleSoft ledgers; select the appropriate type if your source ledger is from another PeopleSoft application.
Select the Detail option.
Consolidation source ledgers must be detail ledgers.
Select the Used in Consolidations check box.
Specify the ledger record.
This should be the database record that contains the source ledger data such as PS_LEDGER.
Access the Ledger Template - Consolidation Variables page, and specify the database record used for the source staging ledger and the Source Transaction Set Edit (TSE) Record.
The remaining fields on the page do not apply to source subsidiary ledger templates.
You also must define ledger templates for all spreadsheet/manual entry ledgers used as source data for consolidations. This information is used by the ledger preparation engine to locate the source data during processing. To define a spreadsheet/manual entry ledger template:
Note. General instructions for defining ledger templates appear in the PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook The following information applies specifically to ledger templates created for use with PeopleSoft Global Consolidations.
This illustrates the Ledger Template page for manual entry ledgers:
Complete the Ledger Template page:
Select the EPM ledger type.
Select Spreadsheet Input Ledger for spreadsheet/manual entry ledgers.
Select the Detail option.
Consolidation source ledgers must be detail ledgers.
Select the Used in Consolidations check box.
Select the ledger record.
This should be the database record that contains the spreadsheet/manual entry ledger data.
In this case the record is GC_LEDMANL_F00.
Select the Journal Line record.
In this case the record is PF_JRNL_F00.
Complete the Ledger Template - ChartFields page.
Access the Ledger Template - Consolidation Variables page, and specify the database record used for the source staging ledger and source TSE record.
The database record used for the source staging ledger is GC_SLED_MANL.
The database record used for the source TSE record is GC_TSE_MANL_FLD.
The remaining fields on the page do not apply to spreadsheet/manual entry ledger templates.
Consolidation Ledger Type Summary
This table summarizes the most commonly used consolidation ledger types, consolidation variables, and whether they are used in consolidations:
Ledger Use |
Ledger Type |
Select Used in Consolidation Check Box? |
Consolidation Variables SRC_TSE and SRC_STG Required? |
Consolidation Variable Other Required? |
Consolidation Ledger |
Consolidation Ledger |
Optional |
Optional |
Yes |
Source Subsidiary — Consolidation Source |
Consolidation Source |
N/A |
Yes |
N/A |
Source Subsidiary—Standard GL and other sources |
Standard General Ledger Others |
Yes |
Yes |
N/A |
Source Subsidiary –Spreadsheet/Manual |
Spreadsheet Input |
Yes |
Yes |
N/A |
This section provides an overview of ledgers and discusses how to define consolidation ledgers or consolidation source ledgers.
After you have defined ledger templates for your consolidation ledger, spreadsheet/manual entry ledgers, and consolidation source ledgers, you create the ledgers with which to associate them. These ledgers are always detail ledgers. When establishing a ledger, you indicate whether it must balance. For trial balance format ledgers, you also need to specify the format in which the data is received, by account type.
The rules that apply to the relationship between the source subsidiary ledgers and the consolidation ledger are:
If your consolidation ledger is in the financial statement format, then source data maps to balance forward account types must contain period end balances, and source subsidiary ledger data that maps to non-balance forward account types must contain period activity.
If your consolidation ledger is in the trial balance format, the source subsidiary ledger data can be either period end balances (also referred to as YTD balances) or period activity; indicate on the ledger definition for each source subsidiary which account types are received as YTD amounts.
During ledger preparation processing, the YTD amounts are converted to current period activity. If none of the account types are received as YTD, then the system assumes that the source subsidiary ledger balances are for period activity.
Period 0 is required for trial balance format ledgers.
Account balances are stored in the consolidation ledger as debit (positive) or credit (negative) values. You must load the source ledger into the warehouse with the account balances as debit or credit amounts.
Page Name |
Definition Name |
Navigation |
Usage |
LEDGER_DETAIL1 |
EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Detail Ledger, Definition |
Create a detail ledger and associate it with its ledger template. |
|
GC_LED_DEFN_TBL |
EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Detail Ledger, Consolidations |
Indicate if the ledger should be a balanced ledger, if any account type balances are in YTD format, and establish contact information for the different phases of consolidations. |
Access the Detail Ledger - Definition page (EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Detail Ledger, Definition).
Enter the description, and select the ledger template used by this ledger.
Optionally, complete the remaining fields on this page, which vary depending on the EPM ledger type of the associated ledger template (specified on the Ledger Template page):
Ledger |
Enter the name of the detail ledger. This field acts as a filter, and associates only the subset of data from the database ledger record defined by the specified ledger to this ledger. This field is available when the EPM ledger type is a non-EPM source ledger, such as Standard General Ledger, or when the EPM ledger type is set to Consolidation Source. |
Budgeting Scenario |
Indicate to which budgeting scenario this ledger is associated. (Applies only when the EPM ledger type is set to one of the budget ledger types.) This field acts as a filter, and associates only the subset of data from the database ledger record defined by the specified budgeting scenario to this ledger. |
Scenario ID |
Specify a scenario for this ledger. The scenario acts as a filter, and associates only the subset of data from the database ledger record defined by the scenario to this ledger. This option applies only to these EPM ledger types: consolidation ledger, performance management ledger, and planning ledger. If the EPM ledger type is Consolidation Ledger, you typically leave the Scenario ID blank. For consolidation source ledgers based on an EPM ledger (the EPM ledger type is Performance Management or Planning Ledger and the Used in Consolidations field is selected), enter a scenario ID to use the data defined by that scenario as input for consolidations. |
Access the Detail Ledger - Consolidations page (EPM Foundation, EPM Setup, Ledger Setup, Ledgers, Detail Ledger, Consolidations).
Balanced Ledger |
Select if you require that accounting entries balance for this ledger. If this check box is not selected, the system permits unbalanced accounting entries. |
Account Type |
If any of the balances for the various account types in the ledger are received as YTD amounts, select the account type in the Account Types Received as YTD grid, adding rows as needed. |
In the Contact List for Consolidation Processes region specify who to contact for information about the different phases of consolidations, by ledger business unit.
For each row, indicate the Ledger Business unit, the Employee ID of the contact person, and the Functional Area for which the contact person is responsible. Select the Work Number and Email tab, then enter the contact person's Work Phone number and Email Address. Select the Department and Location tab and enter the Department, Location, and any Comments.
Note. You associate a consolidation ledger with a common consolidation business unit when you establish a consolidation model.
See Also
Establishing Consolidation Models
This section provides an overview of models and scenarios and discusses how to set up models and scenarios.
Models and scenarios group together related rules that are used as a unit of work when processing. A model is a categorization within which you group related data. Models are associated with a scenario. A scenario represents a related set of data to treat as a distinct group—such as budget, actual, or forecast—to process together.
See Also
Setting Up Models and Scenarios
To set up models and scenarios:
Access the Model Definition page to define models (EPM Foundation, Business Metadata, Business Framework, Models).
You must create a model definition before you can further define the model as a consolidation model.
Access the Scenario Definition page to define scenarios (EPM Foundation, Business Metadata, Business Framework, Scenarios).
When creating the scenario for use with consolidations, select the Consolidated check box, and then on the Scenario - Historical Business Rules page, select the consolidation model in the Consol Model field.
Associate a scenario with the common consolidation business unit by using the Warehouse Business Unit Scenario Definition page (EPM Foundation, Business Metadata, Business Framework, WBU Scenario Definition).
Note. You do not need to associate any other business units used in the consolidation with the scenario.
This section provides an overview of how trees are used in Global Consolidations and discusses how to create trees.
Trees are used in Global Consolidations to describe your consolidation structure, for reporting, and for defining ChartField value sets. For detailed information about creating trees, see the PeopleTools Tree Manager documentation.
See PeopleTools PeopleBook: PeopleSoft Tree Manager
You create consolidation trees to depict the hierarchical relationship of the entities within a consolidation. You must define a different consolidation tree for each unique dimension by which you consolidate. For example, to create two consolidation models—one that consolidates by business unit and one that consolidates by department—you would need a separate tree for each. You assign one consolidation tree per consolidation model. When you process consolidations, you specify which node of the tree (and its descendents) to consolidate. Consolidation trees are node-oriented trees.
Each branch or parent node in your consolidation tree must include one, and only one, elimination entity. Journal entries created during consolidation processing are booked to the elimination entity. This is a "logical" object that must be defined within the dimension table of the consolidation dimension. For example, if your consolidation dimension is department, then you need to create a "logical" elimination department at each node of the consolidation tree. If you are consolidating by business unit, you need to create a business unit definition for the elimination entity. Typically the root node of a business unit consolidation tree is the common consolidation business unit, but that is not a requirement.
When processing eliminations, equitization, and non-controlling interest, the system uses the tree structure to determine where to book the resulting journal entries. Elimination and non-controlling interest book the entries for each entity in the consolidation tree at the corresponding elimination node. Equitization records the reversing entries in the elimination node; the equitization entries are booked to the parent. In cases where transactions occur between business units (or other consolidation dimension) located at different levels of the tree, the application engines use the lowest common elimination entity between parent and subsidiary to book the entries.
Besides the consolidation tree, there are other trees that you need to define. For example, you use an account tree when establishing ChartField value sets to specify a group of particular accounts. You must create a business unit tree for the consolidation model even when you are consolidating by a dimension other than business unit. In addition, trees are used for some inquiry pages as reporting trees, and control the level at which information is grouped. Trees used as inquiry page reporting trees must be defined with the Use of Levels field set to strictly enforced.
You must establish metadata for each tree that you define. Within the PeopleSoft Performance Warehouse framework, the metadata is used when running processes and using inquiry pages. Refer to the PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook for information about setting up metadata.
See Setting Up and Flattening Tree Metadata.
Page Name |
Definition Name |
Navigation |
Usage |
PSTREEDEFN |
Tree Manager, Tree Manager |
Create trees. |
|
Tree Metadata |
PF_METATREE_TBL1 |
EPM Foundation, Business Framework, Tree Metadata, Tree Metadata |
Establish metadata for the tree that is used when running processes and using inquiry pages. |
For detailed information about creating trees, see the PeopleSoft Tree Manager documentation in PeopleTools PeopleBook: PeopleSoft Tree Manager.
For detailed information about establishing tree metadata, see PeopleSoft Enterprise Performance Management Fundamentals 9.1 PeopleBook.
See Setting Up and Flattening Tree Metadata.