Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

CONNECTOR WITH SAP OLAP

Hello

I am trying to connect to my BW cubes and queries with Qlikview.

The connexion is alright as I get the cubes info (characteristices, ratio, queries). The script, seems to be correct :

CUSTOMCONNECT TO "Provider=QvSAPOLAPConnector;ASHOST=172.16.101;SYSNR=;CLIENT=;Log=1;XUserId=UQYHXUB;XPassword=FVDYXXA;";
[0IC_C03/ZQIC_QV01]:
Load *;
Select PseudoMDX (
Dimensions (
[0BATCH] (),
[0MATERIAL] (),
[0PLANT] ()),
Measures (
[D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTYQNWSG0U0EO20H6], //Val.entrées stk val.
[D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTZICJ47CDG0QHEQY]), //Val.sortie stk val.
From (0IC_C03/ZQIC_QV01));
Store * from [0IC_C03/ZQIC_QV01] into 0IC_C03-ZQIC_QV01.QVD;
Drop table [0IC_C03/ZQIC_QV01];

When I execute the loading, there are there error messages :

1- Custom connexion failed
Select PseudoMDX (
Dimensions (
[0BATCH] (),
[0MATERIAL] (),
[0PLANT] ()),
Measures (
[D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTYQNWSG0U0EO20H6],
[D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTZICJ47CDG0QHEQY]),
From (0IC_C03/ZQIC_QV01))


2- Table not found
Store * from [0IC_C03/ZQIC_QV01] into 0IC_C03-ZQIC_QV01.QVD

3- Table not found

DROP TABLES statement

Any idea ?

4 Replies
disqr_rm
Valued Contributor III

CONNECTOR WITH SAP OLAP

Check your connection string. It is either wrong or user/id not correct. I also notice you have not specified SYSNR and CLIENT parameters in the connection string. You need to pass those parameters in order to connect.

suniljain
Honored Contributor

CONNECTOR WITH SAP OLAP

Pls Try With Cube which have single table in cube.

Whether it is working sucessful or not.

Not applicable

CONNECTOR WITH SAP OLAP

Hi ,

I am trying to pull data from cube.how can i pull dimension and key figures from CUBE. do any one have idea on that

suniljain
Honored Contributor

CONNECTOR WITH SAP OLAP

you can download application to extract cube and dimention from SAP BW from media section of SAP Group .

if you have any query pls reply me.

Community Browser