Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Olap Pivot Tables: Multiple calls to AddPageItem and performance
Hello,
I'm using PivotField.AddPageItem to add filter items programatically to an Excel Pivot table which is connected to an OLAP Cube. In excel, the end user can add multiple filters in a dialog field easily by selecting all of them at once in the interactive filter dialog. However, if I try the same by calling AddPageItem multiple times, the system becomes very slow because it queries the OLAP cube after every call to AddPageItem. I could not find a way to suppress these queries or to add multiple filter items at once. Does anyone have a solution to this problem? Thanks very much Urs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
Annualizing Monthly Performance - pivot tables? other formulas? | Excel Discussion (Misc queries) | |||
several Offline-OLAP pivot tables on different sheets | New Users to Excel | |||
How do I refresh 2 pivot tables from same OLAP cube | Excel Discussion (Misc queries) | |||
select multiple items in olap pivot table | Excel Programming |