F
frsa
Hi,
I have developed a program which creates a connection to a sql server cube
and import data into excel as Pivot table (Excel 2007), but very slow after
choosing 5 or more fields from Pivot Field Table List. It goes "Running OLAP
query, Reading items.." and takes so long time (CPU Usage goets high, 100%
but memory is ok). Is it capacity problem or coding error somewhere? My
machine is P4, 3.4GHz and 3GB RAM. I appreciate for your advises.
I have developed a program which creates a connection to a sql server cube
and import data into excel as Pivot table (Excel 2007), but very slow after
choosing 5 or more fields from Pivot Field Table List. It goes "Running OLAP
query, Reading items.." and takes so long time (CPU Usage goets high, 100%
but memory is ok). Is it capacity problem or coding error somewhere? My
machine is P4, 3.4GHz and 3GB RAM. I appreciate for your advises.