<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Qlik Data Concierge on Sense - Variable entry in Connectivity &amp; Data Prep</title>
    <link>https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Data-Concierge-on-Sense-Variable-entry/m-p/24029#M173</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello all,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i am going to test the QDC (Data Concierge on SAP BW) with Qlik Sense February 2018.&lt;/P&gt;&lt;P&gt;Currently i am having some issues which seems to prevent a productive usage.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1. almost every BEX query in my environment is having fiscal characteristics as filter variables (e.g. fiscal year, fiscal period)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; some of this queries are already used successful in qlikview Environment with sap connector 6.5.1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; if i am chosing one of this queries as source for the QDC it is not easy to put variable values&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; a. only the "low-value" is written as variable to the load script&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; b. in 9 of 10 cases the "high-value" is not written to the variable dialog&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; c. if yes, normally the "high-value" is not written as a variable to the load script but as Parameter to the SQL part&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; d. the Dependence between fiscal variant and fiscal period is not known (not as in qlik view area where it works fine!)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; this Points lead to the Situation that the generated app always has no data Content until the load script is fixed manually and a&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; reload was triggered. This makes it not useful for a normal Business user without programming knowledge!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Does anybody have experience with it or similar cases and can tell me how to fix it?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2. to have Access rules from SAP it is a must to implement one data Connection per user and SAP System.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; because of the normal time dependence for Passwords validity the Connections Needs to be updated every x days with new&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Passwords, which should not be allowed for normal Business users also.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Is there any possibility of a single-sign-on or something else useful?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best regards&lt;/P&gt;&lt;P&gt;Frank&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 26 Apr 2018 15:07:15 GMT</pubDate>
    <dc:creator>fmielsch</dc:creator>
    <dc:date>2018-04-26T15:07:15Z</dc:date>
    <item>
      <title>Qlik Data Concierge on Sense - Variable entry</title>
      <link>https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Data-Concierge-on-Sense-Variable-entry/m-p/24029#M173</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello all,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i am going to test the QDC (Data Concierge on SAP BW) with Qlik Sense February 2018.&lt;/P&gt;&lt;P&gt;Currently i am having some issues which seems to prevent a productive usage.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1. almost every BEX query in my environment is having fiscal characteristics as filter variables (e.g. fiscal year, fiscal period)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; some of this queries are already used successful in qlikview Environment with sap connector 6.5.1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; if i am chosing one of this queries as source for the QDC it is not easy to put variable values&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; a. only the "low-value" is written as variable to the load script&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; b. in 9 of 10 cases the "high-value" is not written to the variable dialog&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; c. if yes, normally the "high-value" is not written as a variable to the load script but as Parameter to the SQL part&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; d. the Dependence between fiscal variant and fiscal period is not known (not as in qlik view area where it works fine!)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; this Points lead to the Situation that the generated app always has no data Content until the load script is fixed manually and a&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; reload was triggered. This makes it not useful for a normal Business user without programming knowledge!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Does anybody have experience with it or similar cases and can tell me how to fix it?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2. to have Access rules from SAP it is a must to implement one data Connection per user and SAP System.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; because of the normal time dependence for Passwords validity the Connections Needs to be updated every x days with new&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Passwords, which should not be allowed for normal Business users also.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Is there any possibility of a single-sign-on or something else useful?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best regards&lt;/P&gt;&lt;P&gt;Frank&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Apr 2018 15:07:15 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Data-Concierge-on-Sense-Variable-entry/m-p/24029#M173</guid>
      <dc:creator>fmielsch</dc:creator>
      <dc:date>2018-04-26T15:07:15Z</dc:date>
    </item>
  </channel>
</rss>

