how to link multiple dates to single calendar

[#1]

I have 5 different tables and each table has start_date and end_date. Need to link all these dates to the master calendar. Can someone please help me with this.

Regards

kumar

[jonathandienst]

See Henric Cronstom's article on this topic: Canonical Date

[balasundaram]

Hi,

do Link Table , based on start_date and end_date from all tables.

This is only best solution(LINK TABLE).

after give link to master calendar.

Regards,

Bala

[avinashelite · Accepted solution]

Hi Raman,

Create a link table to include all the dates .

Link table will best option.

e.g

master:

Load id,

          createdate,

          enddate

Select SQl;

link table:

load id,

       createdate as date

resident

master;

load id,

      enddate as date

resident

master;

calender:

load

     date,

.........

SQL;

.

.

[abhaysingh]

Hi Kumar,

You can do one thing Suppose you have 5 transaction table's and five different dates in it.. Name them same name suppose link_date and concatinate all 5 table on the basis of link_date. and create your master calender as per link date.

Tab1;

load

Date1 as link_date,

field1

from.....

concatenate

Tab2:

load

Date2 as link_date,

field2

from...

concatenate

Tab3:

load

Date3 as link_date,

field3

from....

and so on for all transaction TABLE.

thanks

abhay

[#6]

GOOD

[vardhancse]

Yes, we can do using link table. But issue is that each record will be multiplied by the number of tables.

If the data is very huge it may impact the performance, instead creating 3 separate calendars may also work.it depends on the data volume to the dashboard

[#8]

Thanks everyone for your response much appreciated.

I used link table and everything is working fine.

Regards

kumar.R

[avinashelite]

Hi Raman,

If you have got the answer please mark it as correct answer and close this thread