combining data from multiple sources periodically - date hierarchy no longer works

Anonymous as soon as you have a relationship on date column that hierarchy is not there anymore because internal date tables don't exist anymore, having said that, you can create your own hierarchy in date table and use that and this is the right way to do the model, in other words, you are on right track.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!