TARGETASOOPT

Potentially optimizes large queries (from the Spreadsheet Add-in, 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 An 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 Analytic 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, Analytic Services completes the following steps:

  1. When the partition is next validated, automatically determines if the partition region definition outlines are identical on the source and target databases
  2. If the partition region definition outlines are identical, the query is sent in the compact format from the target database to the source database.

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

Description

TargetASOOpt enables an alternate (compact) format for sending a query (from the Spreadsheet Add-in, MDX, or Report Writer) to an aggregate storage source database, and hence may speed up large queries between databases that match the following cireteria:

Notes

Example

TARGETASOOPT TRUE

See Also

TARGETTIMESERIESOPT

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com