Data inconsistency with SAP BEx query

[bencicuska]

Hi everyone, 

I am having a problem with creating a PowerBI report based on a SAP BW based KPI cost report. 

We have the following dimensions that we have to use: fiscal period, cost center (hierarchy), cost element (hierarchy).

For technical reasons each organisation has separate measures that we have to use for columns: actual year amount, previous year amount, actual year correction, previous year correction, budget.

I managed to get the data into PowerBI but even before the data transformation the previous year amount data is inconsistent with what is in BW, even though everything else is correct. I tried to figure out why this occurs and what's very strange about is that when I only import the highest level of cost element (Total operating cost), the data is still correct. When I include level 2, we get a different (smaller) number, and when I get to level 4, the number is even smaller than before.

Have you guys ever encountered something like this or at least have an idea on what should be causing the problem?

[johnbasha33]

@bencicuska 

It seems like you're facing inconsistencies with the previous year amount measure when importing data from SAP BW into Power BI. The discrepancies may stem from differences in how the data is aggregated or filtered at various levels of the cost element hierarchy. Check the aggregation logic, data filters, and calculation methods used in both systems. Additionally, ensure data quality in SAP BW is consistent. Consulting SAP BW experts for insights could help resolve the issue.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!