Help on Customer Diomension Design

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.

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.