Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Customer Orders, with Multiple Demography details

3 posters

Go down

Customer Orders, with Multiple Demography details Empty Customer Orders, with Multiple Demography details

Post  rajsundar Thu Aug 06, 2009 7:05 pm

Newbie here. I have the following tables in 3NF

The business process identified is Recieve Customer Orders.

Customer(CustomerID...)
Demographics(DemographicID...)
and CustomerDemographics(CustomerID,DemographicID) -- A customer could belong to one or more demography.

Orders(OrderId, CustomerID)..

When I turn this into a dimensional model, how does one flatten the Customer-Demographics data, around the fact table for Orders.

One of the approaches I considered is to create a dimension for each demography and have the FKs in the Order fact table and create this for frequently used demography alone.

How does one solve this generically?

rajsundar

Posts : 4
Join date : 2009-08-06

Back to top Go down

Customer Orders, with Multiple Demography details Empty Re: Customer Orders, with Multiple Demography details

Post  alex.caminals Mon Sep 28, 2009 8:04 am

When an order is created, does it belong to any demographic? If not, you need to ask the business users why they want to report including the demographics. If they are going to build reports with the different orders by demographics, an order may be included in multiple reports if the many-to-many relationship is included in the fact table. Is this what they require?
alex.caminals
alex.caminals

Posts : 15
Join date : 2009-02-25
Age : 46
Location : Barcelona (Spain)

Back to top Go down

Customer Orders, with Multiple Demography details Empty RE: CUSTOMER ORDERS, WITH MULTIPLE DEMOGRAPHY DETAILS

Post  rajsundar Thu Oct 01, 2009 4:29 pm

Yes, indirectly. A customer is part of one or more demographic and an order is placed by the customer. The requirement is to analyze the order/order items by demographic. So an order may be included in multiple demographics.

rajsundar

Posts : 4
Join date : 2009-08-06

Back to top Go down

Customer Orders, with Multiple Demography details Empty Re: Customer Orders, with Multiple Demography details

Post  ngalemmo Thu Oct 01, 2009 4:47 pm

This is generically refered to as multivalued dimensions. Google the term, there is probably something out there that explains how to implement them. Its kind of hard to explain how to do it within the confines of this forum.


Last edited by ngalemmo on Thu Oct 01, 2009 5:39 pm; edited 1 time in total
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Customer Orders, with Multiple Demography details Empty Re: Customer Orders, with Multiple Demography details

Post  ngalemmo Thu Oct 01, 2009 5:20 pm

Start with

http://intelligent-enterprise.informationweek.com/010810/412warehouse1_1.jhtml
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Customer Orders, with Multiple Demography details Empty Re: Customer Orders, with Multiple Demography details

Post  rajsundar Thu Oct 01, 2009 5:42 pm

Thank you for the link.

rajsundar

Posts : 4
Join date : 2009-08-06

Back to top Go down

Customer Orders, with Multiple Demography details Empty Re: Customer Orders, with Multiple Demography details

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum