I am pretty rusty on star schemas and OLAP. I haven't worked on something like this in about 5 years, so please excuse a newbie question.
My fact table will come from income statements from a company with a hierarchy of companies. The piece giving me trouble is modeling that company hierarchy.
Parent Company has X Asset Groups:
Each Asset Group has 2 subsidiaries:
Naturally, my analysis is required to be able to roll the figures up at any level.
How should I model the company dimension?
The approach I've sketched is:
TypeOfCompany (e.g. Asset Group, Subsidiary, Parent
ParentID (references CompanyID)
I have the feeling that's very wrong ... but can someone steer me straight?