Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Hierarchies in dimensional model

2 posters

Go down

Hierarchies in dimensional model Empty Hierarchies in dimensional model

Post  saneel.b 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

Back to top Go down

Hierarchies in dimensional model Empty Re: Hierarchies in dimensional model

Post  nash 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

Back to top Go down

Back to top

- Similar topics

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