New Essbase Platform Feature
Essbase 21.4 brings feature enhancements pertaining to security, migration, aggregate storage cubes, drill through, and REST API
Security and Migration
-
Security auditing allows Essbase administrators to monitor and track information about critical events taking place on the Essbase server. The auditing policy file enables customized control over which details to track.
-
Migrating applications is streamlined. Using LCM Export, you can back up all applications on the instance to a single zip file, including server artifacts. For more precise control, you can opt to export individual cube artifacts
Aggregate Storage
-
For managers of aggregate storage applications, Cube Designer utilities help you optimize cubes based on aggregate storage metrics. A baseline utility helps you compare iterations of cube modifications in terms of data loads, aggregation, and queries. A solve order utility helps diagnose query performance problems relating to formulas.
-
You can clear multiple physical regions of data from aggregate storage cubes in one MaxL alter database statement by providing a comma-separated list of MDX set expressions to clear
Drill Through Improvements
-
When creating drill through reports in the Essbase web interface, a graphical Drillable Region Selector helps you define the drillable regions, so you do not have to brush up on calculator syntax to define the regions.
-
You can run drill through reports using REST API, with the added “Execute Drill Through Report” operation
Other Platform Improvements
-
File uploads are improved in the Essbase web interface. For REST API developers, multi-part file upload enables parallelization of file uploads into threads, reducing the need to restart large uploads after network failures.
-
Although user role provisioning is mostly done in EPM Shared Services or your chosen external provider, the MaxL statements drop user, drop group, and display privilege are available again for limited use cases. When user authentication is managed either through EPM Shared Services or an external LDAP identity provider, you can use the drop user and drop group statements if you need to clean up inactive groups from Essbase after they have been removed or renamed on the external provider. display privilege can be used to view system privileges.
-
Essbase REST API documentation is infused with more examples to help developers, especially in the endpoints related to connections, Datasources, rules, streaming data load and dimension build, grid, and outline
Essbase Deployment Improvements
Essbase 21.4 deployment provides more options to get Essbase up and running
Stack Deployment on Oracle Cloud Infrastructure
For customers who deploy Essbase as a stack on OCI via the Marketplace listing:
-
Essbase on Oracle Cloud Marketplace is now available for U.S. government customers, empowering agencies to automate deployment of certified solutions directly on Oracle Cloud Infrastructure (OCI).
-
You can patch or upgrade existing Essbase OCI deployments to the latest version without having to run the manual patches or deploy new stack images that require migrating of applications.
-
You can deploy Essbase with Autonomous Database using a private IP to secure the metadata repository.
-
You can deploy the Essbase file catalog to use OCI object storage
Independent deployments
For customers who manage an independent Essbase deployment:
-
When secure mode is deployed, the TLS certificate update tool simplifies and enhances the process to update TLS certificates, add external certificates, and replace self-signed certificates with CA certificates.
-
When multiple Essbase instances are deployed, you can access all available server nodes in the connection panel using a single sign-on to one centralized Smart View URL. Additionally, for Essbase instances using EPM Shared Services as the identity provider, you can customize the cluster name used to register Essbase with Shared Services.
