In an application, you must configure at least one plan type. An Essbase database is created for each plan type. You can have up to three plan types for Planning applications, and two for separate modules. You cannot change the name or number of plan types after creating an application.
As you create accounts, entities, and other elements of the application, you associate them with plan types, so the database for each plan type contains only application dimensions, members, and data values relevant to the plan type. This optimizes application design, size, and performance.
The number of plan types depends on the needs of your organization. For example, if the sales department has a yearly revenue plan, and the finance department has a P&L plan, you can define two plan types, Revenue and P&L.
Data can be shared between plan types. For example, the Revenue plan may include several sales detail accounts that roll up into a Total Product Sales account. You can configure the P&L plan to include the Total Product Sales account. This configuration enables you to bring the data value for Total Product Sales into the P&L plan, without account details. Thus, the database for your P&L plan is smaller and more efficient.
Plan type names can have up to eight characters. You can enter more than eight bytes, including single-byte and double-byte characters, but an error message displays when the Essbase database is created. If Essbase is installed on a UNIX server, the plan type name cannot contain underscore characters.
For information on Public Sector Planning and Budgeting, see the Oracle Hyperion Public Sector Planning and Budgeting User’s Guide.
For information on Oracle Project Financial Planning, see the Oracle Project Financial Planning User's Guide.
To define plan types, perform one of these actions:
If you are using the application wizard, select the plan types and enter the plan type names.
For the General application type, you can have up to three generic plan types, a Workforce plan type, and a Capital Asset plan type.
For the Public Sector Planning and Budgeting application type, you can have up to three generic plan types and a Human Capital planning plan type. The Human Capital Planning plan type is selected by default and cannot be removed. Select the level of budget detail:
Employee: includes employee data only
Position: includes position data only
Position and Employee: includes both position and employee data
For the Project Financial Planning application type, you can have up to three generic plan types. Additionally, you can select whether or not to create an Industry Sample application:
None: Select this option if you are creating a basic Project Financial Planning application, and you do not want to create a sample application.
Information Technology: Select this option if you are creating an information technology (IT) industry-specific Project Financial Planning application, and you want to create a sample application. The sample application contains projects, employees, assets, and other metadata and data specific to the IT industry.
|
Note: |
If you select None, you need to define the calendar range. If you select Information Technology from the Industry Sample drop-down, the values for Default Currency, Use Multiple Currencies, Base time Period, Fiscal Year Start Month, Number of Fiscal Years, and all of the other calendar related properties are set automatically and cannot be changed. |
If you are creating the application manually, double-click the Plan 1 Name property and enter the name of the plan type. Repeat the process for additional plan types.