help with linking master calendar to multiple dates across multiple tables

[hopkinsc]

Hi all,

i have a variety of different dates across multiple tables. i want to link them all to a master calendar but i am struggling to do it. i have tried creating a calendar per table then linking those to a master calendar but i cant seem to get it working.

is anyone able to suggest anything?

i have attached a sample.

many thanks

[marcus_sommer]

Have a look here: Canonical Date.

- Marcus

[Anonymous]

Check this, looks similar to your requirement?

Why You sometimes should Load a Master Table several times

Using Multiple Dates With Master Calendar

.

Linking Master Calendar data to transaction data with multiple dates

Linking to two or more dates

[Anonymous]

I have been working on a model with multiple dates using the blog post Canonical Date.suggested above by Marcus and have found it very useful.

[sorrakis01]

Hi,

I created an example qvw using technical Canonical Date. First the quality of your data is poor and I use Campaign_ID to Primary Key, and don't Load rows if Campaign_ID doesn't exists. I used start_date to Principal Date and only is an idea.

The filters on list box always show the first value column of Table Box.

Repeat, it's only an idea of structure but the data is not correct.

Regards,