Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Make sure your connector is up to date, and if so you might try to submit a Support ticket if you cannot find the help you're looking for here.
Ya it looks as though we'll have to get on to support. Thanks for the reply.
request to increase timeout parameter in connection string .
in case of multi query provider response time is too high and some time SAP Qlikview connector is unable to get response.
Qlikview Connector is lacking in Multi query Provide.
I implemented two project in SAP BW and pased lots of issue during extraction of data from multi query provider.
I am Requesting all of the user to post their SAP related issue in Under SAP Group.