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

Help on Customer Diomension Design

2 posters

Go down

Help on Customer Diomension Design Empty Help on Customer Diomension Design

Post  iovalles 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 : 44
Location : Dominican Republic

http://www.mardom.com

Back to top Go down

Help on Customer Diomension Design Empty Re: Help on Customer Diomension Design

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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