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:

  • 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 Cloud EPM in Getting Started Guide for Administrators.

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.