1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. SSOPTIMIZEDGRIDPROCESSING

SSOPTIMIZEDGRIDPROCESSING

This Essbase configuration setting specifies whether optimized grid processing, which cuts the input grid into symmetric grids to create fewer symmetric queries, is enabled for grid client operations.

Syntax

SSOPTIMIZEDGRIDPROCESSING [appname [dbname]] TRUE | FALSE

  • appname—Optional. Specifies the application for which optimized grid processing is to be set.

    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 optimized grid processing is to be set.

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

  • TRUE—Enables optimized grid processing for grid client operations.

    The default value is TRUE.

  • FALSE—Disables optimized grid processing for grid client operations.

For changes to the configuration file to take effect, you must restart Essbase Server.

Example

SSOPTIMIZEDGRIDPROCESSING FALSE

Turns off optimized processing for grid client operations on all applications and databases on Essbase Server.