ACCELERATEASYMMETRICREPORT

This configuration setting can reduce the amount of time it takes Essbase to retrieve data for asymmetric MDX and Smart View queries.

You can enable asymmetric report optimization for federated partition cubes, hybrid mode cubes, and aggregate storage cubes.

Syntax

ACCELERATEASYMMETRICREPORT [appname [dbname]] TRUE|FALSE|ON|OFF

  • appname—Optional. Specifies the application for which the setting applies.

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

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

    If you do not specify an application, you cannot specify a cube, and the setting applies to all applications and cubes on the Essbase instance.

  • dbname—Optional. Specifies the database (cube), in the application specified by appname, for which the setting applies.

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

  • TRUE or ON—Essbase processes queries using an algorithm designed for asymmetric report optimization. This is the default.

  • FALSE or OFF—Essbase does not process queries using the algorithm for asymmetric report optimization.

Description

Enabling asymmetric report optimization can reduce the time it takes Essbase to retrieve data for asymmetric reports and queries, in both Smart View and MDX. The optimization is designed for federated partition cubes, but can also be used for aggregate storage (ASO) and hybrid mode block storage cubes.

For details about what constitutes an asymmetric report, refer to Hierarchy Shapes.

Notes

  • The optimization may cause the memory usage of the application server (ESSSVR) to be significantly larger during retrieval of asymmetric reports.

  • In rare cases, the optimization may cause retrieval of asymmetric reports to process more slowly.

Example

ACCELERATEASYMMETRICREPORT Sample TRUE