Deleting single element from consolidation

[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

[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,

[dima55]

Hi Steve

Thanks alot.It works all fine

Regards
Dima