<?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 ODBC Connect to SAP HANA Calc View in Connectivity &amp; Data Prep</title>
    <link>https://community.qlik.com/t5/Connectivity-Data-Prep/ODBC-Connect-to-SAP-HANA-Calc-View/m-p/803643#M1015</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi guys,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I've been trying to connect Qlik Sense to my HANA system, to read a Calc View.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;First issue is that the ODBC Wizard is not working properly. So I cannot create the loading statement with the wizard.&lt;/P&gt;&lt;P&gt;&lt;IMG class="image-1 jive-image" height="167" src="https://community.qlik.com/legacyfs/online/75485_pastedImage_0.png" style="width: 694.899328859061px; height: 167px;" width="695" /&gt;&lt;/P&gt;&lt;P&gt;So I can see data retrieved but can't select rows or columns or nothgin. No Scrip is generated from this.&lt;/P&gt;&lt;P&gt;You can already see there is something wrong, because already in here all Metric columns are already empty.&lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-2" height="153" src="https://community.qlik.com/legacyfs/online/75486_pastedImage_1.png" style="width: 345.464285714286px; height: 153px;" width="345" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So I go to the Script and try to load data manually.&lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/75488_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;This works and I can load data.&lt;/P&gt;&lt;P&gt;The problem is that when I go to see the data I've loaded I'm missing metrics. &lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-4" src="https://community.qlik.com/legacyfs/online/75489_pastedImage_4.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any thoughts on what can be the cause of this issue ? Is it possible to read a Calc View from Qlik Sense via ODBC ? I know I can via ODBC because I do it from Tableau and it works. This is the first time I've experienced something like this.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks !&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 16 Jan 2015 11:40:41 GMT</pubDate>
    <dc:creator />
    <dc:date>2015-01-16T11:40:41Z</dc:date>
    <item>
      <title>ODBC Connect to SAP HANA Calc View</title>
      <link>https://community.qlik.com/t5/Connectivity-Data-Prep/ODBC-Connect-to-SAP-HANA-Calc-View/m-p/803643#M1015</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi guys,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I've been trying to connect Qlik Sense to my HANA system, to read a Calc View.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;First issue is that the ODBC Wizard is not working properly. So I cannot create the loading statement with the wizard.&lt;/P&gt;&lt;P&gt;&lt;IMG class="image-1 jive-image" height="167" src="https://community.qlik.com/legacyfs/online/75485_pastedImage_0.png" style="width: 694.899328859061px; height: 167px;" width="695" /&gt;&lt;/P&gt;&lt;P&gt;So I can see data retrieved but can't select rows or columns or nothgin. No Scrip is generated from this.&lt;/P&gt;&lt;P&gt;You can already see there is something wrong, because already in here all Metric columns are already empty.&lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-2" height="153" src="https://community.qlik.com/legacyfs/online/75486_pastedImage_1.png" style="width: 345.464285714286px; height: 153px;" width="345" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So I go to the Script and try to load data manually.&lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/75488_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;This works and I can load data.&lt;/P&gt;&lt;P&gt;The problem is that when I go to see the data I've loaded I'm missing metrics. &lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-4" src="https://community.qlik.com/legacyfs/online/75489_pastedImage_4.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any thoughts on what can be the cause of this issue ? Is it possible to read a Calc View from Qlik Sense via ODBC ? I know I can via ODBC because I do it from Tableau and it works. This is the first time I've experienced something like this.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks !&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 16 Jan 2015 11:40:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Connectivity-Data-Prep/ODBC-Connect-to-SAP-HANA-Calc-View/m-p/803643#M1015</guid>
      <dc:creator />
      <dc:date>2015-01-16T11:40:41Z</dc:date>
    </item>
  </channel>
</rss>

