Forum Discussion

Seethag's avatar
Seethag
New Member
3 years ago

2fact table with multiple dates and one date table

I have 2fact table and each of which table having open and close date and created one date dimension table.

Already made one active and passive relationship between date table to fact table 1

Do I need to create same relationship from date to fact table 2?

If created it is not displayed date in visual

So can you suggest me alternate method

General Comment

1 Reply

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    Hi Seethag 

    It depends on what you need to get from Table 2, but yes you can connect Date table to it or add a new Date Table and connect it to Table 2. It all depends on your needs