Data relationship modelling issue

Arlind_Selimaj 

when you want to work with (hours, min, sec ) , 

i would recommend you to create w time dimesion . 

then in your fact table, split your datetime column into 2 columns  : 

date , time 

then link dimdate to date , and dimtime to time  

this would ease your work ,

also , it would make  your model more optmized  which in turn would increase performance while decreasing your model size .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠