Forum Discussion
Data inconsistency with SAP BEx query
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 (hie...
johnbasha33
Super User
Super Userbencicuska
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 !!