Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.