Help on Customer Diomension Design

View previous topic View next topic Go down

Help on Customer Diomension Design

Post  iovalles on Mon May 17, 2010 11:39 am

Hi guys,

I need help on this business case:

We have a "Customer" table in the staging area, containing a "sales executive" attribute. The thing is that one Customer can be visited by many sales executives working for the same company, offering the same type of service, but under different brands.

The fact table could look like this:

Shipment N#
Customer FK
Total Units Sold
...

and the propposed Customer dimension could be:

Customer ID
Customer name
Customer Sales Exec. brand A
Customer Sales Exec. brand B
Customer Sales Exec. brand C
...

The data should be queried by brand and also by sales executive. We have a short number of brands (actually only three) but I'm wondering if this is a good approach for the Customer dimension design? I see some redundancy.

iovalles

Posts : 2
Join date : 2010-02-11
Age : 39
Location : Dominican Republic

View user profile http://www.mardom.com

Back to top Go down

Re: Help on Customer Diomension Design

Post  ngalemmo on Mon May 17, 2010 12:14 pm

I would make sales executive a dimension and reference it from the fact.

If you need to know which sales executives are assigned to a customer, you can have another factless fact table with customer, brand, sales executive and effective dates as dimensions.
avatar
ngalemmo

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

View user profile http://aginity.com

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