star schema with several fact tables

[#1]

How does QV handles a star schema with several fact tables that forms a loop among them? like Business Objects Loop in fact tables. for example,

dim_period, dim_product, dim_market connected to fact_1

similarly, dim_product, dim_market connected to fact_2 etc.

I read in other thread that " QlikView will not let you create any kind of loop in your data structure."

Does QV prevent the situation from happen by CONCATENATION or there is some other logic behind it?

[#2]

Hi, if you refers to reference circular , i recommend you this link http://www.quickqlearqool.nl/?p=910

Regards

[#3]

Hi nims,

I think that the solution for this kind of structure is "Linktable".

I have'nt experienced it yet but one guru of qliview(Oleg, i guess) made a nice documentation on it, downloadable here : http://www.naturalsynergies.com/user_files/Loading_Multiple_Fact_Data_Structures_in_QlikView.ppt

It would be nice for all of us if we could have a qvw example for this ? Isn't it ? Oleg Or John or Rob,...

[#4]

Cesijas the link you provided point to this post. Is it a joke or did'nt you see it ?

[#5 · Accepted solution]

My apologies the correct link is http://www.quickqlearqool.nl/?p=910