EPMRETRIEVEDATA returns Incorrect results when refresh workbook

[former_member313968]

Hi Experts,

I have an issue with EPM Add-in. I have a workbook with several worksheet. one of the worksheet has an EMPRETRIEVEDATA formula.

when I refresh data ->worksheet I get a value X, however when a refresh data -->workbook I get a value Y. X and Y are not the same BUT the intersection is the same. the correct value is X. I am not sure how the Y value is being returned.

May you please assist.

Thanks in advance.

Regards,

Godhelp

[Former Member]

Hello,

Based on Context bar =EPMRETRIEVEDATA works,...if your having multiple reports in a single sheet

make sure your context and combination of members using in EPM function.

Reference find below image,identify diff betwn context n EPM dialog box. Just I defined ACCOUNT & TIME because they're differ from context.

[former_member313968]

Dear All,

Thanks all for your suggestions thus far.

On further testing, I have created a normal EPM report without the EPMRETRIEVEDATA function. It appears the problem is with the Hierarchy.

In my report I have selected 2 different entities (all rollup entities) member and descendants, the values are 100% correct. However, if I select the two same roll-up entities (member Only), the one rollup entity is not correct.

Its like the rollup is not working correctly.

May you please assist.

Thanks & Regards,

Godhelp

[former_member186338]

You have to upgrade your core BPC and BW! Look for the notes about incorrect roll-up.

[sreeraj_sukumaran]

Hi

i think the problem could be you are using only 3 dimension in EPMRETRIEVEDATA.

So when you do Refresh workbook it will take workbook context and fetch data.

But when you do Worksheet refresh it takes sheets context and fetch data.

And these both context can be different, So you get different results.

Try refreshing workbook when you are in this sheet you will probably get correct result

[former_member186338]

What do you mean by "workbook context" ?

[sreeraj_sukumaran]

When you go to context option you get worksheet and workbook both option.

you can lock or hide specific dimension in woksheet or workbook, but worksheets always override when you use worksheet refresh

[former_member186338]

"but worksheets always override" . You can refresh worksheet or workbook, but if you have locked context for specific worksheet it will always override!

[Former Member]

Hi Chatikobo,

The EPMRetrieveData function is retrieves the data from a single data intersection, and one intersection cannot have multiple members from the same dimension.My suggestion is that before fetching the retrieve value you may ensure that there is nothing value left for save to server.

Khokan

[Former Member]

Hi Godhelp,

which version of BPC and SP level please?

one of the SP level have an known issue for retrieving incorrect results with different hierarchies that will affect EPMRETREIEVEDATA.

Andy

[former_member313968]

Hi Andy,

I am on

CPMBPC 801 SP 10,

EPM Add-in 10.0 SP 21 Patch 3 .NET 3.5

Thanks & Regards,

Godhelp

[Former Member]

Hi Godhelp,

Is your system HANA enabled?

Andy

[former_member313968]

Hi Andy,

Not sure. how do I check if its HANA enabled?

Thanks & Regards,

Godhelp

[Former Member]

Ask your BPC team or BW team.

Or check if the HANA component is installed.

[former_member313968]

The HANA component is not installed.

[Former Member]

ok, try few things, from top to bottom and one at a time.

install the latest EPM add in.

switch off MDX in BPC

update BPC SP in backend

Andy

[former_member186338]

Please test - instead of EMPRETRIEVEDATA use normal EPM report!

Vadim

[former_member313968]

Hi Vadim,

I am using normal EPM reports BUT for this report I need the EPMRETREIEVEDATA formula. Any other suggestion to resolve this? Why should the same formula not return the same results?

Most appreciated.

Godhelp

[former_member186338]

Normal EPM report don't need EPMRETREIEVEDATA formula.

Vadim

[former_member186338]

In general it's a bad idea to use EPMRETREIEVEDATA in the report like on the screenshot - it will be slow!

Second - in your formula with EPMRETREIEVEDATA there are number of references: Data!A1, A4, Data! A2... There is no evidence that the referenced cells are equal in case of different refresh types. EPM Cell property values has no relation to the result of EPMRETREIEVEDATA.

Vadim