topic Re: data modelling problem in QlikView

data modelling problem

munna1317 — Fri, 20 Nov 2020 18:02:30 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

Re: data modelling problem

ashfaq_haseeb — Fri, 05 Sep 2014 16:37:37 GMT

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

Re: data modelling problem

Fri, 05 Sep 2014 21:46:59 GMT

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

Re: data modelling problem

Fri, 05 Sep 2014 21:49:05 GMT

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

Thank you

Suraj

Re: data modelling problem

IAMDV — Sat, 06 Sep 2014 10:45:07 GMT

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,