cancel
Showing results for 
Search instead for 
Did you mean: 

EPMMemberProperty doesn't work for a specific member

dau_hai2
Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Use

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

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

Answers (2)

Answers (2)

dau_hai2
Participant
0 Kudos

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.

former_member186338
Active Contributor
0 Kudos

EPMMemberID is the correct way to create EPM formulas. If you don't use it you may have strange effects.

"2017" is a description of the member [TIME].[PARENTH1].[2018.TOTAL] - not required to be unique!

It may resolve to the correct member or not.

Always use EPMMemberID in your reports.

dau_hai2
Participant
0 Kudos

I am new to EPM. Thanks for your advice!

former_member186338
Active Contributor
0 Kudos

Please show report screenshot if you want an answer!

dau_hai2
Participant
0 Kudos

Hi Vadim Kalinin,

Please see figure as below.

Our BPC NW has version 10.1.

Office Analysis or EPM Addin encounter the same issue.