Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use SAP BW OLE DB Provider with QlikView

Hello All,

I ma trying to access some Bex queries using SAP BW OLE DB provider, I can successfully create a connection to SAP BW but no queries are visible. I am aware of the fact there are special SAP connector for that but i need to access only a couple of queries from SAP BW and it is not really worth to buy whole connector license in this case.

My queries in SAP BW are already set to allow external access and they are even visible if i use OLE DB connection in Excel. Can somebody please help me how to access those SAP BEx queries using SAP BW OLE DB provider.

Thank you.

Sameer

1 Solution

Accepted Solutions
Not applicable
Author

Found the solution on my own. BEx quires are not really quires but OLAP cubes. I have to pass MDX statement in order to fetch the data.

View solution in original post

1 Reply
Not applicable
Author

Found the solution on my own. BEx quires are not really quires but OLAP cubes. I have to pass MDX statement in order to fetch the data.