Multivalue attributes

View previous topic View next topic Go down

Multivalue attributes

Post  dkolls on Wed Feb 10, 2010 1:38 pm

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.


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

View user profile

Back to top Go down

Re: Multivalue attributes

Post  BoxesAndLines on Wed Feb 10, 2010 2:41 pm

You could break each multivalued attribute into its own dimension and then create a bridge table for each dimension.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Multivalue attributes

Post  dkolls on Wed May 12, 2010 3:13 pm

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

View user profile

Back to top Go down

Re: Multivalue attributes

Post  BoxesAndLines on Wed May 12, 2010 8:48 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Multivalue attributes

Post  Sponsored content


Sponsored content


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