sql server data warehouse: what is "slow"?

when the pivottable access the cube, the first time a query is executed
against the server to retrieve the measure names, but this query also ask
for the data, not only the labels. (use the profiler to see this query)
if 1 of your measures is a complex one, then you'll suffer a delay.

if your metadata is more complex in your cubes, then the time required to
retrieve the metadata is longer.

verify if you have the right SP level installed on the server AND the client
verify if you have activated the compression

also, it could be an authencation issue, maybe you suffer a delay due to a
network configuration issue (verify the DNS configuration if you use the
Active Direcotry)
again, use the profiler on the server to identify the source of the problem.

[quoted text, click to view]

can someone help to reduce a time connecting to As2005 with using OLEDB9.0
and PivotTable.

thanks.