Wrong values in EPM report

[Former Member]

Hi, all,

we are loading values into SAP BPC 10.1 SP 6 on BW 7.4 from a BW InfoCube.

currently I am comparing values between the ERP source system, the transaction Listcube of the source InfoCube in BW, the transaction Listcube of the InfoCube in BPC and the EPM report.

There are in certain cases different values in the EPM report compared to the values in the transaction Listcube of the InfoCube in BPC.

Does anybody have an explanation for this behaviour?

I checked the restrictions of the context menu of EPM.

Thanks in advance and best regards

Gerd

[Former Member · Accepted solution]

Hi Gerd,

Please check if you are you using a Dimension Member Formula to calculate value for account 31811401?

- Raj

[Former Member]

Hi gerd,

                  in the previous screenshots of BW & BPC i had seen that the records like this

       BW -  31811401   FLOW is F10 & INTERCOMPANY is NONE          

                  31811401   FLOW is F10 & INTERCOMPANY is I_NONE

                NOTE: these two are two different records and with the different combination

       BPC -  31811401  FLOW is END & INTERCOMPANY is I_ALLNONE (i think this is the parent in page axis)

                 NOTE : this is the different combination and then how it get result in the epm report like this

                                             1013

               31811401      --    99.634,64

note :   verify the package what you have chosen and verify the combination you have taken in the                      report  

  Question :  is there any logic you had written or is there any default logic check it why because the signed data changes  and also check it if any calculation is done in the report ?

[JohnL]

Hi Gerd,

What version of BW you using?

HANA ?

HANA MDX enabled?

thx

[Former Member]

Hi Gerd,

if you have some different values between value inside and BW it could be related with the AccType property of account in BPC maybe you have to change some value in the property, read please this document http://scn.sap.com/docs/DOC-26973

Regards

     Roberto

[Former Member]

Hello, thanks for your answers.

The issue is about transactional data that we loaded from a BW InfoCube into the BPC InfoCube via the data manager package "Load from InfoCube UI"

We have the following values in our BPC infocube:

I compared the values with the BW InfoCube and the ERP system.

The values in the BPC InfoCube are the same than in the ERP system and in the BW InfoCube

When we now open our report for 03.2015 we get the following values in our report:

The values for Account 31811401 does not have any connection to the value in the BPC infocube.

For other accounts and companies this problem does not occur.

Do you have an idea what could be the reason for this behaviour and how can  we solve this issue?

Thanks in advance and best regards

Gerd

[Former Member]

Hi Gerd,

could it be a manual insert or from another package? Verify in data audit this account to understand when and who insert this value.

Regards

     Roberto

[Former Member]

Hi Gerd,

According to your BPC report you had taken 1) Flow- END & 2)Intercompany - I_Allnone

But according to your BW 1)Flow - F10 & 2) Intercompany - NONE & I_NONE

And i can't see the Currency dimension in your Page Axis......

So kindly try to correct your BPC report & check it one more time..........

Aravind

[Former Member]

Hi Gerd,

As per the standard behavior of BW if you see the values in BW Infocube of BPC it will show you the aggregated values...

And it also depends on the type of data load you had done...From BW to BPC.....

If you can show us a Sample EPM report screenshot & the BPC Infocube Table screenshot for a particular Member for which data values are mismatching....!

Then we can explain you clearly about the behaviour......!!!!!

Aravind

[chuan_ding]

Hi Gerd

Can you give a example about what values is wrong in EPM report compared to the values in BW?

for example, master data or transaction data

Best regards,

Chuan