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.
See Also