PIVOT Data Export Performance Problems - 06-23-2005 , 12:27 PM
I'm using the OWC10 PivotTable control as a tool to show my cubes created in
SQL Analysis Server for our project. The problem is when I use
PivotTable.Copy PivotTable.ActiveView to export the data to Excel, it always
takes a long time to export if the rows over 50. I found the point is twelve
measures and two calculated members needed in the columns. I tried to use
localcube, but it is also very slow.
We get a lot of complaints from our customers for this issue. Can anybody