Need some help here...I have two dimension tables
The DimWorkType is at lowest level and has the WorkTypeCategoryKey as foreign key.
We have a WorkType category defined in the WorkTypeCategoryTable.
There are two kind of busineess usres who have categorized the WorTypeCategory in the different way.
For example for one set of users we have the mapping like this
WorkTypeCode WorkTypeName WorkTYpeCategoryKey
AMC consultant 1
B110 Manager 2
The DimWorkTypeCategory is like this
For another set of users the AMC comes under the category "Internal" and B110 comes under the "Business". Please let me know how we can handle this situation?
Do we need the separate dimension for the another set of users or we can manage in one DimWorkTypeCategory dimension?
View Complete Post