Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
Any idea ?
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.
Pls Try With Cube which have single table in cube.
Whether it is working sucessful or not.
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
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.