hi BPC Gurus
I've a question on EPMSelectMember.
In Cell A1 I've the value AST.
In Cell A2 I've this formula, which the Select Member is based on the filter by property ACCTYPE which is linked to cell A1.
=EPMSelectMember("FINANCING","[ACCOUNT].[PARENTH1].[12345]","ACCTYPE="&A1,"",FALSE)
However, after selecting the member, the formula on the filter became hard coded and no longer linked to cell A1. If I changed cell A1 value to LEQ, the EPMSelectMember did not automatically change the filter value.
=EPMSelectMember("FINANCING","[ACCOUNT].[PARENTH1].[456789]","ACCTYPE=AST","",FALSE)
How do I make this formula so that the filter value can be based on another cell?