How to load data from SAP HANA analytics view into Qlikview

[Lily]

Hi, 

I'm new in Qlikview development. I've been trying to load data from SAP HANA Analytic View into Qlikview. I created 2 analytics view in SAP HANA but I don't have any idea how to load data from these 2 views in Qlikview. I only managed to load 1 analytics view using  this load script: 

Can someone that have expertise in QlikView and SAP HANA give any idea how can I load data using 2 analytics view without joining these 2 views in Qlikview? 

Thanks.

[fkeuroglian · Accepted solution]

Hi, how are you?

Some considerations:

1) You have sap connector?

2) are you acces uses odbc driver?

You can access to one table as your script and then access to another table using the same script only change the table, depends on the relation that have table1 and table2 will be a relation or not, it depens if the names of the fields are the same or not

Table1:

Load*

from Table1

Table2

Load*

From Table2

If there not any relation, there will be two differents tables that give you information about save hanna

If you have or not sap connector you can see this examples videos:

https://www.youtube.com/watch?v=c5UqDCiTylY

https://www.youtube.com/watch?v=rT63abPKJZY

Hope Helps

FernandoK

[Lily]

Hi, 

I'm fine, thanks for your reply. 

I'm accessing data using ODBC driver to connect with SAP Hana. I've already tried your suggestion and it works. But I didn't understand why qlikview automatically create another table as per the screenshot below: 

It is because of same field name or qlikview define this field as key? 

Thanks.

[fkeuroglian · Accepted solution]

Hi, how are you?

Automatically Qlik when detect the same name in two or more tables, create a new table SYN(Syntethic) with the commons field between the tables.

You can rename the fields WERKS and NAME1 in one table, like this

WERKS AS WERKS_Table1

NAME1 as NAME_Table1

IF you do not want to have a relation between this two table, this is the way

Try this

Fernando

[ABP2021]

Hi  Fkeuroglian,

Can we connect QlikSense with SAP Hana without connector?