Dimension Question

I have a table that consists of:
companyid
name
industrycd
subindustrycd
regioncd
when creating the company dimension, should I be linking to other dimensions
(i.e. region, subindustry) or include the names of regions/subindustries
within the company dimension?
One of the primary benefits of OLAP is allowing users to drill down and
drill up through fact data using related dimension structures; see...
http://www.intelligententerprise.com/030320/605warehouse1_2.jhtml
So if there is a natural hierarchy of
Industry -> Sub Industry -> Company
then you would generally make use of that in your dimension to allow
this drill down and drill up to occur.
As the relationship between Industry and Region is likely to be
many-to-many; a second Region -> Company dimension would be the
simplest option to include this hierarchy.
A good resource for dimensional modelling concepts is...
http://www.rkimball.com/html/articlesFundamental.html
JP wrote:
> I have a table that consists of:
> companyid
> name
> industrycd
> subindustrycd
> regioncd
> when creating the company dimension, should I be linking to other dimensions
> (i.e. region, subindustry) or include the names of regions/subindustries
> within the company dimension?