COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: twister on 07 Nov 2013 01:17:59 PM

Title: Extracting members from memberset
Post by: twister on 07 Nov 2013 01:17:59 PM
How do I extract members from a member set individually? I need to extract the members one by one from memberset and use tuple functions to calculate a value and produce the output for each member in different pages?

Please help me Dimensional Reporting Gurus.

Thanks
Title: Re: Extracting members from memberset
Post by: twister on 07 Nov 2013 03:39:08 PM
Hello Dimensional Gurus (Cognos Paul, MFGF and others), I am aware that I can use currentMember function to navigate within the hierarchy but how do I navigate the memberset? Extracting members one by one from memberset for calculation (like a loop)
Title: Re: Extracting members from memberset
Post by: MFGF on 15 Nov 2013 05:43:10 AM
Assuming your set is members from the same hierarchy, the currentMember([Hierarchy]) expression should allow you to reference each member from the set as it is rendered in the crosstab/chart.

Cheers!

MF.