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

Roll up dimension question

2 posters

Go down

Roll up dimension question Empty Roll up dimension question

Post  MedicaidGirl Fri May 02, 2014 2:20 pm

I'm looking at page 133 in the 2nd Edition Guide to Dimensional regarding shrunken rollup conformed dimensions with attribute subset. Using the product -> brand example, could the brand dimension have more attributes about a brand than those in the product dimension as long as the additional attributes don't change the grain of the brand dimension. So for example, could the Product Dimension still have the Brand Description, Subcategory Description, Category Description, and Department Description from the rolled up Brand Dimension but not have Brand Logo, Category Owner (as example additional fields in the Brand Dimension)? The two additional fields don't change the grain of the brand dimension, they just add additional details that are needed when joining brand to a fact table but are not needed when joining product to a fact table. Make sense? So in essence can a rollup conformed dimension be a subset of another dimension plus some extra fields?

MedicaidGirl

Posts : 2
Join date : 2014-05-01

Back to top Go down

Roll up dimension question Empty Re: Roll up dimension question

Post  ngalemmo Fri May 02, 2014 8:21 pm

Sure. Why not?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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