Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: bindu2008 on 03 Jan 2008 10:20:58 PM

Title: RESTRICT MEASURES AT DIFFERENT LEVELS OF DIMENSION
Post by: bindu2008 on 03 Jan 2008 10:20:58 PM
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!!
Title: Re: RESTRICT MEASURES AT DIFFERENT LEVELS OF DIMENSION
Post by: COGNOiSe administrator on 03 Jan 2008 11:55:18 PM
Can't be done.
Title: Re: RESTRICT MEASURES AT DIFFERENT LEVELS OF DIMENSION
Post by: bindu2008 on 04 Jan 2008 11:32:07 AM
ThankYou :)
Title: Re: RESTRICT MEASURES AT DIFFERENT LEVELS OF DIMENSION
Post by: almeids on 07 Jan 2008 08:49:05 AM
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.
Title: Re: RESTRICT MEASURES AT DIFFERENT LEVELS OF DIMENSION
Post by: bindu2008 on 10 Jan 2008 03:16:13 PM
Almeids,

Right!!! I have done the same.

Thanks.
Title: Re: RESTRICT MEASURES AT DIFFERENT LEVELS OF DIMENSION
Post by: COGNOiSe administrator on 31 Jan 2008 10:05:58 AM
Yes, but you still see them all at every level and Apex, correct?
Text only | Text with Images