Analytics Software

Hello all,

I have a part of my BM which is in snowflake :
MEC date -> vehicle -> invoice
both dimensions tables MEC date and vehicle have their own LTS and their own dimension (hierarchy).
Each dimension table LTS is set to be the lowest level in the dimension
My fact table LTS is set to the lowest level of vehicle, nothing about the date.

I cannot put the date directly in the invoice fact table to turn my snowflake into a star

I have a consistency warning saying that my date dimension table isn't linked to any fact table.(A)
If I add in the fact LTS the lowest level for that date (B), i get an additional error saying my fact table is given an aggregation level to a dimension it is not linked to.

if I don't add the date information in the fact table (B), and I ignore the warning about the dimension (A), I can't run a report using both the date and invoice informations.

Can anybody please tell me what is the proper way to build this snowflake model?

Thanks

Ced