Creating an Application Using a Wizard

Use this procedure to create Free Form applications based on your own models using custom dimensions. During tis process, you can map the custom dimensions that you want to use as Entity, Period, and Account dimensions. You can also add other custom dimensions to support your model.

Important Considerations

Do not use these reserved words to name dimensions and members in your application:

Table 1-3 Reserved words that should not be used as member names

Reserved words
BU Version_1 Users Attribute Dimensions HSP_Entity
ConsolidatedData Groups Default HSP_Period
BaseData Calendars Task Lists HSP_Version
SandBoxData Currencies Menus HSP_XCRNCY
Super User Predefined CalcMgrRules HSP_Years
Strategic Planner FX_Tables CalcMgrRulesets HSP_View
Service Administrator Forms CalcMgrVariables HSP_Metric
CalcMgrTemplates Aliases HSP_Rates  
Root Cubes HSP_Scenario  
Dimensions Planning Units HSP_Account  
Your Goal Learn How
Create Free Form applications with a Hybrid BSO cube Video icon Create Free Form applications with a Hybrid BSO cube.
Create Free Form applications with an ASO or reporting cube Video icon Create Free Form applications with a reporting or ASO cube.

To create an application using a wizard:

  1. On the EPM Enterprise Cloud Service landing page, click SELECT under Planing.
  2. On the Planning landing page, click START under Create a new application.
  3. Enter a Name and Description for the application.
  4. From Application Type, select Free Form.
  5. From Application Setup, select an option:
    • Planning (BSO/Hybrid cube) to create a Free Form application that uses Hybrid BSO cube.
    • Reporting (ASO cube) to create a Free Form reporting application that uses an ASO cube.

      Reporting applications that using ASO cubes, generally, store data in aggregate views and can handle a higher number of dimensions than BSO without adversely affecting performance.

  6. In Cube Name enter a name for the cube, maximum eight characters.
    Free Form Application General Settings Screen
  7. Click Next.
    Create Dimensions screen is displayed. From this screen, you can create up to three dimensions and assign one each to Account, Entity, and Period default dimension types. Additional dimensions you want to add to the application can be added later using the Classic Dimension Editor.


    Free Form applications do not require standard dimensions. You can create an application with only custom dimensions containing members of your choice. The dimensions you create and its structure are not governed by the constraints imposed on standard Planning application dimensions.
  8. In Create Dimensions, create and map default application dimensions. Complete a step:
    Free Form Application Dimension Mapping Screen
    • To create dimensions and map them to default dimension types, select the Enabled check box and then type in dimension names.
    • To create a dimension and assign a dimension type, select the check box in a row and then type in a dimension name.
    • To create a shell application, do not change anything in this screen.

      You can add and map dimensions to shell applications from the Classic Dimension Editor after the application creation process is complete. Alternatively, you can import a snapshot from a Free Form application into a shell application using Migration.

  9. Click Next.
  10. In Review, verify the settings that you selected and then click Create.
    The application creation process may take a few minutes.
  11. In Application Creation Status screen, click OK.
    The Planning Home page is displayed.
  12. Optional: Create custom dimensions, if needed.
    1. Click Navigator (Navigator) and select Dimensions under Create and Manage.
    2. In Cube, select the cube that you created for your Free Form application.
    3. Click Add Dimension (Add Dimension)
    4. Complete this step for each dimension you want to add to the application:
      1. In Dimension, enter a name for the dimension.
      2. In Dimension Type, select the default dimension type that you want to associate with this dimension. While you can add only one dimension of a specific default type to a Free Form application, you can add many dimensions of type Custom to an application.

        It is not mandatory for Free Form applications to contain default dimension types; you can create an application containing only custom dimensions.

      3. Select Valid for Cube to indicate that the dimension is to be used in this cube.
      4. Select other settings as needed.
        Add Dimension Screen
      5. Click Save.
      6. Click OK in the confirmation screen.
      7. In Dimension, select the name of the dimension you added.
      8. Add dimension members as needed.
    5. Click Action and then Refresh Database to refresh the cube.
  13. Optional: Import application data. See Importing Data in Administering Planning
  14. Optional: If you created a shell application with a view to import a snapshot, access Migration, then delete the application, and then complete the import process.
    1. Upload a snapshot from a Free Form application to your environment. See Uploading Archives to the Service in Administering Migration for Oracle Enterprise Performance Management Cloud for detailed instructions.
    2. Import the snapshot. See "Importing a Backup to Create a Clone of Another Environment" in Importing Artifacts and Application from a Snapshot in Administering Migration for Oracle Enterprise Performance Management Cloud for detailed instructions.
  15. Create application users in identity domain and assign predefined roles as needed. See Manage Users and Roles in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.
  16. Set up access permissions as needed. See Setting Up Access Permissions in Administering Planning.