|
Home > Archive > MS SQL Server OLAP > November 2005 > Pivot Table service
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Pivot Table service
|
|
| Jon Capel 2005-11-21, 3:23 am |
| 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
| |
| Akshai Mirchandani [MS] 2005-11-23, 8:24 pm |
| 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@discussions.microsoft.com> wrote in message
news:C0B039D3-ECD8-4D05-9190- 59F50B97FFC0@microso
ft.com...
>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
|
|
|
|
|