EPM duplicate values

[Former Member]

By mistaske few dimension member values are same in entity and accounts.For example 1000 dimension member values is used by entity and accounts.

It is mistaken defined.Lot of data is already loaded,hence cannot be deleted.

So while defining EPM report with retrieve formula...few of these lines  where 1000 values is specified getting error message of duplicate members.

While calling the values by EPMretrieve..how to make sure that I am calling the 1000 value only for account dimension.

How to make sure that account dimension values are retrieved properly for this duplicate member and no error is shown.

[former_member182766]

I agree with Vadim. In future you will have loads of issues having duplicate members in different dimensions (EPM automatically tries to identifiy the dimension, using member ID, considering it's unique). That's why it's a good practice to use prefixes for your IDs.

[former_member190501]

Hi,

You can use EPMMemberID or in retrieve function instead of referring 1000 for account dimension use as follows :

[ACCOUNT].[PARENTH1].[1000]

ACCOUNT - Account dimension

PARENTH1 - If there is any Hier on Account dimension if not leave it as a blank ( [] )

Hope it helps...

Regards,

Raju

[former_member186338]

Hi,

It's better to correct this mistake (data reload or copy data between cubes...). It will generate a lot of issues with reports.

B.R. Vadim