Hierarchies in dimensional model

View previous topic View next topic Go down

Hierarchies in dimensional model

Post  saneel.b on Fri Sep 07, 2012 10:52 pm

How do you handle hierarchies when each of the attributes are participating in different business processes? So for example , suppose the category (class description), subcategory (subclass description) attributes have been denormalized into the product dimension, which participates in one of the process. And suppose there is a another process where granularity is at , say category level. In that case should there be separate dimensions for category and product, with the category key placed in product dimension?

saneel.b

Posts : 2
Join date : 2012-09-07

View user profile

Back to top Go down

Re: Hierarchies in dimensional model

Post  nash on Tue Sep 11, 2012 2:20 am

Very common scenario, you would create a conformed dimension called 'category'. The other flatened dimension, product, also stays.
This is discussed under 'conformed dimensions' topic in Kimball's DM book.

nash

Posts : 18
Join date : 2010-03-12

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