Multi-valued attribute that has fact type data

View previous topic View next topic Go down

Multi-valued attribute that has fact type data

Post  TenchiJin on Thu Aug 09, 2012 6:39 am

Hi all,

I have a scenario where I have a dimension that stores information about site, lets call it a store. For each store I want to be able to record simple demographic information about each store in the guise of gender and some broad age bands.

What I have done so far is created a junk(?) dim to store all combinations of gender and age band

What I need to do is then record the demographic information against each store in a many to many, which would be fine, however I need to record two "facts" about each demographic combination for each store in the guise of number of people and a percentage of the total population that relates to the store. Both these "facts" ideally need to be additive so I can do roll up calculations within the hierarchy of the store dimension.

This demographic information is only updated about once a year but needs to be available all year round and behave as one would expect when doing time based queries.

I initially went with a bridge table but this doesn't seem to fit the need to provide these facts in an additive manner.

All guidance will be greatly appreciated.

Thanks in advance


TenchiJin

Posts : 4
Join date : 2011-11-28

View user profile

Back to top Go down

Re: Multi-valued attribute that has fact type data

Post  LAndrews on Thu Aug 09, 2012 5:28 pm

Sounds like you've described a demographic fact table. Dimensions are Store, Gender, Age_Band etc.


LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

View user profile

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