Corporation Switch User Manual

19-8 Oracle Financial Consolidation Hub User's Guide
are balances, the business process will not bring those balances into
EPB.
Solve
You can update how balances are calculated for each line item. The default behavior is
for child values to pull the balances from Enterprise Performance Foundation (Loaded)
and for parent values to sum their children's balances (Hierarchy Total). If you have Net
Profit being the parent of Revenue and Expense, you have to update Net Profit to make
it equal to Revenue minus Expense. To do so, perform the following steps:
1. Click Update for Net Profit.
2. Select Calculated and click Define Calculation.
3. Select Simple Math and click Continue.
4. For Line Item 1, select Revenue. For Operator, select - For Operand, select Line Item
2, Expense.
In addition, you need to stop Enterprise Planning and Budgeting from aggregating
along the entity dimension. Aggregation has already occurred during consolidation
processing.
1. For a line item which has a source of Loaded, click update.
2. Click Next.
3. Update Solve: Dimension Handling.
For the Entity Dimension, select Exclude From Solve. Click Next.
4. Update Solve: Input and Output Selections
For the Entity dimension, select Use Input as Output. Then for the Entity
dimension, click Update Input. Delete the existing step, and create a new step, that
is Select Members, and select all entities in your consolidation hierarchy. Click Next
twice, then Finish.
5.
You should be back under the Solve subtab. For the line item that you have just
modified, click Propagate.
6.
In the Settings region, select Input Selections, Output Selections, and Dimension
Handling. Select all line items in the Targets region. Click Apply.
Tasks
Add the following tasks in the given order:
1.
Load data - This pulls the balances into Enterprise Planning and Budgeting. Leave