RESTRICT MEASURES AT DIFFERENT LEVELS OF DIMENSION

[bindu2008]

I have a scenario like this.
I have 10 measures in the model and 5 dimensions. In one dimension I have 3 levels. At last 'level' for that dimension I donot want to show 3 measures out of 10.

How can I achieve that.

If I apex or exclude that level, all the measures will be affected. so that is not the solution. I want to see some measures at that level but not all.
Any quick suggestions will be greatly appreciated.

Thanks in advance!!

[COGNOiSe administrator]

Can't be done.

[bindu2008]

ThankYou :)

[almeids]

Wouldn't separate query subjects for the 2 subsets of measures with varying scope achieve the intended effect?

Query 1 - include 7 measures and levels 1, 2, 3 of dimension
Query 2 - include 3 measures and levels 1, 2 of dimension

I suppose it depends on what you mean by "do not want to show"...you'll always "see" all the measures but the ones from query 2 will be zero at level 3 without allocation.

[bindu2008]

Almeids,

Right!!! I have done the same.

Thanks.

[COGNOiSe administrator]

Yes, but you still see them all at every level and Apex, correct?