COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen10046 on 19 Mar 2010 12:28:57 PM

Title: roleValue function
Post by: naveen10046 on 19 Mar 2010 12:28:57 PM
Hello All,

Can anyone explain me the following Filter expression-

roleValue('_businessKey',children([ATM Cb Rpt1].[LSA].[LSA].[LSA]->:[PC].[@MEMBER].[Lsa]))=?lsa?

Title: Re: roleValue function
Post by: MFGF on 22 Mar 2010 12:18:42 PM
Hi,

It is filtering the child members of member 'Lsa' to retrieve just that one which has a business key equal to the parameter value ?lsa? (which I assume is being prompted for or passed in from a report above).

MF.
Title: Re: roleValue function
Post by: naveen10046 on 24 Mar 2010 04:12:27 AM
Yes,you are right -Its prompting for numeric value which is equivalent to LSA.

Thanks ;D