Multivalued attribute

glaurent at 16h10
26
Jul
2010
Multivalued attribute

Hi

I have read a lot about this modeling technique but either I didn't understand what I read either this is not the solution suitable to my needs.

Here it is. I am dealing with sales of products in stores.
Each product can be assigned to a collection of assortment values.
Each store can be assigned to a collection of assortment values.
A product can be sold in a store (and is sent to) if one or more of these as

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
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 tha
Dimension with multivalue attributes
I can't seem to wrap my brain around this one, need some help. Data model is simplified for the example given here: fact: Interview dimension: applicant The grain is obviously interviews, however the users want to be able to report interview
Modeling multiple multivalued dimensions and other design questions
Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in
Multivalued Dimension or Multiple facts w/conformed dimensions
I am trying to model for insurance industry, with data as follows: We have data at different levels: Policy level with related facts. ((Premium , face amount, mode etc) Policy Fund level (combination with related fact values.) Policy Rider level
data as an attribute on a dimension or a key on the fact table
Hi, I am in the process of trying to model a mortgage (origination/servicing) data mart. For requirements all I was given at this point is a spreadsheet of attributes. My plan was to try and pull out dimensions and metrics from the list and then have a
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Multivalued attribute "

This topic has been viewed 1774 times.

Last message :
26/07/2010 at 16h10 by "glaurent"