-
Results Cache is 1 if the results cache was used or is 0 otherwise.
-
Query Tasks counts the number of tasks into which this query was divided.
-
Computations indicates how much time was spent performing intermediate computations such as aggregating a measure according to its aggregation option. It does not include evaluating MDX expressions.
-
Cache Hits counts the number of times an intermediate cache was used.
-
Cells counts all the cells of the result set as well as any intermediate cells that were computed.
-
Slices counts the number of cube slices in the query. This count indicates the number of items on the WHERE clause.
-
Expressions indicates how much time was spent evaluating MDX expressions.
When the cache is used, Computations, Cache Hits, Cells, and Expressions are all zero.
-
Prepare, Execute Axes, Execute Cells, and Consolidate indicate how long different parts of the query processing took place. These parts are listed in order.
-
Total Time is the sum of those parts.
When the cache is used, Execute Cells and Consolidate are both zero, because those parts of the processing are not performed.