Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: How to use SAP BW OLE DB Provider with QlikView

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.

1 Reply
Not applicable

Re: How to use SAP BW OLE DB Provider with QlikView

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.