sql server dts: I have a cube which as some data and now I need to modify the data in
the cube based on some business rules and write the data back.

Can you please give me ideas what is the best way I can do it through
a DTS package.

Thanks

Writing to the cube involves setting the write options and security first,
then defining the difference table that keeps the difference between the
actual and written back value. The only way I know to write back to the cube
is using ADOMD, which is accessed via a language such as VBscript in DTS.

An alternative, which seems reasonable, is to write back to the fact table
on the basis of the change ... but... you can only write back at the lowest
granularity. The OLAP cube write back neatly - it does some estimating of
lowr levels if you write back at a higher level. I suppose you could do the
same, but the code becomes tricky.

Brian Reincke
Parity Training, London


[quoted text, click to view]