COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: collierd on 31 May 2009 11:43:51 AM

Title: Display first few levels of a tree prompt
Post by: collierd on 31 May 2009 11:43:51 AM
Hello

I'm struggling a bit with this one

I have an hierarchy created through DMR in framework manager
As a tree prompt, by default, it displays the top level

How do I display the first 2, 3, 4 etc.. levels

e.g. for 3 levels, rather than just show +All Countries amd drill from the top

+ All Countries
    + Europe
       + UK
       + Germany
       + etc.
    + Americas
       + North America
       + etc.
    + etc.

Note, i'm not saying it stops there, you can still drill down

As an addition, if an individual has previously selected something, can this continue to be displayed
I've created it as a dynamic prompt that is auto-submitted every time 'finish is clicked'
Problem is, this also refreshes the tree prompt

Thanks