1. Administering Planning
  2. Creating a FreeForm App
  3. Understanding FreeForm

Understanding FreeForm

FreeForm enables you to create an application with the cubes and dimensions of your choice without being constrained by the cube and dimension limitations imposed by standard applications. With FreeForm, you can model and build your own cubes while preserving the ability to leverage business process functionalities.

FreeForm can be accessed using Oracle Smart View for Office or Oracle Enterprise Performance Management Cloud screens; they support Groovy scripts for custom functions, and business rules for calculations.

You can create applications with multiple cubes or you can create an application with a single cube and then add more cubes later (up to 12 cubes total).

Note:

The following features are not available in FreeForm because these features require the provided Scenario, Version, Period, and Year dimensions to be present:

  • Predictive Planning

  • Auto-Predict

  • IPM Insights

In FreeForm, the Scenario, Version, Period, and Year dimensions can be defined as custom dimensions.

In addition, the following features are not available in FreeForm:

  • Sandboxes
  • Approvals
  • Task Manager

About Multi-Cube FreeForm Apps

  • The maximum number of custom dimensions allowed in a FreeForm app is 26.

  • Cubes can share dimensions or have standalone dimensionality.

  • All dimensions can be custom; or native account, period, and/or entity dimensions can be inherited by the cubes.

  • Cross-cube data maps, Smart Push, and Copy Data support are available for FreeForm app types.

Multi-cube FreeForm apps are constrained by these existing business process assumptions:

  • Members must be unique across all the cubes within FreeForm.

  • Governors are applicable at the application level and not at the cube level.

  • The input outlines must not be enabled to allow duplicate member names.

Videos

Your Goal Learn How

Get an introduction to FreeForm.

Video iconIntroduction to FreeForm Apps in Cloud EPM

Create FreeForm apps from on-premises Oracle Essbase outline (OTL) files and snapshots.

Video iconCreating FreeForm applications from on-premises Essbase outline files and snapshots

Create multi-cube FreeForm apps with an Essbase outline

Video iconCreating Multi-Cube FreeForm Apps from Essbase Outlines

Create FreeForm apps with a Hybrid BSO cube

Video icon Creating FreeForm Applications with a Hybrid BSO Cube

Create FreeForm apps with an ASO or reporting cube

Video icon Creating FreeForm Applications with a Reporting/ASO Cube

Create multi-cube FreeForm apps with a BSO or ASO cube

Video iconCreating Multi-Cube FreeForm Apps from BSO and ASO Cubes

Learn how to create FreeForm apps using an Excel template. Using the Excel template, you learn how to define application properties, manage cubes, create dimensions and members, attributes, access permissions, and load data into the FreeForm application.

Video iconCreating Multi-Cube FreeForm Applications with an Excel Template - Part 1

Learn how to update FreeForm apps using an Excel template and verifying changes in the web interface. After creating your FreeForm application using an Excel template, learn how you can use the same template to make modifications to dimensions, members, substitution variables, and security. Then, in the Planning web interface, assign Application Management options, review the application properties and definition, and the data you imported.

Video iconCreating Multi-Cube FreeForm Applications with an Excel Template - Part 2