Multiple tables with multiple date fields but client users want a calendar that interacts with all tables

[Anonymous]

Hi

I'm working with a large number of tables that all have different dates fields but my end users only want one Year / Week / Month list box to make selections.

What is the best way to achieve this?

The background to this query is we currently use a calendar created from the time sheet date field from a time sheet header table, this holds current and past dated transactions. However, we have a new table for holiday bookings that shows future dated transactions.

When I change the calendar creation to use the holiday booking date I'm losing employees off my report who have not yet booked a holiday but do have time sheets.

All suggestions welcome,

Trudie

[sunny_talwar]

check this

Canonical Date

[MK9885]

One Fact with Date entries from other dimensions mapping to Master Calendar.

You can probably do left join with the key you've to the fact for the date fields. This way the Fact contains all the dates?

Not sure but can you pot a sample data and expected output as well?

[satishkurra]

ALso this

Tutorial - Using Common Date Dimensions and Shared Calendars