dbTalk Databases Forums  

Changing Dimension and Processing through DTS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Changing Dimension and Processing through DTS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dave
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.