topic Issue with Sap BEx Connector in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-with-Sap-BEx-Connector/m-p/128603#M690 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>I installed Qlik Sense (Apr 2018) and the Sap connector (7.0).</P><P>In the Qlik side everything works correctly, while queries via SAP connector on BEx have sometimes positive results other negative (it goes into the BEx dump).</P><P></P><P>As I saw with the customer, the error seems to reside on some parameters pre-set in the BEx query that should be numeric but in Sense they look like strings. But this is just my hypothesis.</P><P></P><P><SPAN lang="en"><SPAN>This message appears when I try to open the match code to find a value.</SPAN></SPAN></P><P><IMG alt="image001.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214928_image001.jpg" style="height: 496px; width: 620px;" /></P><P></P><P><SPAN lang="en"><SPAN>This message appears if I try to manually enter the value in the Qlik field of the connector.</SPAN></SPAN></P><P><IMG alt="image002.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/214929_image002.jpg" style="height: 540px; width: 620px;" /></P><P></P><P>Do you have any idea about it?</P></BODY></HTML> Tue, 02 Oct 2018 16:20:27 GMT claudio_pette 2018-10-02T16:20:27Z Issue with Sap BEx Connector https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-with-Sap-BEx-Connector/m-p/128603#M690 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>I installed Qlik Sense (Apr 2018) and the Sap connector (7.0).</P><P>In the Qlik side everything works correctly, while queries via SAP connector on BEx have sometimes positive results other negative (it goes into the BEx dump).</P><P></P><P>As I saw with the customer, the error seems to reside on some parameters pre-set in the BEx query that should be numeric but in Sense they look like strings. But this is just my hypothesis.</P><P></P><P><SPAN lang="en"><SPAN>This message appears when I try to open the match code to find a value.</SPAN></SPAN></P><P><IMG alt="image001.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214928_image001.jpg" style="height: 496px; width: 620px;" /></P><P></P><P><SPAN lang="en"><SPAN>This message appears if I try to manually enter the value in the Qlik field of the connector.</SPAN></SPAN></P><P><IMG alt="image002.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/214929_image002.jpg" style="height: 540px; width: 620px;" /></P><P></P><P>Do you have any idea about it?</P></BODY></HTML> Tue, 02 Oct 2018 16:20:27 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-with-Sap-BEx-Connector/m-p/128603#M690 claudio_pette 2018-10-02T16:20:27Z Re: Issue with Sap BEx Connector https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-with-Sap-BEx-Connector/m-p/128604#M691 <HTML><HEAD></HEAD><BODY><P>Finally i resolved this issue. The problem was with the default values of the optional variables as explained in this doc:</P><P></P><P><A class="jive-link-external-small" href="https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Clients/SAP-BEx-connection.htm" rel="nofollow" target="_blank">https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Clients/SAP-BEx-connection.htm</A></P><P></P><P>So, if necessary, it needs to change the query on BEX according with the hints in the article.</P></BODY></HTML> Fri, 19 Oct 2018 10:01:13 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-with-Sap-BEx-Connector/m-p/128604#M691 claudio_pette 2018-10-19T10:01:13Z