topic Re: Read Cubes from SAP BW in QlikView

Read Cubes from SAP BW

Sun, 07 Jul 2013 22:26:42 GMT

Hi all,

I need to read cubes from SAP BW, so I should use the QlikView Connector SAP Netweaver, but, I read the SAP BW Documentation and this provides a "Business Explorer OLE DB for OLAP Provider" for third party clients.

Can QlikView use this OLE DB without problems?

Thanks and Regards,

Ricardo Reaño

Re: Read Cubes from SAP BW

Tue, 24 Jun 2014 16:53:58 GMT

Ricardo,

Did you try to connect directly to a CUBE?

If yes, how?

Thanks

Re: Read Cubes from SAP BW

jaimeaguilar — Tue, 24 Jun 2014 17:05:11 GMT

Hi,

If you already have Sap Connector, then you can use it to connect to BW.Current version for Sap Connector is 5.80 SR3

check attachment,

regards

Re: Read Cubes from SAP BW

Tue, 24 Jun 2014 17:15:43 GMT

Jaime.

But the version of the environments of prospects don't allow the version 5.8, only 5.7 because they has BW - 7.0 and ECC 6.0..

and if I install the last version of connector I will need to transfer the requests again!

Right?

Re: Read Cubes from SAP BW

jaimeaguilar — Wed, 25 Jun 2014 14:57:35 GMT

Yes, the manual is for version 5.8, but you should be able to follow it and make the connection to BW with version 5.7

Re: Read Cubes from SAP BW

Anonymous — Wed, 25 Jun 2014 15:16:05 GMT

Hi Lisandro

Connecting directly to a cube can be done using the SAP OLAP Connector (although I would recommend extracting query data and not the whole cube).

Anyway, connecting via OLE DB (without the SAP connector) can be done if you basis team will approve it - but you will be able to extract only tables which may be difficult in case of infocubes.

Thanks

Yaniv

Re: Read Cubes from SAP BW

Wed, 25 Jun 2014 17:08:24 GMT

Thank you Jaime

Re: Read Cubes from SAP BW

Wed, 25 Jun 2014 17:08:53 GMT

Thank you Yaniv