Introduction

This 15-minute hands-on tutorial shows you how to rollup scenarios in Strategic Modeling, a solution provided by Oracle EPM Enterprise Planning. The sections build on each other and should be completed sequentially.

Background

Strategic Modeling provides on-the-fly scenario analysis and modeling with financial forecast modeling so that your operational plans, long range plans and financial strategy align.

The Strategic Modeling business process is comprised of one or more models. You perform long-term strategic planning within those models. Models contain predefined reporting and modeling standards, and are populated with a hierarchical chart of accounts, a time structure, reports, dataviews, account groups, and all the metadata from the template or the model from which it was created.

In Strategic Modeling you set up rollup structures to represent the structure of your organization. For example, you can conduct region-specific analysis, by setting up four regions within the Service division.

You can evaluate capital projects for a facility upgrade or a plant expansion by including separate models for them. You can choose to exclude some models from your rollup. Data from excluded models is not included in the rolled up scenario.

After you forecast each of your business segments, and potential investments, and rollup your scenario, you can review rolled up information for the whole company. rollup helps determine how changing business unit conditions affect parent company earnings and values. By reviewing the rollup scenario, you can make informed decisions about individual business units.

Prerequisites

Cloud EPM Hands-on Tutorials may require you to import a snapshot into your Cloud EPM Enterprise Service instance. Before you can import a tutorial snapshot, you must request another Cloud EPM Enterprise Service instance or remove your current application and business process. The tutorial snapshot will not import over your existing application or business process, nor will it automatically replace or restore the application or business process you are currently working with.

Before starting this tutorial, you must:

Note:

If you run into migration errors importing the snapshot, re-run the migration excluding the HSS-Shared Services component, as well as the Security and User Preferences artifacts in the Core component. For more information on uploading and importing snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.

In this section, you open a rollup structure.

  1. On the Planning home page, click Strategic Modeling and then Click Scenario Rollups.
    2. Home Page
  2. Click Vision Corporation.
    3. Model Rollup

Reviewing the Vision Corporation rollup structure

In this section, you review a rollup structure for different business cases.

  1. Each business case can have its rollup structure. Notice, that the acquisition model is excluded, and the scenario for Insight is Recession+Expansion.
    2. Vision Consolidated for Recession
  2. Change the business case to see how that impacts the rollup structure. For Business Case, click Recession and select Expansion.
    3. Vision Corporation Consolidation for Recession
  3. Notice, that the acquisition model is excluded, and the scenario for Insight is Expansion.
    4. Expansion Business Case

Performing Rollups

In this section, you add a business case, and modify a rollup structure.

Adding a business case

In this section, you add a business case and indicate which scenario will contribute data for this business case.

  1. In Business Case, click Expansion, and select Add Business Case.
    2. Add a business case
  2. In Add new Business Case, for New Business Case Name, enter What-If.
    3. Add new business case dialog
  3. For Leaf Node Scenario to contribute, select Base and click Add.
    4. Select Leaf Node

    If you have a business case that you no longer need, you can remove it by clicking Actions menu (Action) at the top of the screen, and selecting Remove Business Case.

    Remove Business Case

Changing a rollup structure

In this section, you modify a rollup structure by removing a model and adding another one.

  1. Click What-If and select Expansion.
    2. Select business case
  2. Select the AsiaPac row. On the upper right, click Actions menu (Action), and select Remove Model.
    3. Remove model
  3. Click Yes.
    4. Warning Dialog
  4. On the upper right, click AddIcon (Add).
    5. Click Add
  5. On the left, expand Vision Consolidated.
    6. Expand Vision Consolidated
  6. On the left, expand Services.
    7. Expand Services
  7. Drag Europe from the left pane to Services in the right pane.
    8. Drag Europe
  8. In the Select Scenario for new Model dialog box, accept the default scenarios of Expected, and click OK.
    9. Select Scenario Dialog

Selecting scenarios for models

In this section, you select scenarios for models. You can rollup data across models using different scenarios for each model. This allows you to blend scenarios across models to calculate values for a rollup scenario.

Business unit models do not require matching structures. Each can have different scenarios that can include different time periods, forecast methods, subaccount structures etc. Some models have the Expansion scenario selected, while others have the Expected scenario selected.

  1. In the Expansion business case, for Facility Upgrade, change the scenario to Delay Capex.
    2. Expansion business case: facility upgrade model
  2. For Europe, click the Method drop-down list.
    3. Method Drop Down

    You can apply financial accounting rules such as the cost or equity method, and account for minority interests, as you perform rollups.

  3. For Europe, leave the method set to Full Scenario Rollup, and click the Method drop-down list to close it.

    4. Tip:

    You can also change the ownership percentage.
    Ownership Percentage
  4. Click Europe to review the assigned financial accounting rules.
    5. Click Europe

    You can select advanced features for your rollup. You can modify properties for Europe. In addition to adjusting the method and ownership percentage, you can also set other model properties such as the start and end periods.

    advanced consolidation features
  5. Click Cancel.
    6. advanced consolidation features with Cancel highlighted
  6. Click Vision Consolidated.
    7. Vision Consolidated Highlighted

    You can modify properties for the rolled scenario.

    Vision Consolidated Attributes
  7. Click Cancel.
    8. Vision Consolidated Attributes Cancel
  8. Before you rollup your scenario, you can choose to exclude some child models from the rollup. Select the Acquisition Target row.
    9. Acquisition Target row
  9. In the upper right, click Actions menu (Action) and select Exclude, and then From all Parent Business Cases.
    10. Exclude From All Parent

Rolling up a business case

In this section, you run a rollup for the baseline business case.

  1. Take a look at the rollup status for our Baseline business case. In Business Case, click Expansion, and select Baseline.
    2. Switch to Baseline

    Each model has an ownership fvstatus of Roll up, Changed, or Ready. Rolled up scenarios display a status of Ready. Scenarios where data has been changed but not yet rolled up, display a Changed status. scenarios with a Roll up status, need to be rolled up. In this case, child models have a Changed status while their parent has a Roll up status.

    Vision Corp Baseline
  2. Select the Services row. In the upper right, click Run, and then Run again.
    3. Run Rollup and Data Maps
  3. In the Run Rollup and Data Maps dialog box, ensure Baseline is selected, and click Run.
    4. Run Rollup and Data Maps Dialog

    When you rollup a parent model, the data from its children is rolled up to the parent. This gives you the overall financial picture of your organization.

  4. Click OK.
    5. Information Dialog
  5. In the upper right, click Actions menu (Action), and select Refresh.
    6. RefreshAfterConsolidate

    After rolling up, the parent’s status changed from rollup to Ready.

    After Consolidation