Hello:

This is my first post in the forum. I am new to dimensional modeling and trying to design a model based on the existing OLTP system.

Attached are the ERDs for existing OLTP system and a dimension model that I have developed. Can someone expert in this area take a quick look and offer me suggestions please? It won't take much time as the model is simple. I am especially worried about the inclusion of bridge table STORE_DEPARTMENT in the model and the dimension tables referencing other dimension tables. Is this normal or I am doing it wrong? I am trying to check if the model can answer some of the DSS questions but your suggestions would really help me if I am going in a wrong direction.

Thanks in advance for your help

Regards,
techbuddy