Page 1 of 1

Deleting single element from consolidation

Posted: Thu Oct 25, 2012 10:45 am
by dima55
Hi All

I have a consolidation say A which has a elemnt b. "A" consolidation is used in a dimension many times as a child to different consolidation. I want now to delete b elemnt from "A"consolidation in just one parent rest all parent iwant elemnt b to be present in "A" consolidation.

I have tried using both delete and delete in consolidation. Both delete s the element from all the consolidation.

thanks
Dima

Re: Deleting single element from consolidation

Posted: Thu Oct 25, 2012 11:12 am
by Steve Rowe
Thats to be expected. There is only one definition of the consolidation A, not a different one depending on what it rolls into.

You either need a different A underneath each conso where its different, or put your element B with a weighting of -1 above the conso A in the hierarchies where you want b removed.

Second option sounds better.

i.e.
Conso C = A -b
Conso D = A

So you leave your definition of A alone.

Cheers,

Re: Deleting single element from consolidation

Posted: Fri Oct 26, 2012 7:30 am
by dima55
Hi Steve

Thanks alot.It works all fine :)

Regards
Dima