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.
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:
|
You must restart Analytic Server to initialize any change to the configuration file.
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:
TARGETASOOPT TRUE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |