topic Please answer for the Link Table in QlikView

Please answer for the Link Table

Tue, 28 Apr 2015 06:29:30 GMT

Hello All,

I have Below issue to be done.

I have multiple fact tables having different granularity of data,

Lets say Fact1 having date level data,(many facts available for the same)

Fact2 table having month level data( one fact or more)

Fact3 having year level data ( One have or more)

i have many dimensions,

Now my question is here i have only one Date Dimensions, how can i include this in the link else do i need to take three date tables to link individually to the facts?

Please help

Thanks in advance

Regards

Sreeharsha V

Re: Please answer for the Link Table

Ralf-Narfeldt — Tue, 28 Apr 2015 07:35:50 GMT

I think a master calendar could help you.

The Master Time Table

Re: Please answer for the Link Table

Tue, 28 Apr 2015 09:42:02 GMT

Hello Ralf,

Thanks for the repose

I am using the master calender only, my question is do i need to use three date dimensions tables to link with the three types of granular level data

Thanks