Important Considerations for FreeForm Apps


Do not attempt to create FreeForm apps by importing Oracle Essbase Migration snapshots into an Oracle Enterprise Performance Management Cloud environment. Importing snapshots using Migration is supported only for snapshots created from a previous FreeForm app.

  • Data maps and other multi-cube features are unavailable if you create a single cube FreeForm app using the application creation wizard.

  • Essbase snapshots with Custom Defined Functions (CDF) and CDF references cannot be used to create FreeForm apps.

  • Make sure that the OTL file or Essbase application snapshot that you are using does not contain objects with system restricted names; for example, a member named FY02 in the Year dimension. You must rename or remove such restricted names before generating the OTL file or snapshot that you plan to use to create the application. See Naming Restrictions.

  • Ensure that the OTL file or Essbase application snapshot that you are using does not have member and alias names that are longer than 80 characters. If member and alias names are longer than 80 characters, you must remove or shorten them or the import will not be successful. See Naming Restrictions.

  • If the OTL file that you are using contains Year Total and Beginning Balance members, the Beginning Balance member must be the first child under the Period dimension, and Year Total must be the second child under Period dimension. These members require special handling and can be moved to appropriate positions by modifying the .csv files in the Migration snapshot before restoring the snapshot.

  • If you plan to use an OTL file or snapshot stored in your EPM Cloud environment as the source, upload the file before starting the application creation process.

    Use the uploadFile EPM Automate Utility command or Migration to upload the OTL file or snapshot to an EPM Cloud environment.

  • Imported data may not be editable in FreeForm apps. At times, the data is set as Read-only.

  • Member outline must be unique in the application.

  • If you create a FreeForm app by importing an OTL or snapshot, you can add or create new cubes for this FreeForm app at a later time.

  • If you create a FreeForm app by adding new cubes in the application creation wizard, an Essbase cube OTL or Essbase application snapshot cannot be imported into this FreeForm app at a later time to create new cubes.

Do not use the following reserved words to name dimensions and members in FreeForm:

Table 2-2 Reserved words that should not be used as member names in FreeForm

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