I am a long time user with QlikView and cannot figure out what the problem is.
We are connection to SAP BW via SAP OLAP Connector. I can see the InfoCubes and the query. I get a script error but the log shows very little informaton.
Screen shot of cube:
Below is a simple script where I an only grabbing one dimension to try and debug the issue.
[ZOEF_M01/QZOEF_M01_5024]:
Load *;
Select PseudoMDX D ( Dimensions ( [ZBPCSACC] ()) Measures ( [45K2ONGJAFEDIZQNBNYJIQ6VE].[45K2ONO7TE031MA3HI0VSS5L6]), //MTD Variables ( [!V000001] (I = [ZOPERCOMP].[AUC]), [!V000002] (I = [0CALYEAR].[2017]), [!V000003] (I = [0CALMONTH2].[02]), [!V000004] ()), From (ZOEF_M01/QZOEF_M01_5024));
Log:
2017-05-05 09:47:01 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPOLAPConnector.dll 5.7 SR1, 10958