Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Lily
Contributor III
Contributor III

How to load data from SAP HANA analytics view into Qlikview

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: 


QLIK Comm.PNG

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.

Labels (4)
2 Solutions

Accepted Solutions
fkeuroglian
Partner - Master
Partner - Master

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

View solution in original post

fkeuroglian
Partner - Master
Partner - Master

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

View solution in original post

4 Replies
fkeuroglian
Partner - Master
Partner - Master

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
Contributor III
Contributor III
Author

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: 

Capture12.PNG

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

Thanks.

 

 

fkeuroglian
Partner - Master
Partner - Master

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
Contributor II
Contributor II

Hi  ,

Can we connect QlikSense with SAP Hana without connector?