Forum Discussion

KSumanth's avatar
KSumanth
Frequent Visitor
2 years ago

Circular dependency was detected

Hi there,  I am trying to create records for 35+ days, 60+ days, 90+ days In my fact table I have mutilple dates which are duplicate.  I have created a Calendar table with condition Calendar (min...
Need Help
Show and Tell
Tips and Tricks
KSumanth's avatar
KSumanth
Frequent Visitor
2 years ago

Thanks for the response,
Here we forgot one more thing, we will be having duplicate records in Calendar table as well. Now I cant have relation for Calendar and my Fact table. 
Even if relation happens Cardinality will be many to many. 

jgeddes's avatar
jgeddes
Super User
2 years ago

My response was not clear. I intend for you to have both a calendar table and a period table proposed in my last response. The period table would filter the calendar table which would then filter your fact table.

  • KSumanth's avatar
    KSumanth
    Frequent Visitor
    2 years ago

    Thanks for the response, The provided solution is not working.