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

Dimension or Fact - product ratings

2 posters

Go down

Dimension or Fact - product ratings Empty Dimension or Fact - product ratings

Post  topcat Thu Jan 24, 2013 12:31 pm

I have a retail dimensional model that includes a product dimension, which is type 2, and is truly a slow change dimension.

New requirements are to add product ratings to the product. for purposes of this question, there are 2 new attributes: number or ratings and the average rating which is a whole number between 1 and 5. Product ratings can change often, sometimes daily for a large retailer. The rating data comes as part of the product feed. My question is how should this be modeled? I don't want to add the attributes to the current product dimension as it will modify my slowly changing dimension to one that gets updated often. but the business requirements includes dimension browsing, like "report all products with a 5 star rating". I don't want to create a separate independent dimension because that wouldn't allow for the browsing queries. I could create a snowflake dimension, but that doesn't seem right either. I could create a fact, but it definitely is not factual data. we receive a product feed daily and we detect change by product when updating the product dimension. if i created a fact, then i would have to detect change from the previous fact in order to create a new one.

Any help would be appreciated.



Posts : 19
Join date : 2012-08-09

Back to top Go down

Dimension or Fact - product ratings Empty Re:Dimension or Fact - product ratings

Post  hkandpal Thu Jan 24, 2013 8:46 pm


the rating change for a product should be stored in a Fact table and for a product you should have one rating which will be active. It will be some thing like a transaction fact table. You may have some products where the rating may change daily and some may have same rating for months.



Posts : 113
Join date : 2010-08-16

Back to top Go down

Back to top

- Similar topics

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