Business and Essbase Users FAQ
- What is the FreeForm Business Process, and what can you do with it?
- What are the advantages of using the FreeForm Business Process in Cloud EPM?
- Are Cloud EPM IPM and GenAI Reporting features available with the FreeForm Business Process?
- If we are Essbase customers, why move to the FreeForm Business Process?
- Should Excel-focused users move to the FreeForm Business Process?
- What is the learning curve for Essbase users with Smart View moving to FreeForm Apps?
- What browser-based benefits does FreeForm provide for Essbase customers?
- Why use FreeForm as your corporate reporting solution?
- What is the difference between Essbase and FreeForm in Cloud EPM?
- Are all FreeForm applications custom built?
- Can you create custom dimensions and rules?
- What admin interfaces are available?
- Can I use Narrative Reporting with the FreeForm Business Process?
- Is direct Smart View and Oracle Analytics access supported?
- Do FreeForm applications offer extended dimensionality?
- Do FreeForm applications offer relational blending?
- Is Task Manager available as it is in Financial Consolidation and Close?
- Can FreeForm be used to back up on-premises Hyperion Financial Management (HFM) applications?
- Where can administrators find additional FAQs?
What is the FreeForm Business Process, and what can you do with it?
Use FreeForm to build custom reporting, analysis, and planning models or adapt existing Oracle Essbase and spreadsheet models to Oracle Fusion Cloud Enterprise Performance Management. An application supports up to 12 cubes and 29 dimensions, including up to 26 custom dimensions.
Learn more: Understanding FreeForm.
What are the advantages of using the FreeForm Business Process in Cloud EPM?
Oracle operates the SaaS infrastructure. Teams can centralize models, permissions, browser forms, dashboards, reports, and Excel access, with managed service updates. The model and integration design still determine data freshness and performance.
Are Cloud EPM IPM and GenAI Reporting features available with the FreeForm Business Process?
Yes, all IPM features are currently available.
If we are Essbase customers, why move to the FreeForm Business Process?
Consider FreeForm when you want Oracle-managed infrastructure plus Cloud EPM forms, dashboards, security, and reporting around your models. Assess migration compatibility first; moving to SaaS does not automatically eliminate data movement or latency.
Should Excel-focused users move to the FreeForm Business Process?
Consider FreeForm when spreadsheet models need centralized data, shared permissions, and repeatable reporting. Users can work through supported Oracle Smart View for Office clients, including Smart View for Office and Smart View for Mac and Browser.
What is the learning curve for Essbase users with Smart View moving to FreeForm Apps?
Existing ad hoc analysis skills are useful, but users must learn the Cloud EPM connection, permissions, forms, and data submission behavior. Administrators should test representative workbooks before rollout.
What browser-based benefits does FreeForm provide for Essbase customers?
Teams can use browser forms, dashboards, and reporting alongside Smart View. Administrators can manage the application through the Cloud EPM interface. Plan user access and reporting workflows as part of the implementation.
Why use FreeForm as your corporate reporting solution?
FreeForm can host a reporting model with dimensions and access permissions designed for enterprise analysis. Establish integration, reconciliation, and refresh processes so the reporting model remains consistent with source systems.
What is the difference between Essbase and FreeForm in Cloud EPM?
FreeForm packages multidimensional models within a managed Cloud EPM business process. Essbase deployments provide a different administration and tooling model. Evaluate supported Cloud EPM interfaces and migration restrictions rather than assuming every Essbase server feature carries over.
Are all FreeForm applications custom built?
Yes. You define the model for your use case, subject to FreeForm limits and supported functionality. You can start from a wizard, a supported Essbase source, or a Smart View application template.
Can you create custom dimensions and rules?
Yes. Define custom dimensionality and implement business logic with supported business rules and Groovy. Cube type determines which calculation methods are appropriate.
What admin interfaces are available?
Use the Cloud EPM web interface, Calculation Manager for rules, and supported Smart View administration capabilities. Smart View application templates can define cubes, dimensions, security, substitution variables, and a limited amount of data.
Can I use Narrative Reporting with the FreeForm Business Process?
Yes. FreeForm has embedded Reports capabilities, and Narrative Reporting can be used for broader reporting workflows. Embedded Reports and the separate Narrative Reporting business process have different feature scopes; for example, Notes summarization is not supported in Reports.
Is direct Smart View and Oracle Analytics access supported?
Smart View access is supported. For Oracle Analytics, validate the connector, deployment, authentication, and supported operations for the intended connection. Consult the connector documentation for the specific Oracle Analytics product and connection mode.
Do FreeForm applications offer extended dimensionality?
Cubes may share dimensions or use their own dimensionality within the application limits. This flexibility does not mean unlimited dimensions or independent member namespaces for each cube.
Do FreeForm applications offer relational blending?
The EPM Integration Agent supports loading from Autonomous Database staging and exporting Cloud EPM data to Autonomous Database reporting warehouses. Design drill-through and analytics blending as explicit integration workflows.
Is Task Manager available as it is in Financial Consolidation and Close?
Yes. Current FreeForm documentation includes Task Manager for coordinating tasks, templates, and schedules. Enable and configure it for your process. Task coordination is separate from the Planning approval-unit workflow.
Can FreeForm be used to back up on-premises Hyperion Financial Management (HFM) applications?
FreeForm can be designed to hold a reporting copy of extracted HFM data. Define the target dimensions and validate the integration and reconciliation process. A reporting copy does not restore the HFM application, consolidation configuration, or application artifacts; retain a supported HFM backup process.
Where can administrators find additional FAQs?
Be sure to use the current topic links rather than obsolete FAQ cross-references. Consult these resources: