EPMSAVEDATA..#Ambiguous member id

[Former Member]

Hi Experts,

When i am trying to save single cell value using EPMSAVEDATA function i am getting ambiguous member id error.

This error is coming only for one id R2200, other id R2300 is working fine without any issues.

i am attaching the screen shot of the report and properties.

Please help me to resolve the issue

Regards,

Raj

[Former Member · Accepted solution]

[former_member186338 · Accepted solution]

May be you have R2200 as member id in 2 different dimensions?

[former_member186338 · Accepted solution]

Try instead of $N$1:

"VENTURE:"&$N$1

[Former Member · Accepted solution]

Hi Vadim,

Thanks for your reply.

I will get back to you with the result. looks like its working.

Regards,

Raj

[former_member186338 · Accepted solution]

In general it's a bad practice to have same member id's in different dimensions. Standard practice is to use some prefixes...