data modelling problem

munna1317 — Fri, 05 Sep 2014 16:31:35 GMT

hi ,

as shown in the below image ,

i have one task details as " transaction table (Fact-Table)"

and

i have remain all are "master- table(Dimension-table)"

- Calender2 is a master caleder is just link to fact table with "link- date ".

1st problem :

i am getting only the transaction table details which are common to corresponding dimensions.

2nd problem :

i need to link master calender"linkdate" to all dimension with out generating any syntactic keys or circular reference .

plz tell solution ,

thnks in adv,

harish

topic data modelling problem in QlikView