Olap Pivot Tables: Multiple calls to AddPageItem and performance

U

urs.eichmann

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
 

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

FRom Pivot table select multiple items under report filter 0
PivotTable and OLAP: how to reach attribute properties? 0
pivot table report 0
pivot table report 0
Alternatives to MS Query for Pivot Tables & Cubes 0
Pivot table from olap cube Warning and datasource 0
suppress warning and locate cube in a pivot table from olap cube 0
pivot table rolling 12 month filter? 1

Top