on 03-09-2018 2:48 AM
Dear experts,
We have a dynamic report with TIME dimension as below.
A2= EPMOlapMemberO("[TIME].[PARENTH1].[2016.TOTAL]","","2016","","000")
B2= EPMOlapMemberO("[TIME].[PARENTH1].[2017.TOTAL]","","2017","","000")
C2= EPMOlapMemberO("[TIME].[PARENTH1].[2018.TOTAL]","","2018","","000")
On the row below, we have function to display just the year of those members.
A3=EPMMemberProperty(,A2,"YEAR")
B3=EPMMemberProperty(,B2,"YEAR")
C3=EPMMemberProperty(,C2,"YEAR")
From the web admin, I can see that all members have property value YEAR as 2016, 2017, 2018 correspondingly.
However, the function EPMMemberProperty cannot return value for member 2017.
I have apply note 2201768 - FAQ regarding programs UJXO_CLEAN_DIM_CACHE and UJXO_CLEAN_TDH_DIM_CACHE - BPC 10.X but there is no result.
Could you please suggest a fix for this?
Thanks.
Use
=EPMMemberProperty(, EPMMemberID(A3), "YEAR")
You can set it in User Options -> Other: Use EPMMemberID in EPM formulas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim Kalinin,
Your proposal works!
However, we have many existing reports that may have this issue. It seem to have something that make the particular TIME dimension member 2017.TOTAL doesn't work with the formula.
It would be great if I can understand if this is EPM bug and correct with master data.
Thank you so much.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please show report screenshot if you want an answer!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.