troubleshooting Question

Star schema -- modeling a company hierarchy

Avatar of Daniel Wilson
Daniel WilsonFlag for United States of America asked on
DatabasesDB Reporting Tools
10 Comments2 Solutions621 ViewsLast Modified:
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:
Alpha Assets
Bravo Assets
Charlie Assets
Each Asset Group has 2 subsidiaries:
Alpha East
Alpha West
Bravo North
Bravo South
Charlie Legal
Charlie Financial

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:

dim_Company

CompanyID
Name
TypeOfCompany (e.g. Asset Group, Subsidiary, Parent
ParentID (references CompanyID)

I have the feeling that's very wrong ... but can someone steer me straight?

Thanks!
ASKER CERTIFIED SOLUTION
Kent Olsen
Data Warehouse / Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros