TARGETTIMESERIESOPT

The TARGETTIMESERIESOPT configuration setting enables you to optimize queries across transparent partitions for Essbase outlines that have a time dimension with Dynamic Time Series members. Use TARGETTIMESERIESOPT only if the time dimensions on the source and target partitions are identical.

If TARGETTIMESERIESOPT is enabled, queries with Dynamic Time Series members will be faster. However, the time dimensions on the source and target partitions are not the same, this setting may produce incorrect results. Restart Essbase to enable this setting to take effect for the Dynamic Time Series members that have been enabled at run time.

Syntax

TARGETTIMESERIESOPT TRUE | FALSE

TRUE—Enables query optimization across transparent partitions for outlines that have a time dimension with Dynamic Time Series members.
FALSE—Query optimization is not enabled. This is the default.

Example

TARGETTIMESERIESOPT TRUE