I got a cube based on data coming from Informix accessed
by the linked tables (may be strange, but it works).

When invoking the full cube process from Analysis Manager,
it takes about 30 seconds - even with "Incremental
dimension update" option. Also, when trying to full
process single dimension it takes no time (there is almost
no data at the source tables).

Now, when invoking DTS OLAP processing task it takes 1
MINUTE for every single dimension and 2 minutes for a fact
table (I use several tasks chained - first full processing
of dimensions, next the cube). Altogether it takes... 10
minutes!!!!

Is there any way to find out WHY it happens?
Some details: all operations are performed from UI; I got
administrative privileges, data source used by my OLAP
cube points to MS Access File; access linked tables use
SYSTEM ODBC data source (anyway, it seems Access remembers
all parameters). After cube reprocess everything seems to
be fine...

You can enable both process log (for Analysis Manager) and DTS log (for DTS
process) to compare timestamps on each steps.

Thanks
Wei Zhang
Microsoft OLAP PSS
This posting is provided "AS IS" with no warranties, and confers no rights.