Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sccheong on 12 Oct 2010 04:20:04 AM

Title: Retrieve only the lowest levelfrom the tree prompt
Post by: sccheong on 12 Oct 2010 04:20:04 AM
Hi,

Please find the following hierarchy:

Company (root)
Zone (Level 1)
Region (Level 2)
Country (Level 3)
Branch (Level 4)

sample data:
Asia Pacific Zone
   Australia
     Australia
         Brisbane
         Sydney
         Melbourne
         Perth
   North Asia
      Japan
         Tokyo

When user does multiselect from the tree prompt at any level, only retrieve the lowest level, example user selected Australia (Level 3 -  Country) and Tokyo (Level 4 - Branch), the expected results is as follow:

Brisbane
Sydney
Melbourne
Perth
Tokyo

Can anyone tell the function or any way to achieve this.

Would really appreaciate if anyone would help :)
Title: Re: Retrieve only the lowest levelfrom the tree prompt
Post by: cognostechie on 12 Oct 2010 12:29:28 PM
Check this:

http://www.cognoise.com/community/index.php/topic,10840.msg35568.html#msg35568
Text only | Text with Images