Select items from Multiple Page Fields

M_kumar

New Member
Joined
Oct 5, 2006
Messages
1
I am using Excel2003 and the data Source is OLAP. I have built a pivot table using Analysis Manager Cube.

The cube has 7 Measures and 10 Dimensions with more than 50000 rows. I built the pivot by having four dimensions in the page field , three dimensions in row area and 4 measures in data area. when I select a particular value from page field, the pivot table runs a olap query for 10 Secs and builds the pivot table which is good.

But the problem come when I have to select four items from four page fields for which every time the pivot table runs a query, i.e., totally 40 secs to build a query.

My question: Is there any way to stop building pivot table when I select items from page fields (I tried PT.ManualUpdate but it was not helpful) so that I can insert a push button to refresh the pivottable and my query will be taking only 10 Secs.

Any help regarding this.

Thanks in Advance
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Hi, I don't think you are in luck.

This link... contains the following statement:
An OLAP server returns new data to Excel every time you change the view or layout of the PivotTable or PivotChart report. When you use non-OLAP source data, the data is refreshed differently, and various refresh options are available in the PivotTable Options dialog box.

Denis
 

Forum statistics

Threads
1,141,591
Messages
5,707,277
Members
421,499
Latest member
Dpbj

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top