Skip to Content

EPMMemberProperty doesn't work for a specific member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 09 at 10:29 AM

    Use

    =EPMMemberProperty(, EPMMemberID(A3), "YEAR")

    You can set it in User Options -> Other: Use EPMMemberID in EPM formulas

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09 at 09:19 AM

    Please show report screenshot if you want an answer!

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09 at 10:37 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded