Dimensions with Multi Valued Attributes
User Rating: / 0
Written by Vincent Rainardi   
Sunday, 20 March 2011 00:16

A multi valued attribute is an attribute which has more than 1 value per dimension row. A “Multi Valued Attribute” is different to A “Multi Valued Dimension”. A “Multi Value Attribute” occurs in a dimension, whereas a “Multi Valued Dimension” occurs in a fact table. A “Multi Valued Dimension” is a dimension with more than 1 value per fact row. As always it is best to explain by example:





XL Cubed