Forum Discussion

bencicuska's avatar
bencicuska
New Member
2 years ago

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 (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?

Need Help

2 Replies

  • johnbasha33's avatar
    johnbasha33
    Super User
    2 years ago

    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 !!

  • metrica's avatar
    metrica
    Post Prodigy
    1 month ago

    Hi bencicuska,

     

    Since the value changes when additional hierarchy levels are selected, the issue may be related to how the Previous Year Amount key figure is calculated or aggregated.

     

    Power BI accesses SAP BW through the public MDX interface, while BEx uses a different interface. Some BEx calculations, filters, and hierarchy behavior may therefore return different results.

     

    Check whether the key figure uses local calculations, exception aggregation, or default filters.

     

    If the underlying data is available through SAP OData, Power BI Connector for SAP can provide an alternative extraction path: https://www.sap.com/products/data-cloud/partners/metrica-software-inc-power-bi-connector-for-sap.html

     

    BEx-specific calculations and hierarchy logic would still need to be provided by SAP or recreated in Power BI.

     

    A 30-day free trial is available.

    Documentation: https://metricasoftware.com/docs/sap/

     

    Cheers,
    Metrica Team