| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
OLAP Pivot Table problem
When an Excel 2003 or 2007 pivot table accesses Analysis Services cube,
sometimes instead of eliminating empty rows on the server, it downloads all the permitations onto the local machine and does the elemination process. It carries on forever on almost 100% CPU usage (especially if two dimensions which are crossed are fairly large). Even explecitly aggregating that combination on the cube does not make Excel change its mind. Is there any fix or workaround for that? Any feedback is greatly appreciated.Kind regards, Dmitri |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Pivot Table or OLAP Add-in | Excel Discussion (Misc queries) | |||
| How to make my own formula for OLAP Pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table - OLAP Cube | Excel Discussion (Misc queries) | |||
| zero values in olap pivot table report | Excel Discussion (Misc queries) | |||
| Problem with Pivot table Connecting to SQL 2005 OLAP | Excel Discussion (Misc queries) | |||
Hybrid Mode
