4 Replies Latest reply: Apr 26, 2011 7:07 AM by s j RSS

    CONNECTOR WITH SAP OLAP

    tomamoon

      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 ?