Custom Consolidation
Hi,
I have a requirement from business that, want to restrict the roll-up in the entity dimension.
for ex: i have Top entity, and all the members underneath are rolling up to Top, but i want to r...
Forum Discussion
I agree with Henning that an alternative hierarchy is the simplest way to do it. Another scenario I think has too many problems associated with syncing data. I suppose you could write a custom consolidate BR that updates a UD member during consolidation. You have UD members GroupA, OthersGroups and their parent is TotalGroups. During Consolidate, the BR looks for the Entity being consolidated - if it's GroupA, the UD member for the data is switched to GroupA, everything else goes to OthersGroups. Then use Slice Security so that GroupA users only see OthersGroups and everyone else sees TotalGroups. I'm not recommending it; it's a possibility.