I am planning to use Excel 12 on client for AS 2005 OLAP database. I tried
google to find how Excel 12 has improved Client side CPU utilization using
Pivot table reading cube data didn't find any. If you know any source that
will be big help.

Thank you - Ashok

In article <9A73530D-E682-4939-862F-FC7FBDD7401C (AT) microsoft (DOT) com>,
Ashok (AT) discussions (DOT) microsoft.com says...
There probably are some only sources regarding this, I just don't know
of any off the top of my head.

But what I can tell you is that In AS2k the OLEDB provider used Pivot
Table Services which did a lot of caching and calculation on the client
side, which potentially made AS2k more scaleable, but often transferred
too much load to the client, leaving the server doing very little while
the client was running at 100% CPU utilization.

In AS2k5 this has all changed, the OLEDB provider is little more than a
thin wrapper that sends XMLA requests to the server and receives back a
response with the results from the server. You might have noticed that
it is a pre-requisite for installing the OLEDB provider for Analysis
Services 9.0 that you have MSXML 6.0 installed. All the caching and
calculation now happens on the server. Which also means that there is a
lot more potential to share the caching between clients.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell