Essbase Studio (formerly Essbase Integration Services or EIS) is Oracle’s graphical metadata modelling environment for designing, creating, and maintaining Essbase applications from relational database sources. Where Essbase Administration Services (EAS) provides the interface for directly editing an Essbase outline — adding members, modifying properties, writing calculation scripts — Essbase Studio provides a model-driven design environment where the Essbase application’s dimensions, hierarchies, and data mappings are defined in terms of relational source data structures (tables and views), and the Essbase outline is generated from and maintained in synchronisation with that metadata model. Essbase Studio was introduced as the strategic development environment for Essbase in Oracle Hyperion 11.x and was positioned to replace EAS for new application development; however, EAS continued to be widely used in parallel, and Essbase Studio’s adoption varied significantly across GCC enterprise environments.
Essbase Studio vs Essbase Administration Services
| Dimension | Essbase Studio | Essbase Administration Services (EAS) |
|---|---|---|
| Design approach | Model-driven — dimensions defined from relational source schemas | Direct outline editing — members added and modified in the outline directly |
| Synchronisation | Outline regenerated from model — source changes propagate to Essbase | No source relationship — outline is the single source of truth |
| Use case | Essbase applications where dimension data originates from a relational database | All Essbase applications — the standard administrative tool |
| Availability in EPM Cloud | Not available — cloud uses DI dimension import | Not available — cloud uses Calculation Manager and Planning dimension editor |
| Complexity | Higher — requires relational model design alongside Essbase design | Lower — direct outline manipulation |
Essbase Studio in EPM Cloud Context
Essbase Studio is an on-premise Hyperion tool — it is not available in Oracle EPM Cloud. In EPM Cloud, the equivalent function — defining dimensions from relational source data — is performed through Oracle Data Integration’s dimension import capability or through EPM Automate’s importDimensionMetadata command. Organisations migrating from on-premise Hyperion environments that used Essbase Studio for dimension maintenance must transition to these cloud alternatives, because Essbase Studio cannot connect to Oracle EPM Cloud’s managed Essbase environment. The Essbase Studio metadata model and the dimension definitions it contains serve as documentation for the migration but cannot be directly imported into the cloud environment.
Essbase Studio and Oracle Analytics Cloud
Essbase Studio is also relevant in the context of standalone Oracle Essbase Cloud deployments — where Oracle Analytics Cloud (OAC) includes a cloud-based Essbase service (separate from the EPM Cloud Essbase) that provides a simplified model-driven application design interface. The OAC Essbase Studio interface is a web-based successor to the on-premise Essbase Studio, providing similar model-driven dimension design capability within the Oracle Analytics Cloud environment. This should not be confused with Oracle EPM Cloud’s Essbase — they are separate products on the same Oracle Cloud platform.
What Goes Wrong in Practice
The most common Essbase Studio deployment failure in on-premise GCC environments is an Essbase Studio metadata model that has diverged from the current Essbase outline — because outline changes were made directly in EAS (faster and simpler for individual member changes) without updating the Essbase Studio model. Over time, the Studio model and the live outline diverge to the point where running a Studio deployment (which regenerates the outline from the model) would overwrite the EAS-made changes. When this divergence is large, the Studio model becomes unusable for deployment and serves only as a partial documentation reference. Maintaining Essbase Studio model discipline — all outline changes must be made in Studio, not in EAS — is essential for the model to remain the authoritative dimension source.
How Loop Wise Solutions Handles Essbase Studio
In on-premise Hyperion health check engagements where Essbase Studio is present, we assess the divergence between the Studio model and the live outline as a standard item — identifying whether the model can be used reliably for outline deployment or whether it has diverged to the point of being documentation only. For migration planning, the Studio model provides the relational-to-Essbase mapping documentation that informs the EPM Cloud Data Integration configuration, regardless of whether it can be deployed directly.
