Hi All,
In Cell C1 I have "ACTUALS"
If therefore I alter the statement below which currently returns "BUDGET"
= EPMOlapMemberO("[CATEGORY].[PARENTH1].[BUDGET]","","BUDGET","","002"
Changed to
= EPMOlapMemberO(C1"[CATEGORY].[PARENTH1].[BUDGET]","BUDGET","","002")
It returns "ACTUALS"
The problem is however that when I refresh it all reverts to the original formula.
Why?
Lucy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.