Hi Robert and thanks for that quick response !!! Here is the physical diagram : everything is an accordance... Also correct at the logical levelI will deleted this fact and recreate it entirely ... can be ...

Hi Robert, a few months later ... busy on other things... Both facts return consistent data ... this error loses me ... If I take the single fact "Admissions classic hospitalization" (the one that causes me problems) I can explore the data and I have no errors. The problem arises when I add one of the other facts to an…

Yes the content levels are the same between the 2 tables. They point to a temporal hierarchy. And the granularity is the same ...

Here is a view of the physical tables, they are identical. In the business model and correspondence, here is the detail of the source table

Thanks for your help Christian !!

I can not have the data differently than so be either monthly or daily. It all depends on the indicator ... how do you do to cohabit fact made with different grains with a single time dimension ? technically possible? or I am wrong ??