Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  OLAP DW modeling issue

Author  Topic  2rn Starting Member 4 Posts Posted - 2011-03-15 : 15:41:40 Hi, I am building a cube for a reporting system (where employees hourly work is registered), and I am not sure how to model this. My grain is defined as: Employee performed a certain amount of Hours per Task on Date e.g.: Robert, 5 hrs, driving, 12 Jan 2011 each task is under a project that belongs to a customer - so i have a parent-child (Task--->Project--->Customer). now i do not know how to deal with the fact that each project has a Project Manager, and each Customer has a Customer Manager. the managers are from the same pull of employees. so should i have the Project Manager as an FK under Project? and same for Customer Manager?? it makes sense but than i will have the dimensions related amongst themselves in a very non-star scheme manner, and i am not sure what will be the result. cheers :)