Customer Orders, with Multiple Demography details

View previous topic View next topic Go down

Customer Orders, with Multiple Demography details

Post  rajsundar on 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

View user profile

Back to top Go down

Re: Customer Orders, with Multiple Demography details

Post  alex.caminals on 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?
avatar
alex.caminals

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

View user profile

Back to top Go down

RE: CUSTOMER ORDERS, WITH MULTIPLE DEMOGRAPHY DETAILS

Post  rajsundar on 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

View user profile

Back to top Go down

Re: Customer Orders, with Multiple Demography details

Post  ngalemmo on 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
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Customer Orders, with Multiple Demography details

Post  ngalemmo on Thu Oct 01, 2009 5:20 pm

Start with

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

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

View user profile http://aginity.com

Back to top Go down

Re: Customer Orders, with Multiple Demography details

Post  rajsundar on Thu Oct 01, 2009 5:42 pm

Thank you for the link.

rajsundar

Posts : 4
Join date : 2009-08-06

View user profile

Back to top Go down

Re: Customer Orders, with Multiple Demography details

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