Product Dimensions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Product Dimensions

I have several items and the business views these items according to a number of attributes linked to the item:
– Product category
– Product source (manufactured, purchased, transferred)
– Brand
– Flavour
– Packing Group The Packing Group is a combination of attributes which defines the size of a pack (bottle size, cap type, things like that). There is never a set hierarchy as to how these are viewed. I’ve thought about modelling items as:
1. Create a star-schema dimension which has Product category then Product, and have a bunch of attributes hanging off Product
2. Create virtual dimensions based on these attributes However, this seems problematic to me as the Packing Group has its own attributes. I then consider I might need a "physical" star-schema dimension for each of the above classifications. Is this the right way to go? Can any body suggest a better way or point me to some examples?
Not gone into much of details, but see whether is any help. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.