topic Re: How to load data from SAP HANA analytics view into Qlikview in QlikView

How to load data from SAP HANA analytics view into Qlikview

Lily — Sat, 16 Nov 2024 20:29:53 GMT

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.

Re: How to load data from SAP HANA analytics view into Qlikview

fkeuroglian — Tue, 09 Jul 2019 15:55:33 GMT

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

Re: How to load data from SAP HANA analytics view into Qlikview

Lily — Wed, 10 Jul 2019 02:49:58 GMT

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.

Re: How to load data from SAP HANA analytics view into Qlikview

fkeuroglian — Wed, 10 Jul 2019 15:46:01 GMT

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

Re: How to load data from SAP HANA analytics view into Qlikview

ABP2021 — Thu, 22 Jul 2021 06:49:40 GMT

Hi Fkeuroglian,

Can we connect QlikSense with SAP Hana without connector?