Processing Roll-Ups

Pages Used to Run Roll-Up Engines

Page Name	Definition Name	Navigation	Usage
Roll-Up Scenario	RUN_PF_SCN_ROLL	select EPM Foundation, then select Data Enrichment Tools, then select Roll-up Accounting Info, then select Scenarios, then select Roll-Up Scenario	Roll up scenarios to produce an aggregated scenario set of data based on the scenario tree. Generate your reports after you run the Scenario Roll-Up engine and the Calendar Roll-Up engine.
Roll-Up Calendar	RUN_PF_CAL_RU	select EPM Foundation, then select Data Enrichment Tools, then select Roll-up Accounting Info, then select Calendar, then select Roll-Up Calendar	Roll up calendars to produce an aggregate set of product data based on calendars.
Roll-Up Business Unit	RUN_PF_BU_ROLL	select EPM Foundation, then select Data Enrichment Tools, then select Roll-up Accounting Info, then select Business Units, then select Roll-Up Business Unit	Roll up business units to produce an aggregate business unit set of data based on the business unit tree.

Understanding EPM Roll-Up Engines

In EPM you can run calendar roll-ups on the application data, the performance ledger table (PF_LEDGER_F00), and roll up ledgers on the GL ledger table. In addition you can roll up scenario IDs and business units. Running the roll-up engines enables you to present the same information in a different (aggregated) way.

You can use the calendar roll-ups to roll up accounting periods based on the summary and detail calendars that you defined for your scenario. Most likely, you will use a calendar roll-up before you report on your scenario. For example, you may have monthly values in your current scenario data, but want to see quarterly values.

You can use the scenario ID and business unit roll-up engines to consolidate values. For example, when you define warehouse business units, you may specify that several business units roll up under a consolidated business unit. When you then run the business unit roll-up, the individual business unit data is aggregated into the consolidated business unit and can be reported in that way.

Note: Although the roll-up engines are usually the only job in a jobstream, they must still be set up in a jobstream. No merge is required on this engine.

Common Elements Used to Process Roll-Ups

Rerun

If you are rerunning this job with the same run control parameters, deselect the Rerun check box. This way, if you are assigned the same record suite and you were the last one to run in this record suite, the system does not re-resolve the tables prior to running the job. If you want to re-resolve the permanent tables, select the Rerun check box.

Re-resolving means that data is selected from the permanent table. If re-resolving is not needed (no new data in the permanent table for the given run control parameters), performance could be enhanced. Note that if the Rerun check box is selected, it will flatten (or reflatten) the business unit or the scenario tree.

Roll-Up Scenario Page

Use the Roll-Up Scenario page (RUN_PF_SCN_ROLL) to roll up scenarios to produce an aggregated scenario set of data based on the scenario tree. Generate your reports after you run the Scenario Roll-Up engine and the Calendar Roll-Up engine.

Navigation

select EPM Foundation, then select Data Enrichment Tools, then select Roll-up Accounting Info, then select Scenarios, then select Roll-Up Scenario

Image: Roll-Up Scenario page

This example illustrates the fields and controls on the Roll-Up Scenario page. You can find definitions for the fields and controls later on this page.

Business Unit, Scenario ID, Fiscal Year, and Accounting Period

Enter the business unit, scenario ID, fiscal year, and accounting period for the roll-up.

Tree ID

You can select a tree. Ensure that the tree you select contains a SetID.

Job ID

Select SCN_ROLL.

ABM

Select this check box to roll up the scenarios in the tables associated with PeopleSoft Activity-Based Management AB_JOB_CD_F00, CALC_DETAIL_F00, and CALC_OBJ_F00 tables.

BSC

Select this check box to roll up the scenarios in the tables associated with PeopleSoft Scorecard KP_DATAVALS_F00 table.

PF Ledger

Select this check box to roll up to the PF_LEDGER_F00 table.

Click Run to run this request.

Roll-Up Calendar Page

Use the Roll-Up Calendar page (RUN_PF_CAL_RU ) to roll up calendars to produce an aggregate set of product data based on calendars.

Navigation

select EPM Foundation, then select Data Enrichment Tools, then select Roll-up Accounting Info, then select Calendar, then select Roll-Up Calendar

Image: Roll-Up Calendar page

This example illustrates the fields and controls on the Roll-Up Calendar page. You can find definitions for the fields and controls later on this page.

Business Unit, From Scenario ID, Scenario ID, Fiscal Year and Period

Enter the business unit, from scenario ID, scenario ID, fiscal year, and accounting period for the roll-up.

Job ID

Select LED_ROLL.

ABM

Select this check box to roll up the calendars for PeopleSoft ABM.

PF Ledger

Select this check box to roll up performance ledger calendars.

Click Run to run this request.

Roll-Up Business Unit Page

Use the Roll-Up Business Unit page (RUN_PF_BU_ROLL) to roll up business units to produce an aggregate business unit set of data based on the business unit tree.

Navigation

select EPM Foundation, then select Data Enrichment Tools, then select Roll-up Accounting Info, then select Business Units, then select Roll-Up Business Unit

Image: Roll-Up Business Unit page

This example illustrates the fields and controls on the Roll-Up Business Unit page. You can find definitions for the fields and controls later on this page.

Business Unit, Scenario ID, Fiscal Year and Accounting Period

Enter the business unit, scenario ID, fiscal year, and accounting period for the roll-up.

Tree ID

You can select a tree. Ensure that the tree you select contains a SetID

Job ID

Select BU_ROLL.

ABM

Select this check box to roll up the business units for PeopleSoft ABM.

BSC

Select this check box to roll up the business units associated with PeopleSoft Scorecard.

PF Ledger

Select this check box to roll up business units for PF ledger.

Click Run to run this request.