Need Suggestion

[Abhi30]

Hi all,

In my tax cube i want to put value in city because that are on leaf level
but i want the value same in conslidated level
suppose i put 10 in jammu city then 10 value should be in state jammu-kashmir.
i dont want consolidated value in state level.

[Wim Gielis]

Hello,

What is the logic here ?

So you put a value on a leaf level city, but they should not add up?
Why do you create a consolidation of cities if you don't want to consolidate ?

You could change the weights of certain cities in their total equal to 0, so they are not taken into account. Like the weight for Shrnager equal to 0 in its totals.

Or you could have a C-level rule to override the natural consolidation.

But before all this, think about the (business) logic and try to understand why it's like that.

[tomok]

I'm assuming this is a tax rate cube and you are using it as a driver to calculate taxes somewhere else and that is why you don't want it to consolidate? In this case simply take out the consolidations. If you can't, because this dimension is used elsewhere, then create a new dimension to use in this cube that has all the same elements but that are all leaf elements. I've used this approach many times and it will work fine. This is really you're only viable option.