Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.