Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EPM Context filter - select by Property filter and ID

Hi


Can you tell me how to filter the base members of a node(Parent1 property) and another basemember (ID)  in epmcontext filter with description?


I am trying some thing like 


=EPMContextMember(,"ACCOUNT","PARENTH1=500A";ID=705)&" - "&EPMMemberDesc(EPMContextMember(,"ACCOUNT"))


I want base members of 500A and 705 with description in EPMmember selector.


I tried to create PARENTH1 and ID is separate cell and did the cell reference but EPM member selector is blank


ie

A2= PARENTH1=500A

A3= ID=705

A4=A2&";"&A3


=EPMContextMember(,"ACCOUNT",A4)&" - "&EPMMemberDesc(EPMContextMember(,"ACCOUNT"))




Thank you


Ram


Former Member
Not what you were looking for? View more on this topic or Ask a question