How to Cache Pivot Table Data?

T

Thomas

Hello,

Im using the Office Web Components Pivot Tables.
As Data Source I use a SQL Database, but the problem is when you scroll it
takes
a long time and the data is collected everytime from the database again.
If I use a OLAP as source it is much faster..
Is there any possibility to load the whole pivot Table in the clients cache
at the start ?

Grtz,
Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing pivot table ADO recordset 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Consolidate Pivot Tables/Cache using Excel 2003 1
Pivot Table Authentication Problem 0
pivot table loosing decimals (vba) 1
Excel 2007 pivot table using analysis services cube as data source 0
How can I change the source data reference to another pivot table? 2

Top