Show only first three levels from 4 level hierarchy .

Ann · 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?

colt · 11 Oct 2011 06:29:20 AM

Try detail filter ordinal(level(currentmember(Hierarchy))) < 3

Ann · 12 Oct 2011 12:23:43 AM

Brilliant !!!! thanks a lot... :)

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com