Calender Issue

[#1]

Hi All,

I have a data model with multiple facts and every fact table has a date reference.

eg:

Fact 1 - Order date

Fact 2 - Shipment date

Fact 3 - Recept Date

Now i am trying to build a master calender. from which of the date available i should be considering to get min and max date ?

it would be great if you can provide me with some sample.

Logical if i see i should consider Order date for creating my master calender but what if there comes a new fact which may have dates well before min of order date ?

Please help me understand.

Thanks

KS

[jonathandienst · Accepted solution]

Hi

This excellent article should help you.

Canonical Date

HTH

Jonathan

[Anonymous]

Hi,

Use Canonical-date  by Henric

Regards

Neetha

[#4]

Thanks Jonathan for pointing me out to the post. and yes i feel this will work in my case.

Thanks

KS