We have a multiple fact model where each fact are refreshed at different times. Fact A is refreshed on-demand. Fact B is refreshed monthly and the Fact C is refreshed quarterly. How can we show all the facts regardless of the date? Even if the tables are concatenated we cannot show facts from all three tables.
