Cube Replication from OBIEE

Anonymous — Fri, 14 Jul 2017 12:13:27 GMT

I know that cube concept is not there in Qlik. But i need to replicate a cube from OBIEE to Qlik. My final aim is to provide a platform for the business users to directly drag and drop the fields and visualize data.

Since in obiee there is a direction of join (ie from Fact table to Dimension Tables) , it was much easier to avoid circular loops.

I have around 5 fact tables and 5 dimension tables.And all the fact tables are connected to most of the dimension tables.

In order to avoid circular loops, right now I have duplicated each dimension table seperately for each fact table.It's working fine but the issue is : while creating reports one should be sure of which duplicate dimension table is to be used.. otherwise the data will be completely wrong.

I came to know that link table is something we can work on to avoid this ...

Is there any easy method to do this?

if not , pls help me how to proceed on this.

Thanks in advance

topic Cube Replication from OBIEE in QlikView

Cube Replication from OBIEE