Excel 2007 PivotTable crashes with string calculated members

[Andreas Flockermann [BonaVista Systems]]

Hi NG,



I am working with the Excel 2007 PivotTable and Analysis Services 2005
cubes.

I have some calculated measures on the server that return strings (len
between 5 - 200 chars). When I show these calculated measures in the
PivotTable, Excel 2007 crashes.

It not crashes immediately, It happens after like 3-4 min browsing.



Any ideas? Where could I file that bug, so that it gets fixed with Excel
2007 SR1?



Thanks,



Andreas

 

[Andreas Flockermann [BonaVista Systems]]

An update:

I disabled the multithreaded calculations in the Excel Options dialog box
and now it works perfectly. It seems that multithreaded calculations with
OLAP data are very buggy.



Andreas

www.microcharts.net