FORMULA EPMMEMBERPROPERTY ERROR EXCEL 2016 10,1 CLASSIC NW

[former_member322611]

Hi experts.

I have a report, with the following formula "=EPMMemberProperty(;"PLAN";"YEAR")" in excel 2016 does not show the value (appear empty), in excel 2013 this formula run correctly.

Thank you all.

[former_member186338 · Accepted solution]

Try to use:

=EPMMemberProperty(;"[CATEGORY].[].[ACTUAL]";"YEAR")

Where CATEGORY is your dimension name and there is no hierarchy for this dimension.

P.S. Another option is to use this syntax:

=EPMMemberProperty(;"CATEGORY:ACTUAL";"YEAR")