SCD Required if Dimension Attributes in Transaction?

View previous topic View next topic Go down

SCD Required if Dimension Attributes in Transaction?

Post  chewza on Tue Oct 22, 2013 9:06 pm

Hi there

I have a situation where we have a few of the key customer attributes actually captures on the sales order.
So what happens is that when an order is raised, the sales clerk types in the customer number. The screen will then generate show the default sales rep, and default sales group. The sales clerk can then override this - and this happens fairly frequently.

The business is only really interested in analysing the data by the sales person/division as captured on the invoices - not the standard default values.

The approach I am intending is as follows:
Have a customer dimension - obviously show customer code, address etc, and then also have fileds labelled "default sales person", and "default division"
Have a separate dimension for sales rep
Have a separate dimension for sales division[/list]

This will then allow users to produce reports based on classifications as per the invoiced transaction, rather than current master data. I do not believe the classic SCD type 2 approach is required since:
The change in dimensions values in presented to us in the transaction line, and we do not need to determine this by comparing our dimension table (from yesterday) to current master data, and inserting rows to track changes as per classic SCD type 2 approach?

Any thoughts?

Regards
Chrs

chewza

Posts : 1
Join date : 2013-10-22

View user profile

Back to top Go down

Re: SCD Required if Dimension Attributes in Transaction?

Post  ngalemmo on Wed Oct 23, 2013 2:51 pm

The type of change you are tracking is not handled by a type 2 anyway. Your solution to track the assigned sales rep/division is correct. It is an explicit assignment relating to the order and should be carried as an independent dimension.
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