Error "#RFR" in local member during expansion using drill down BPC 10.0 NW SP 13 Patch 2

[Former Member]

Hello guys,

I´m developing a report using local members in columns, this local member is trying to get transaction data using EMRetrieveData EPM function; If I refresh the context selection it works fine, but if I double click trying to drill down in rows, the local member is showing the "#RFR" error.

Does anybody can help if I need to add any VBA in order to refresh local members after doubleclick??

Thanks and regards,

Luis

[former_member186338]

Hi Luis,

What is the reason to use EMRetrieveData?

B.R. Vadim

[Former Member]

Hi Vadim,

I´m getting unit values for each account expended in rows, dividing each account between the value extracted by the local member.

I´m using local members because even the extracted value is one of the accounts listed in rows.

Regards,

Luis

[former_member186338]

Absolutely unclear, sorry!

Please provide the details - formula to calculate, account members etc.

Vadim