Skip to Content

BPC EPM ambiguous 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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 01, 2017 at 06:41 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 01, 2017 at 11:52 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 01, 2017 at 11:53 AM

    Can some of share the sample epm retrieve formula to differentiate

    Add comment
    10|10000 characters needed 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.