TARGETTIMESERIESOPT
This Essbase configuration setting globally sets query optimization across transparent partitions for outlines that have a time dimension with Dynamic Time Series members.
If this setting is specified, queries with Dynamic Time Series members will incur faster query times. Use this setting only if the time dimensions on the source and target partitions are identical. If 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 TRUESee Also