Multivalue attributes
2 posters
Page 1 of 1
Multivalue attributes
I am working on a model for use by the fund raising unit of our university. They want to be able to do some CRM type reporting on our alumni / donor data.
In creating a constituent dimension I have found that there are a large number of attributes that are multivalued. A constituent can have zero, one or more degrees, one or more category codes, zero, one or more exclusion codes, zero, one or more (in some cases hundreds) of activity codes and so on.
I have read what I can find on multivalued dimensions in ‘The Data Warehouse Toolkit’ and in many articles, but most of what I have read deals with one multivalued dimension. I have not been able to get a clear idea as to how to deal with several multiple dimension attributes.
Is the way to handle this to create a factless fact for constituent and try to combine them that way?
Thank you for any advice or further study I can do on this.
In creating a constituent dimension I have found that there are a large number of attributes that are multivalued. A constituent can have zero, one or more degrees, one or more category codes, zero, one or more exclusion codes, zero, one or more (in some cases hundreds) of activity codes and so on.
I have read what I can find on multivalued dimensions in ‘The Data Warehouse Toolkit’ and in many articles, but most of what I have read deals with one multivalued dimension. I have not been able to get a clear idea as to how to deal with several multiple dimension attributes.
Is the way to handle this to create a factless fact for constituent and try to combine them that way?
Thank you for any advice or further study I can do on this.
Last edited by dkolls on Mon Mar 01, 2010 12:50 pm; edited 1 time in total
dkolls- Posts : 2
Join date : 2010-02-10
Location : Waco, TX
Re: Multivalue attributes
You could break each multivalued attribute into its own dimension and then create a bridge table for each dimension.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Multivalue attributes
Would the bridges be between the constituent dimension and each new dimension or between each new dimension and the fact table?
dkolls- Posts : 2
Join date : 2010-02-10
Location : Waco, TX
Re: Multivalue attributes
Between the fact and the dimension. Here's a link to an article, bridge tables, or search the board for bridge tables. There's lots of posts on the topic.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Dimension with multivalue attributes
» dimension table design question for around 100 attributes and higher level calculated attributes
» Dimension Attributes and Fact attributes storing same data in multiple data marts??
» SCD attributes
» Dimensional Attributes
» dimension table design question for around 100 attributes and higher level calculated attributes
» Dimension Attributes and Fact attributes storing same data in multiple data marts??
» SCD attributes
» Dimensional Attributes
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|