Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Recently we've faced on problem with querying from SAP system. During reload QlikView desktop throw AppCrash message but when click "close application" script continue working and fetch all data. As the result we don't have any Error messages neither in QvSAPOLAPConnector and Document log files.
Click "Close the program" and get below:
Another interesting thing is that if we're trying to fetch data from PBP with below script we got error:
[0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV]:
Load *;
Select PseudoMDX D (
Dimensions (
[0COMP_CODE] (),
[0COSTCENTER] (),
[0PROFIT_CTR 10001000] ([80PROFIT_CTR])),
Variables (
[0S_COCD] (I = [0COMP_CODE].[SE02]:[0COMP_CODE].[SE17])),
From (0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV));
If we remove attribute [80PROFIT_CTR] from the query error is gone:
[0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV]:
Load *;
Select PseudoMDX D (
Dimensions (
[0COMP_CODE] (),
[0COSTCENTER] (),
[0PROFIT_CTR 10001000] ()),
Variables (
[0S_COCD] (I [0COMP_CODE].[SE02]:[0COMP_CODE].[SE17])),
From (0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV));
But if we connected to BPQ first script is working fine without any errors.
[0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV]:
Load *;
Select PseudoMDX D (
Dimensions (
[0COMP_CODE] (),
[0COSTCENTER] (),
[0PROFIT_CTR 10001000] ([80PROFIT_CTR])),
Variables (
[0S_COCD] (I = [0COMP_CODE].[SE02]:[0COMP_CODE].[SE17])),
From (0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV));
The only difference we used different Credentials connecting to BPB and BPQ.
Does anyone as an idea how to solve this issue? Log does not have any errors anywhere (neither QvSAPOLAPCOnnector and Document)
Thanks in advance for your help!
Kind regards,
Andrei
Any ideas?
Regards,
Andrei