1. Administering Sales Planning
  2. Setting Up Your Application
  3. 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.

Beginning with Release 21.04, Sales 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 21.04, or if you create a new application using a release provisioned prior to Release 21.04, you can enable Hybrid mode to support Essbase hybrid block storage option (BSO) cubes if it's not already enabled.

Note:

Key Account Planning requires Hybrid Mode to be enabled.

Prerequisite: In Quota Planning, for any sparse dimension parent set to Dynamic Calc, change the setting to Store.

To enable Hybrid cubes for existing applications:

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

Hybrid mode notes:

  • 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.

    See Recreate for information on upgrading Essbase.

  • You'll see a validation error message when you enable Hybrid if a sparse dimension parent in Quota Planning is set to Dynamic Calc.
  • After you enable Hybrid mode, you can't make a sparse dimension parent Dynamic Calc in Quota Planning.

For more information, see:

  • 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 Sales 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.