QUERYTRACETHRESHOLD

This Essbase configuration setting specifies the maximum number of cells than can be displayed for each formula or aggregation number for query tracing for calculation order analysis.

Description

This setting specifies the maximum number of cells (or tuples) that a QUERYTRACE query will display for an MDX query or grid client query. Use this setting to limit the number of cells printed for each formula or aggregation number.

Notes

This setting applies to block storage and hybrid mode databases.

Syntax

QUERYTRACETHRESHOLD n

Where n is an integer value between 0 and unlimited, specifying the maximum number of cells to display for each formula calculation path. The default value is 100.

Example

QUERYTHRESHOLD 50

Sets 50 as the maximum number of cells to be displayed for a query tracing the solve order or calculation order.