Error processing parent-child dimension incrementally

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

I have a parent child dimension and child members keep moving from one parent
to the other NOT quite frequently.

The cubes holding this parent-child dimensions are processed and they keep
getting processed every 15 minutes. The dimension (including this parent-
child dimension) have also to be set to be processed incrementally every 15
minutes. If i make any change within this parent-child dimension (that is
move child to a different parent), it gives me an error saying:
Analysis Server Error: Processing error [Attempt to delete member that is in
use]

Any ways to get around this or an appropriate solution will be much
appreciated.

Cheers
Gautham


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-olap/200508/1
.

Relevant Pages

  • Re: MDX Problem
    ... You have a dimension named [Parent Child Dimension]. ... hierarchy created in the dimension. ...
    (microsoft.public.sqlserver.olap)
  • Re: Help Needed: How to deal with ragged dimensions
    ... Another way than using a parent child dimension could be the following: ... If you in the dimension table put in a member at level 2 with the exact same ...
    (microsoft.public.sqlserver.olap)
  • RE: calculated member question -- why (null)?
    ... here's the URL to my blog that deals with why there are ... Regarding the Account dimension, the short answer is that you're using the ... calculated member does display for each member. ... attributes in addition to the Key and the Parent. ...
    (microsoft.public.sqlserver.olap)
  • Process Update - Parent Child vs. Regular Dimension
    ... these measure groups have about 100 partitions for a total of 900 ... The non parent child dimensions process like this: ... a dimension with an attribute of Parent. ... We have another OLAP database with a parent child dimension and it ...
    (microsoft.public.sqlserver.olap)
  • Re: Process Update - Parent Child vs. Regular Dimension
    ... these measure groups have about 100 partitions for a total of 900 ... The non parent child dimensions process like this: ... is ran on a dimension with an attribute of Parent. ...
    (microsoft.public.sqlserver.olap)