data modelling problem

[munna1317]

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

[ashfaq_haseeb]

Hi,

Have a look at below posts.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

Regards

ASHFAQ

[#3]

I would do a Right join of master calender with the Fact Table and make a Key for all the dimension tables with the dates.

TempTableA:

Fact Table

Right Join(TempTableA):

Calendar table;

TableA:

Load*,

Component_Key&Date as New Component Key,

CI_Key&Date as NewCI_Key,

..........

Resident TempTableA;

Drop Table TempTableA;

Also create same king of key on the different Dimension table. and do an outer join just for the keys to the link table to the fact table.

Your issues will be resolved automatically.

Thank you

Suraj

[#4]

If you can send a sample script I can help you better.

Thank you

Suraj

[IAMDV]

Hi Harish,

You should read what Ashfaq suggested. Especially first post is written by Henric and it's very relevant to your situation. This is classic case of using the link table which links to the Transactions table and Calendar table. It will be one to many relationship.

Thanks,

DV

www.QlikShare.com