I need to some help in desiging the dimensions for the cube. Here is the situation
We have a Region attibute (RegionCode and RegionName), Office (OfficeCode and OfficeName), Organization (OrganizationID and OrganizationName), OrgCategory(CategoryCode and CategoryDesc)
A region has multiple offices under it. A offices has multiple organizations under it. And a organization falls under one of the Org Category (There are two types of Org Categoty defined).
Here is an example
Region - Central
Office - CHI, DAL
Organizations under CHI - CHISALES, CHIENG
CHISALES comes under Org Category SALES and CHIENG comes under ENG category.
Please let me know how we showuld design the cube structure on this.
1. Do we need separate dimensions for Region, Office, Organization and Org Category?
2. OR we can have one Region Dimension and other tables (Office, Organization, Org Category) should be linked with it? and create a hierarchy.
Please let me know your thoughts.
View Complete Post