In addition to the properties described in the table, Scenario dimension members use most of the common properties described in Properties Applicable to All Planning Dimensions, such as:

  • Valid for Plan

  • Aggregation

  • UDA

  • Member Formula

  • Alias

  • Data Storage

  • Smart List

  • Data Type

You can create Scenario dimensions to group data. Each Scenario contains data for accounts and other dimensions of each entity. After users enter Entity and Version data, they can submit or promote the data to other users for review and approval. The intersection of Entity, Scenario, and Version is called a planning unit. Planning tracks planning unit status through the review process. Scenarios can cover different time spans. The Scenario dimension requires an association with Period and Year dimensions to enter start and end time period values.

Use scenarios to:

  • Apply different planning methods.

  • Create forecasts and budgets.

  • Store historical actuals.

Property Label


Property Name

Enable Process Management

Whether the Scenario is enabled for process management. This allows managing a planning unit that contains this member.

Default Value: True


Start Year, End Year, Start Period, End Period

A range of years and time periods for which the Scenario is valid. When users access data forms, they can enter into that scenario only years and periods within the range. You can modify the time range of scenarios.

Default Value: N/A

StartYear, EndYear, StartPeriod, EndPeriod

Use Beginning Balance

Whether to use the BegBalance time period.

Default Value: N/A


Exchange Rate Table

Only for multi-currency applications. Assign an exchange rate table to the scenario.

Default Value: N/A


You can specify access permissions for Scenario members to determine whether groups or users can view or modify data. For information about setting access permissions for Planning, see the Oracle Hyperion Planning Administrator's Guide.

When you delete a Scenario, all planning units that use the Scenario (including data) are deleted. You cannot delete a Scenario that is used in a planning unit that is started or assigned to an axis (row or column) on a data form. You must first remove references to the Scenario from data forms and assign a different Scenario.