Use TARGETASOOPT to potentially optimize large queries (from Smart View or other grid clients, MDX, or Report Writer) to an aggregate storage database across a transparent partition when the source outline and target outline are identical in the partition region definition area.

Syntax

TARGETASOOPT [appname] TRUE | FALSE

• appname—Optional. Application name. If you specify a value for appname, the setting applies to all databases in the specified application. If you do not specify an application, the setting applies to all applications and databases on the Essbase Server.

• FALSE—The default. Optimization is not enabled, even if queries match the required criteria (see Description).

• TRUE—Optimization is enabled for queries that match the required criteria (see Description).

  When TARGETASOOPT is TRUE, Essbase determines if the partitioned region's outlines are identical on the source and target, and if so, optimizes the query format.

You must restart Essbase Server to initialize any change to the configuration file.

Description

TARGETASOOPT enables an alternate (compact) format for sending a query (from Smart View or other grid clients, MDX, or Report Writer) to an ASO source database. It may speed up large queries between databases that match the following criteria:

• Two Essbase databases are transparently partitioned (for example, to enable write-back for an ASO database)

• The source of the transparent partition is an ASO database

• The partitioned area definitions in the source and target are identical.

• The source and target outlines are identical.

Notes

If at query time the source and target outlines have been modified after the last validation, even if the partition region definition outlines are still identical, TARGETASOOPT is disabled for the query. To enable TARGETASOOPT for the query, you must revalidate the partitions.

Example

TARGETASOOPT TRUE

See Also

TARGETTIMESERIESOPT