topic CONNECTOR WITH SAP OLAP in QlikView https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195676#M714644 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I am trying to connect to my BW cubes and queries with Qlikview.</P><P>The connexion is alright as I get the cubes info (characteristices, ratio, queries). The script, seems to be correct :</P><P style="font-style: italic">CUSTOMCONNECT TO "Provider=QvSAPOLAPConnector;ASHOST=172.16.101;SYSNR=;CLIENT=;Log=1;XUserId=UQYHXUB;XPassword=FVDYXXA;";<BR />[0IC_C03/ZQIC_QV01]:<BR />Load *;<BR />Select PseudoMDX (<BR /> Dimensions (<BR /> [0BATCH] (),<BR /> [0MATERIAL] (),<BR /> [0PLANT] ()),<BR /> Measures (<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTYQNWSG0U0EO20H6], //Val.entrées stk val.<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTZICJ47CDG0QHEQY]), //Val.sortie stk val.<BR /> From (0IC_C03/ZQIC_QV01));<BR />Store * from [0IC_C03/ZQIC_QV01] into 0IC_C03-ZQIC_QV01.QVD;<BR />Drop table [0IC_C03/ZQIC_QV01];</P><P></P><P>When I execute the loading, there are there error messages :</P><H4 style="font-style: italic">1- Custom connexion failed<BR />Select PseudoMDX (<BR /> Dimensions (<BR /> [0BATCH] (),<BR /> [0MATERIAL] (),<BR /> [0PLANT] ()),<BR /> Measures (<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTYQNWSG0U0EO20H6],<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTZICJ47CDG0QHEQY]),<BR /> From (0IC_C03/ZQIC_QV01))</H4><H4 style="font-style: italic"><BR /></H4><H4 style="font-style: italic">2- Table not found<BR />Store * from [0IC_C03/ZQIC_QV01] into 0IC_C03-ZQIC_QV01.QVD</H4><H4>3- T<I>able not found</I></H4><H4 style="font-style: italic">DROP TABLES statement</H4><P></P><P>Any idea ? <I><BR /></I></P></BODY></HTML> Tue, 13 Jul 2010 09:00:16 GMT 2010-07-13T09:00:16Z CONNECTOR WITH SAP OLAP https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195676#M714644 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I am trying to connect to my BW cubes and queries with Qlikview.</P><P>The connexion is alright as I get the cubes info (characteristices, ratio, queries). The script, seems to be correct :</P><P style="font-style: italic">CUSTOMCONNECT TO "Provider=QvSAPOLAPConnector;ASHOST=172.16.101;SYSNR=;CLIENT=;Log=1;XUserId=UQYHXUB;XPassword=FVDYXXA;";<BR />[0IC_C03/ZQIC_QV01]:<BR />Load *;<BR />Select PseudoMDX (<BR /> Dimensions (<BR /> [0BATCH] (),<BR /> [0MATERIAL] (),<BR /> [0PLANT] ()),<BR /> Measures (<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTYQNWSG0U0EO20H6], //Val.entrées stk val.<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTZICJ47CDG0QHEQY]), //Val.sortie stk val.<BR /> From (0IC_C03/ZQIC_QV01));<BR />Store * from [0IC_C03/ZQIC_QV01] into 0IC_C03-ZQIC_QV01.QVD;<BR />Drop table [0IC_C03/ZQIC_QV01];</P><P></P><P>When I execute the loading, there are there error messages :</P><H4 style="font-style: italic">1- Custom connexion failed<BR />Select PseudoMDX (<BR /> Dimensions (<BR /> [0BATCH] (),<BR /> [0MATERIAL] (),<BR /> [0PLANT] ()),<BR /> Measures (<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTYQNWSG0U0EO20H6],<BR /> [D8GE5URGBTXYZAGOPAKSLMM7E].[D8GE5URGBTZICJ47CDG0QHEQY]),<BR /> From (0IC_C03/ZQIC_QV01))</H4><H4 style="font-style: italic"><BR /></H4><H4 style="font-style: italic">2- Table not found<BR />Store * from [0IC_C03/ZQIC_QV01] into 0IC_C03-ZQIC_QV01.QVD</H4><H4>3- T<I>able not found</I></H4><H4 style="font-style: italic">DROP TABLES statement</H4><P></P><P>Any idea ? <I><BR /></I></P></BODY></HTML> Tue, 13 Jul 2010 09:00:16 GMT https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195676#M714644 2010-07-13T09:00:16Z CONNECTOR WITH SAP OLAP https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195677#M714645 <HTML><HEAD></HEAD><BODY><P>Check your connection string. It is either wrong or user/id not correct. I also notice you have not specified <EM>SYSNR and CLIENT</EM> parameters in the connection string. You need to pass those parameters in order to connect.</P></BODY></HTML> Fri, 10 Sep 2010 19:31:58 GMT https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195677#M714645 disqr_rm 2010-09-10T19:31:58Z CONNECTOR WITH SAP OLAP https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195678#M714646 <HTML><HEAD></HEAD><BODY><P>Pls Try With Cube which have single table in cube.</P><P>Whether it is working sucessful or not.</P><P></P></BODY></HTML> Sun, 12 Sep 2010 09:10:32 GMT https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195678#M714646 suniljain 2010-09-12T09:10:32Z CONNECTOR WITH SAP OLAP https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195679#M714647 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>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</P></BODY></HTML> Mon, 25 Apr 2011 16:41:09 GMT https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195679#M714647 2011-04-25T16:41:09Z CONNECTOR WITH SAP OLAP https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195680#M714648 <HTML><HEAD></HEAD><BODY><P>you can download application to extract cube and dimention from SAP BW from media section of SAP Group .</P><P>if you have any query pls reply me.</P></BODY></HTML> Tue, 26 Apr 2011 11:07:04 GMT https://community.qlik.com/t5/QlikView/CONNECTOR-WITH-SAP-OLAP/m-p/195680#M714648 suniljain 2011-04-26T11:07:04Z