COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Ann on 11 Oct 2011 05:38:10 AM

Title: Show only first three levels from 4 level hierarchy .
Post by: Ann on 11 Oct 2011 05:38:10 AM
I have a four level hirarchy. But I wanted to show only first three levels in my tree prompt.

Any Clues?
Title: Re: Show only first three levels from 4 level hierarchy .
Post by: colt on 11 Oct 2011 06:29:20 AM
Try detail filter     ordinal(level(currentmember(Hierarchy))) < 3
Title: Re: Show only first three levels from 4 level hierarchy .
Post by: Ann on 12 Oct 2011 12:23:43 AM
Brilliant !!!! thanks a lot... :)