COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: twister on 29 Jan 2015 11:17:35 AM

Title: Dimensional - Listing all the members underneath a specified member
Post by: twister on 29 Jan 2015 11:17:35 AM
Hi Cognos Gurus,
Need your help.

How do I list all the members underneath a specified member in dimensional reporting? The specified(input) member could be from any level. But once a member is specified, the report should bring all the members from different levels underneath that particular member.

I guess I can use the descendant function but I need to determine the leaf node to extract upto that point.

Thanks.
Title: Re: Dimensional - Listing all the members underneath a specified member
Post by: CognosPaul on 29 Jan 2015 02:31:54 PM
Descendants is the function to use. Check out the flags, you're looking for "after".