Controls whether block storage databases use hybrid aggregation mode. Hybrid aggregation for block storage databases means that wherever possible, block storage data calculation executes with efficiency similar to that of aggregate storage databases.
This setting applies only to block storage databases.
ASODYNAMICAGGINBSO [appname [dbname]] NONE | PARTIAL | FULL
appname—Optional. Specifies the application for which hybrid aggregation mode is used.
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.
If you do not specify an application, you cannot specify a database, and the setting applies to all applications and databases on Essbase Server.
dbname—Optional. Specifies the database, in the application specified by appname, for which hybrid aggregation mode is used.
If you specify a value for dbname but do not specify a value for appname, your specification is ignored.
NONE—Disable hybrid aggregation in block storage databases. This is the default.
PARTIAL—Turn on hybrid aggregation 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 aggregation for simple aggregations and formula calculations. If enabled, hybrid aggregation 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.
ASODYNAMICAGGINBSO Sample PARTIAL
“Using Hybrid Aggregation” in the Oracle Essbase Database Administrator's Guide