Splitting hierarchies and hierarchy levels into multiple dimensions.

View previous topic View next topic Go down

Splitting hierarchies and hierarchy levels into multiple dimensions.

Post  dcow on Fri Dec 04, 2009 10:55 pm

I have read that Splitting hierarchies and hierarchy levels into multiple dimensions is mistake frequently made when developing the dimensional Models. Consequently i am trying not to make such mistakes. In most situations i have found the Hierachy is certainly valid to the business and will be usefull in drill down operations and serves to define the 1 many relationship within tthe dimension and limit snowflaking. I seem to however be frequently encountering the need to creat a dimension at the different hierachy levels. For example
i might start with a PRODUCT Dimension
wuth attributes alomng the lines of

Product Category
Product Brand
Product
...


But also find the business being modelled would benefit from a dimension at the Product Category level and sometimes even the Product Brand level when the granularity of the facts being modelled is changed.


Is this something that others frequently encounter.

dcow

Posts : 5
Join date : 2009-09-03

View user profile

Back to top Go down

Re: Splitting hierarchies and hierarchy levels into multiple dimensions.

Post  kapoor_dh on Wed Dec 09, 2009 1:57 am

It's always good to define the entire hierarchy in a single dimension (a kind of de-normalized structure) and let the fact be at the lowest granularity,later as the business demands we can go with the summary/aggregate tables or mat views,this gives us the full flexibility for the drill down to the lowest level when it comes to reporting

kapoor_dh

Posts : 24
Join date : 2009-12-08

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum