Thanks Thomas, that helps!. I conclude here that we have two options #1 is to create three Time Dimensions and one Fact #2 is to one Create Canonical time dimension and use three sets of Facts. It is highly recommend to use #2 approach. Thanks all for your great support and advise. Regards Hesh

Thanks Joel

Thanks Thomas and Joel. In Presentation layer , if I have single set of facts, only 3, using different Logical Table Sources, in this case we have to have three different time dimension folders? If no how to know whether we are referring to which date dimension?Created Date,Corrected Date,Modified Date Date Dim Day Month…

Thanks Thomas, So you want to say we need to have three different sets of measures? Data_Quality_Fact - Created Date #Created Date - Events #Created Date - Open Events #Created Date - Closed Events Data_Quality_Fact - Corrected Date #Corrected Date - Events #Corrected Date - Open Events #Corrected Date - Closed Events…

Thanks Manoj, Thomans and Christian. Canonical time dimension is a very interesting discovery for me! I am glad that I know this one existing now! I am able to understand up to creating fact aliases and use them in the Fact table Logical Table Source. But what about measures? Do I need to create more measures? I have…

Thanks Andrew,Joel, Manoj and Christian. If my understanding is correct after Physical layer and BMM joined with table aliases I will be having three different folders in Presentation layer? Christian: what is canonical time dimension? I tried google but did not get the right answer, how can it be useful here? Regards Hesh