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
help me?
Yan |