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

thanks.

when the pivottable access the cube, a query is executed to retrieve the
name of the measures.
this query cause the measures to be evaluated. so if you have 15 measures,
the query retrieve the value of these 15 measures, this slow down the
opening process.
use the profiler to identify this query and optimize your cube (specially
calculated measures)

other option...
reduce the size of your metadata (less dimensions)


"Kazmane" <mkazmane (AT) capinfo (DOT) co.ma> wrote