Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Connecting Qlikview to OBIEE RPD!

Hi,

I was trying to connect QlikView to OBIEE RPD and build a report. I am able to connect to OBIEE RPD by creating a DSN and pull the data.

Now the next objective which I want to achieve is to import the complete data model into QlikiVew from OBIEE RPD (where the data model is already built).

The idea is to use the data model build in OBIEE and build reports i.e only the visualization into QlikView.

Is it possible to import the data model into Qlikview instead of loading all the tables in Qlikview again and forming the joins?

If YES how? and if NO why?

And if we import the data model from OBIEE RPD, by default the key fields will not be visible in presentation layer.

And if we need to for the joins in QlikView (presentation layer in this case), key fields must be present. How do I achieve these things?

Hope I am clear on my part.

Thanks in advance!

Regards,

Laxmi

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

The associations between tables in the Qlikview data model are created in the script that loads the data into the Qlikview in-memory database and they are used in the presentation layer. The table associations are fundamental to how Qlikview works.


talk is cheap, supply exceeds demand

View solution in original post

8 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Is it possible to import the data model into Qlikview instead of loading all the tables in Qlikview again and forming the joins?

If YES how? and if NO why?

No, because Qlikview associates tables based on the field names that the tables have in common. It cannot use the primary and foreign keys of the tables from the source database.


talk is cheap, supply exceeds demand
Highlighted
Creator II
Creator II

Hi Gysbert,

Thanks for you reply. I had few questions.

Does those associations has to happen in presentation layer? Can't we use any existing Association directly into Qlikview Presentation Layer?

Is there any way I can connect to existing association(Data Model)?

Thanks for your time!

Regards,

Laxmi

Highlighted
MVP & Luminary
MVP & Luminary

The associations between tables in the Qlikview data model are created in the script that loads the data into the Qlikview in-memory database and they are used in the presentation layer. The table associations are fundamental to how Qlikview works.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Creator II
Creator II

Thanks for the reply.

It helps!

Regards,

Laxmi

Highlighted
Specialist III
Specialist III

Hi Laxmi,

Were you able to load data from OBIEE ? Could you let us know what have done after your first step.

Apologies for raising a question in a closed thread.

Highlighted
Creator II
Creator II

Hi Kiran,

We were not able to fetch OBIEE data model into Qlikview, the reason being Qlikview creates its own data model as Gysbert Wassenaar explained in this thread.


You have create the data model(from OBIEE) again in Qlikview using LOAD SCRIPT.


Hope this helps.


Regards,

Laxmi 

Highlighted
Specialist III
Specialist III

Thanks laxmi for your come back and answering

Highlighted
Contributor
Contributor

Hello everyone,

With BI Connector, you can connect Qlik to OBIEE Subject Areas and Reports data (with joins and aggregations).

Thanks!