1 Reply Latest reply: Sep 24, 2012 7:57 AM by B Y RSS

    Problem with QvSAPOLAPConnector

      Dear all,

      I have a problem with the automatic script generated when I connect to SAP BW.

      I use the assistant to generate the scripts.

       

       

      My first script to download the cube BW in the QVD file :

      [F/QUERY1]:
      Load *;
      Select PseudoMDX D (
      Dimensions (
      [0CUST_SALES A] ([20CUST_SALES], [50CUST_SALES], [2ZZNAME4], [1ZZNAME4])),
      Measures (
      [5D0AXOZZELRBUV0N2FM40G5B8].[1TRKY0IQYBVOTCAJN4UDQR81Z]), //Volume
      From F/(QUERY1));
      Store * from [F/QUERY1] into TEST.QVD;
      Drop table [F/QUERY1];

       

      No problem with this step.

       

      My second script to load the QVD file :

      LOAD [Client - Hiérarchie standard Niveau 01 (Key)],

           [Client - Hiérarchie standard Niveau 01 (Text)],

           [Client - Hiérarchie standard Niveau 01 - [20CUST_SALES]]],

           [Client - Hiérarchie standard Niveau 01 - [50CUST_SALES]]],

           [Client - Hiérarchie standard Niveau 01 - [2ZZNAME4]]],

           [Client - Hiérarchie standard Niveau 01 - [1ZZNAME4]]],

           VOLUME

      FROM

      [Z:\TEST.QVD]

      (qvd);

       

      When I run this script, I have an error : "From not existing". I see that the character ']' are more manifold that the character '['. But if I delete the character, I have an error too. Why the automatic script is generated with errors ? how to solve ? I can't be alone with this problem...

       

      Thanks in advance.

        • Re: Problem with QvSAPOLAPConnector

          I have found the solution :

          I must translate the automatic code like this :

           

          LOAD

              "Client - Hiérarchie standard Niveau 01 (Key)",

              "Client - Hiérarchie standard Niveau 01 (Text)",

               "Client - Hiérarchie standard Niveau 01 - [20CUST_SALES]",

               "Client - Hiérarchie standard Niveau 01 - [50CUST_SALES]",

               "Client - Hiérarchie standard Niveau 01 - [2ZZNAME4]",

               "Client - Hiérarchie standard Niveau 01 - [1ZZNAME4]",

               VOLUME

          FROM

          [Z:\TEST.QVD]

          (qvd);