I have a general question about the Pivot Table service running on a client
machine. This is the situation. A MDX query runs on a client machine,
requests and retreves leaf level data (aggregations don't exist) from an
Analysis Services cube. The pivot table service performs the aggreation
calculation and outputs a total. My question is this : does the pivot table
service cache this aggregated data it has calculated itself as well as the
leaf level data, or does it cache just the leaf level data.

Many thanks

There is a calculation cache in PTS for AS 2000. Not all results will go in
there (or stay there), but generally yes -- results of calculations could be
in this cache.

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jon Capel" <Jon Capel (AT) discussions (DOT) microsoft.com> wrote