4 Replies Latest reply: Sep 3, 2011 7:09 AM by s j RSS

    SAP QV Connector

      We're currently trying to pull data from SAP BW / Netweaver BI via a SAP connector into QV. Our connection string is working ok and our query works fine under transaction in MDX test in BI.

       

      Here is the error we are receiving:

       

       

      SELECT NON EMPTY {[0SOLD_TO].[All]} PROPERTIES [0SOLD_TO].[20SOLD_TO] ON AXIS(0),{[00O2TGJNNG8HFULJMCOFMBAYL].[00O2TGJNNG8HFULJMCOFMBHA5]} ON AXIS(1) FROM [ZC_SD_01/Z_QLIKVIEW_TEST_2]
      resulted in the ErrorMessage:
      Invalid MDX command with
      Select PseudoMDX (
      Dimensions (
        [0SOLD_TO] ([20SOLD_TO])),
      Measures (
        [00O2TGJNNG8HFULJMCOFMBAYL].[00O2TGJNNG8HFULJMCOFMBHA5]),
      Slices (
        [0SOLD_TO].[All]),
      From (ZC_SD_01/Z_QLIKVIEW_TEST_2))

       

      Does anyone know anything that may be able to help us at this point?