Forum Discussion
Solved
Circular dependency in Service but no issue in Desktop
Hello, I have two BI reports each having it's own dataset. Both were running for more then a year. Suddendly they stopped refreshing due to the same data source error: A circular dependency was d...
We had the same issue with calendarauto(). We replaced it with
If you have one fact table you can also just use min/max transaction date instead of a hard coded start/end date like above.
allyklee
Advocate I
Advocate IWe had the same issue with calendarauto(). We replaced it with
If you have one fact table you can also just use min/max transaction date instead of a hard coded start/end date like above.
allyklee thank you. This is also a solution. Though it was not so easy to determine min date in our case where a lot of tables contain historical data.
Since the date field in our calendar table was renamed, the change AUTOCALENDAR to CALENDAR caused all relationships dissapeared. So in our case was better to change relationship 1:1 to 1:N.