Roll up dimension question

View previous topic View next topic Go down

Roll up dimension question

Post  MedicaidGirl on 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

View user profile

Back to top Go down

Re: Roll up dimension question

Post  ngalemmo on Fri May 02, 2014 8:21 pm

Sure. Why not?
avatar
ngalemmo

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

View user profile http://aginity.com

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