Force Destination Members - selective

[srikanth_ramachandran]

Hello Friends,

Does anyone know of a way (or whether it is feasible) to selectively update the result lines of an elimination / consolidation? For instance, I have a line of business dimension that is part of my cube; when the consolidation process runs and new records are generated for the scope values, the original line of business value is copied into the new lines (for the source accounts as well as the group account lines). I want to plug a constant value into just the destination group account line for the line of business and let the other lines retain the original value. If I use the Force Dest members option for this dimension value, it updates all of the new lines with the constant value.

Thanks!
Sri

[former_member186338 · Accepted solution]

In general you can use script logic. But the idea is not clear!

[srikanth_ramachandran · Accepted solution]

Thanks Vadim - I thought of the same approach; was just curious as to whether anyone has been able to do it via the Elim rule setup.