1. Using Oracle Essbase
  2. Model Data in Private Scenarios
  3. Enable Scenario Modeling

Enable Scenario Modeling

Enabling scenario modeling as part of the cube creation process is as easy as selecting a check box in the user interface or populating the right fields in an application workbook.

You can create or enable a cube for scenario modeling using one of the following methods:

Data Audit Trail is not supported on scenario-enabled cubes.

Create a Scenario-Enabled Cube

You can create a scenario-enabled cube in the Essbase web interface by selecting the Enable Scenarios check box during the cube creation process.

Scenario-enabled cubes have specialized dimensions required to use scenario management. These include the Sandbox dimension and the CellProperties dimension. CellProperties is considered a hidden dimension in that you do not need to interact with it in any way when performing Essbase tasks such as building cubes, loading data, or calculating cubes.

  1. On the Applications home page, click Create Application.

  2. On the Create Application dialog box, enter an Application Name and a Database Name (cube name).

  3. Ensure that in Database Type, Block Storage (BSO) is selected.

  4. Select Enable Scenarios.

  5. Click OK.

Create a Scenario-Enabled Sample Cube

You can create a scenario-enabled cube by importing the scenario-enabled sample application workbook.

  1. In the Essbase web interface, click Import.
  2. Click Catalog.
  3. Drill down into gallery > Applications > Demo Samples > Block Storage.
  4. Select Sample_Basic_Scenario.xlsx and click Select.
  5. Provide a unique name and click OK.

Enable an Existing Cube for Scenario Management

You can enable an existing cube for scenario management by clicking the Scenarios button in the Essbase web interface and adjusting the number of scenario members you want to create.

If you have the application manager role, you can enable an existing cube to use scenario modeling. It is best to do so on a copy of the original cube. Existing scripts, rules, and queries will work as before, on the base member. If you need to run them on a sandbox member, you can run them from a scenario-launched sheet.

A scenario launched sheet is an Excel sheet launched from a scenario in the web interface. See View and Work With Scenario Data From the Essbase Web Interface .

  1. Enable scenarios
    In the Redwood Interface,
    1. On the Applications page, open the application and then open the database (cube).
    2. On the General page, for Scenarios, click Not Enabled.
    In the Classic Web Interface,
    1. On the Applications page, expand the application.
    2. Click the Actions menu to the right of the cube name and select Inspect.
    3. On the General tab, for Scenarios, click Not Enabled.
  2. Adjust the number of scenarios members (non-base sandbox members) you want to create and click Ok.

Create Additional Sandbox Members

By default, a new scenario-enabled cube has 100 sandbox members. You can create additional sandbox members (up to 1000).

  1. Navigate to the General page.
    • In the Redwood Interface, on the Applications page, open the application and then open the database (cube).
    • In the Classic Web Interface,
      1. On the Applications page, expand the application.
      2. Click the Actions menu to the right of the cube name, and select Inspect.
  2. On the General page, click the plus sign next to Scenarios.
  3. Enter the number of sandbox members you want to create.
  4. Click OK.