Yesterday I tried to create my starschema with tables from the ERP. It resulted in a very strange cube with measures that was supposed to be dimensions. The dimensions didn´t have any natural hierarchies that I could create. Today I will do everything again.
I will start by dividing the facts and dimensions in different tables with clearly understandable members. Then I will make my DSV and connect all tables with each other with correct PK, FK and so on. Hopefully it will be a better result today.