Data from SAP BW open ODS view not correct - (Cartesian product)

[Pascal_KTeam]

Hi all

I have a BEx Query which is based on an open ODS view in SAP BW. (What is an open ODS view: https://help.sap.com/doc/saphelp_nw74/7.4.16/en-US/3c/2501f075cb42b1aef74b6b4e5fa9de/content.htm?no_...)

I use Power BI to load this data via import mode. Unfortunately, the data I get is the Cartesian product so it can't be used.

The data in BW looks like this:

Country	User
Switzerland	User 1
Germany	User 2

But the data I see in Power BI looks like this:

Country	User
Switzerland	User 1
Switzerland	User 2
Germany	User 1
Germany	User 2

So I wonder if anybody has experience with loading data from a BW Open DSO View. Is this even supported by Power BI?

[Adrian1989]

Use LibreOffice or OpenODS, and you will be able to open it correctly. Hope that helps you 😉

[Pascal_KTeam · Accepted solution]

Solved: once a key figure is added to the open ODS view in BW, it works fine

[v-frfei-msft]

Hi @Pascal_KTeam ,

To be honest, I have no expericen with that. I have done some research for that, Hope the third - party article can help you.

https://businessintelligist.com/2017/04/11/power-bi-and-sap-what-works-and-what-doesnt/