Changing Dimension and Processing through DTS -
08-18-2004
, 09:41 AM
I have a Changing dimension with 2 levels with approx 20K members
Batch Level - Grouping Automatic
Batch ID - integer
Because I set grouping on the top level to automatic, the dimension
defaults to changing. I process the cube each night through dts -
Full Process, Incrementally update dimensions.
Last night I got an error when processing the cube - Attempt to delete
member that is in use] '21823'. Batch ID 21823 was deleted from the
source system which caused the error. If I rebuild the dimension
through the interface, the cube rebuild fine (through dts). I
understand this error occurs when incrementally updating a changing
dimension where members get deleted. My question is if it is possible
to rebuild the dimension each time through dts? This is the only
dimension in the cube that is a changing dimension.
Thanks for you help. |