1. Administering and Working with Strategic Workforce Planning
  2. Administering Strategic Workforce Planning
  3. Setting Up Your Application
  4. Creating an Application
  5. Enabling Essbase Hybrid Block Storage Option (BSO) Cubes

Enabling Essbase Hybrid Block Storage Option (BSO) Cubes

Hybrid BSO cubes support some Aggregate Storage Option (ASO) capabilities in addition to BSO capabilities. Hybrid cubes provide many benefits including smaller database and application size, better cube refresh performance, faster import and export of data, improved performance of business rules, and faster daily maintenance of the business process. To ensure optimal performance, warnings and error messages are displayed during cube refresh if the business process does not conform to best practices.

Beginning with Release 22.04, Strategic Workforce Planning supports Essbase Hybrid Block Storage Option (BSO) cubes. Any new applications you create are automatically created with Hybrid mode enabled.

If you created your application prior to Release 22.04, or if you create a new application using a release provisioned prior to Release 22.04, you can enable Hybrid mode to support Essbase hybrid block storage option (BSO) cubes if it's not already enabled.

To enable Hybrid cubes for existing applications:

  1. From the Home page, select Application and then Overview.
  2. From Actions, select Enable Hybrid Mode.

If your subscription is not deployed to use Hybrid-enabled Essbase, you won't see the Enable Hybrid Mode option. You must first upgrade Essbase and then enable Hybrid mode. Upgrading the Essbase version is a self-service operation using the recreate EPM Automate command.

Note:

Once you change the Essbase version, you can’t go back to a different version.

For more information:

  • About Essbase in EPM Cloud in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

  • recreate in Working with EPM Automate for Oracle Enterprise Performance Management Cloud

Note:

Because Strategic Workforce Planning supports Hybrid cubes, when Hybrid Mode is enabled, you can set up predictions to run automatically with Auto Predict. For more information, see Setting Up Predictions to Run Automatically with Auto Predict. You can also use IPM Insights to analyze past data and predicted data to help you find patterns and insights into data that you might not have found on your own. See About IPM Insights in Administering Planning.