Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Connecting to SAP BI 7.0

Hi this is a very basic question since I'm very new to Qlikview. We have a BI 7.0 installation and I need to run some queries on the infocubes sitting in our BI system. I have installed the QLikview application and I have installed the SAP connector. After that I do not know how to go about finding the BI system to connect to so that I can see the infocubes in the BI system.

Unless I missed it somewhere I couldn't find any good documentation for that. Any detailed notes or suggestions would be much appreciated.

Thanks, Romina

3 Replies
disqr_rm
Not applicable

Connecting to SAP BI 7.0

Reading your question, it seems you are talking about SAP SQL Connector and not OLAP connector, as you want to tradt cubes directly.

If this is correct, you need to find out Fact, SID and Master/text tables behind and extract then separately into QVCD format. Then, at QV side, you may link them up together again.

If you contact your partner, there is anicce QV template application, which lets you specify any Cube and downloads all related data into QVD format. Then you can link them again in QVW document.

Other option lfor you would be to use OLAP connector and read via a BI Query. But this has some limitations for number of records or so.

Hope this helps.

jasonseril
Not applicable

Connecting to SAP BI 7.0

Hello Rakesh,

Do you have a copy of that QV template application which lets you specify the cube? So we can test that application...

Thanks and more power

disqr_rm
Not applicable

Connecting to SAP BI 7.0

No, I don't have it. But you may request your Account/Partner Manager at QlikTech to get it for you.