Multiple dates in the datamodel

[Prasad1318]

Hi guys,

I am stuck with a problem, it would be great if someone help me out.

I have a 3 fact tables each table connected with one  other by one field ‘system’ . And I have 3 different dates coming from 3 tablesa each. So how can I connect these to master calendar. To use the canonical date concept, I don’t have unique Id from any of the table. Please help me on this.

thanks in advance,

prasad.

[Vegar]

You have three three fact tables and the only common field is system. Could it be possible to concatenate these three tables into a single fact table where you rename the three date columns into a common date field?

If you do this then you could create a canonical date using the new date field together with the system field.

[Prasad1318]

Hi Vegar, Thank you for the reply. I tried it I can create master calendar with the same date field , in kpi’s I can differentiate using Flag.

One small doubt, generally how we can confirm that tables are associated correctly?

Thank you 

Prasad

[Vegar]

The three tables where already assoiciated on the [system] field. I don't see that it would change if your concat them into a single table . Please elaborate on your consern.