Skip to Content
0

BPC EPM ambiguous member

Dec 01, 2017 at 04:44 AM

121

avatar image
Former Member

I have 1001 defined as entity as well as profit center in BPC . Due to this when I try to retreive the data, the formula errors saying ambiguous member value.

How to address this issue in EPMretrieve formula based report.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Dec 01, 2017 at 06:41 AM
0

It's a bad idea to have identical id's for different dimensions. Use prefix like PC_1001 for master data.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 01, 2017 at 11:52 AM
0

In the EPM retrieve there is a formula to differentiate.Can some one the syntex for it.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 01, 2017 at 11:53 AM
0

Can some of share the sample epm retrieve formula to differentiate

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but BPC setup with the same member ID's for different dimensions is absolutely unprofessional and have to be fixed ASAP!

EPMRetrieveData can use syntax like: DIMENSIONNAME:MEMBERID or [DIMENSIONNAME].[PARENTH1].[MEMBERID]

But once again, it's a bad solution.

0