QUERYTRACETHRESHOLD

The QUERYTRACETHRESHOLD configuration setting enables you to set the maximum number of cells (or tuples) that a QUERYTRACE query will log for an Essbase MDX query or other grid client query. Use this setting to limit the number of cells printed for each formula or aggregation number.

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.

Notes

QUERYTRACETHRESHOLD configuration applies only to block storage (BSO) databases, including those in hybrid mode. It does not apply to aggregate storage (ASO) databases.

Example

QUERYTHRESHOLD 50

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