BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« Pareto Charts in Project BI | Main | S-Curves for Everyone! »

November 24, 2009

Common hierarchies in Project star schemas

So you are designing your star schemas to store project history and your looking for those common dimensional hierarchies.

Well, here my friends, are a few that we come across quite frequently that you may find useful, both natural and not-so-natural. Note that I am not, at this point, telling you how to create these in ETL, but instead wanted to throw out some ideas of common hierarchies that your BI reporting users will want to see:

Programs > Portfolios > Projects
Programs > Projects
Portfolios > Projects
Projects > WBS > Tasks
Projects > WBS > Resource assignments
Projects > Costs
Programs > Costs
Resource Teams > Resources > Assignments
Resource utilization > projects > assignments

Posted by Mark Kromer at November 24, 2009 11:30 AM


Post a comment

Remember Me?