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 :
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.