ASODYNAMICAGGINBSO

This Essbase configuration setting controls whether block storage databases use hybrid mode for queries. Hybrid mode for block storage databases means that wherever possible, block storage queries execute with efficiency similar to that of aggregate storage databases.

Hybrid mode is enabled by default for queries (this configuration setting is implicitly set to FULL). To enable hybrid mode for batch calculations, you must enable HYBRIDBSOINCALCSCRIPT in the application configuration.

This setting applies only to block storage databases.

Syntax

ASODYNAMICAGGINBSO [appname [dbname]] NONE | PARTIAL | FULL | ONLY
  • appname—Optional. Specifies the application for which hybrid query mode is used in aggregations.

    If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application.

    To enable the setting for a specific database, you must specify an application and database.

  • dbname—Optional. Specifies the database, in the application specified by appname, for which hybrid mode is used in aggregations.

    If you specify a value for dbname but do not specify a value for appname, your specification is ignored.

  • NONE—Disable hybrid mode in block storage databases. This is the default.

  • PARTIAL—Turn on hybrid mode only for simple outline aggregations based on the consolidation operators +, -, and ~, but excluding the operators *, /, and %. Leave formulas to be calculated in block storage mode.

  • FULL—Turn on hybrid mode for simple aggregations and formula calculations. If enabled, hybrid mode is in effect for member formulas using any of the supported functions. For a list of supported and unsupported functions, see Functions Supported in Hybrid Aggregation Mode.

  • ONLY—Same as FULL, but if a query is not supported in hybrid mode, return an error instead of defaulting to block storage execution. This can be useful for testing purposes while you are migrating a database from block storage execution to hybrid mode.

Example

ASODYNAMICAGGINBSO Sample PARTIAL

See Also

Adopt Hybrid Mode for Fast Analytic Processing.

MaxL statements alter application set cache_size and query application get cache_size, for managing the size of block-storage application cache.