CONNECTOR WITH SAP OLAP

[#1]

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 ?

[disqr_rm]

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]

Pls Try With Cube which have single table in cube.

Whether it is working sucessful or not.

[#4]

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]

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.