How to use a calendar for more than one table?

[edugallowk]

Hello guys!

How do I solve this problem?
Please kindly help me.

I need the master calendar to interact with the table data (FAT) and with the table (INS). Both tables have dd / mm / yyyy date with the name 'competence'.

If I keep the same name in both tables I fall into the synthetic key problem and if I put different names, then the circular reference error occurs.

Circular reference: One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop (s) will automatically be cut by setting one or more tables as loosely coupled. Use Loosen Table script statement to explicitly declare loosely coupled tables .: return.

Please help me!

Thanks for the attention and big hug.

🙂

[Anil_Babu_Samineni]

Create the composite key which generate the syn key to map into calendar table. Check if that helps link-table

[jonathandienst · Accepted solution]

A composite key will not resolve the circular reference. This data model needs some rework. You could concatenate the fact tables (it does not matter if they don't have many common fields), or (more likely in this case) link the tables through a link table.