topic Re: Multiple dates in the datamodel in App Development

Multiple dates in the datamodel

Prasad1318 — Thu, 23 Jun 2022 02:29:45 GMT

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.

Re: Multiple dates in the datamodel

Vegar — Thu, 23 Jun 2022 05:01:13 GMT

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.

Re: Multiple dates in the datamodel

Prasad1318 — Thu, 23 Jun 2022 05:31:50 GMT

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

Re: Multiple dates in the datamodel

Vegar — Thu, 23 Jun 2022 08:56:57 GMT

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.