Difference between Database and SAP BI

[Former Member]

Hello Experts,

we load via VIEW Data into BI. Extraction and Loading are perfect, but we have differences in Sales. When we Look into a

Excel File from the Database for a Month, and I select the same characters from the InfoCube, we get Differences in Sales.

What we can Do ? Where we can look?

Regards

MO

[Former Member · Accepted solution]

Hi Mojito,

What database are you using ? Please describe a little bit more as there can me several reasons for difference between figures between database and SAP BI. It something related to your data source you are using but still we need more information.

Regards

Sunny

[Former Member · Accepted solution]

Hi Sunny,

it is a ORACLE 10 Database.

Regards

Mo

[Former Member · Accepted solution]

Hi Sunny,

2 Figures.

K1 FLTP 16 16 24 intern

K2 FLTP 16 16 24 intern

[amine_lamkaissi · Accepted solution]

Please look in your transformations.

May be, check also the calculation mode of your key figures.

Thanks.

Best Regards,

Amine

[Former Member · Accepted solution]

Hi Amina,

Problem solved.

THNKS

[Former Member · Accepted solution]

Hi Mojito,

Great !! So where was the exact problem, was it in Calculated Key Figures.

Regards

Sunny

[amine_lamkaissi · Accepted solution]

Very happy to hear that.

All the best.

Amine

[Former Member · Accepted solution]

Yes exactly )

Edited by: Mojito on Sep 9, 2011 10:39 AM

[amine_lamkaissi]

Hi,

Your view is in SAP R/3 system?

Regards,

Amine

[Former Member]

Hi Amine,

no, not SAP System. Other Database...

Regards

MO