roleValue function

[naveen10046]

Hello All,

Can anyone explain me the following Filter expression-

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

[MFGF]

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.

[naveen10046]

Yes,you are right -Its prompting for numeric value which is equivalent to LSA.

Thanks ;D