7 Replies Latest reply: Sep 22, 2014 8:14 AM by Yaniv Feldman RSS

    Syntax Error - Loading PseudoMDX from a QVD - SAP OLAP Connector

      Hi

       

      My Query using the SAP OLAP Connector is the following:

       

      [NP_M09/QNP_M09_001_REV]:
      Load *;
      Select PseudoMDX D (
      Dimensions (
      [0ME_ITEMNO] () ,
      [0ME_ITEMTYP] () ,
      [0ME_ITEM_CA] () ,
      [0ME_ITEM_NO] () ),
      Variables (
      [0TYEAR] (I [0CALMONTH].[201409]:[0CALMONTH].[201409])),
      From (NP_M09/QNP_M09_001_REV));
      Store * from [NP_M09/QNP_M09_001_REV] into NP_M09-QNP_M09_001_REV.QVD;

       

       

      This works fine, but when I store the data into a QVD and load the table back into my application I get the following:

       

      LOAD

       

         [[0ME_ITEMNO]] - Item Number Level 01 (Key)],
      [[0ME_ITEMNO]] - Item Number Level 01 (Text)],
      [Item Type - Item Type Level 01 (Key)],
      [Item Type - Item Type Level 01 (Text)],
      [Item Category - Item Category Level 01 (Key)],
      [Item Category - Item Category Level 01 (Text)],
      [[0ME_ITEM_NO]] - Item Number Level 01 (Key)],
      [[0ME_ITEM_NO]] - Item Number Level 01 (Text)]


      FROM
      [D:\NP_M09-QNP_M09_001_REV.QVD]
      (
      qvd);

       

       

      I receive an error on lines 1, 2, 7 and 8. This is due to the extra square brackets created when loading the data from a QVD.

       

      I’ve tried manually removing/adding square brackets for example:

       

      LOAD [[0ME_ITEMNO] - Item Number Level 01 (Key)],
      [[0ME_ITEMNO] - Item Number Level 01 (Text)],
      [
      Item Type - Item Type Level 01 (Key)],
      [
      Item Type - Item Type Level 01 (Text)],
      [
      Item Category - Item Category Level 01 (Key)],
      [
      Item Category - Item Category Level 01 (Text)],
      [[0ME_ITEM_NO] - Item Number Level 01 (Key)],
      [[0ME_ITEM_NO] - Item Number Level 01 (Text)]
      FROM
      [
      D:\QVDev\Newspapers\Magen.Vadivelu\News_BI\AdsData - SAPBW\NP_M09-QNP_M09_001_REV.QVD]
      (qvd);

       

       

      But this just causes the whole line to error.

       

      Please assist – Any help would be appreciated.

       

       

      Regards,

       

      Magen