inconsistent values for the same account (member)

[Former Member]

Is someone facing the following issue:

We have a spreadsheet showing "Net Income" on row 24 with a correct (Default report). However, same account on row 36 (same account and all other dimension being the same as the default report and report002 all share Axi) show different
numbers. The problem seems to be related to how reports pull in
numbers that are parts of hierarchies. When we look at the data it is
correct but the reports seem to be hitting some road block.

       
Steps for Reconstruction

- Create a new report - 001
- Create another report - 002
- Refresh worksheet - different values for the same account are shown
- Select the value in report (click on the cell with the 'incorrect value'
- Refresh selected data - values now are equal
- Refresh worksheet again - different values for the same account are
shown again.

Thanks

Joel

[Former Member]

just as an update... I got the solution for this issue.

After installing SAP Notes 1753959 and 1714492 the problem was resolved. We had to run RSRCACHE to clean up the OLAP cache and  drop out  temp hierarchies tables. Both procedures are explained in the notes.

Thanks for the help anyway.

Joel

[damovand]

Hello Joel,

I recommend capturing the EPM Add-in logs and providing them to the support engineer.  Please see note 1752871 on how to enable the logs.

Please also confirm if this problem is data region dependent or happens to all data regions within that report.

Best Regards,

Leila Lappin

[Former Member]

Hi Leila,

Not sure if I understood your question... I think is data region dependent, the value in Default Report is correct. If I insert the formula in this report, I get the same value. However, if I insert the formula in Report 002, I'm getting another valuer.  This is member is a PARENT level. It doesn't happen with CHILD level.

Thanks,

Joel

[former_member186338]

Hi Joel,

BPC NW 10 SP12, EPM SP16 Patch 1

No issues! Both reports have shared page and column axis, same members in row axis:

B.R. Vadim

[Former Member]

Thanks Vadim,

We are with BPC NW 10 SP08, EPM SP16 Patch 1.

This problem is bugging us a lot...  We applied SP Note 1714492 as recommended by SAP, however it didn't work.  They also recommended to upgrade to SP09 (SAP Note 1750249), which we don't want to do now.

Does anyone has any other recommendation?

Thanks,

Joel

[former_member186338]

Ups, no idea... Can you provide some screenshots to confirm the issue?

[Former Member]

This is what we have...

Default Report

= EPMOlapMemberO("[F_ACCOUNT].[PARENTH1].[NET_INCOME]";"";"Net Income";"";"000")

Repor002   

= EPMOlapMemberO("[F_ACCOUNT].[PARENTH1].[NET_INCOME]";"";"Net Income";"";"002")

Thanks for the help.

Joel

[former_member186338]

But what about page axis - do both reports share the same?

[Former Member]

The default report shares axis with report 002.