Calculated dimension attributes based on fact

View previous topic View next topic Go down

Calculated dimension attributes based on fact

Post  suds.kumar on Tue Dec 11, 2012 7:33 am

Hi,

I have a requirement to have an attribute "Date of Last Purchase" in the Customer Dimension in a simple retail schema where we have Customer dimension (Type-4) and Sales fact. Obviously the attribute "Date of Last Purchase" changes when the customer makes a purchase. I have curently designed it in this way -
1. I have current customer dimension and historical customer dimension (Type-4)
2. "Date of Last Purchase" is an attribute of the current customer dimension and is updated based on incremental sales fact records.

Not going into Type-2/Type-4 reasoning behind the design, I would like to get opinion about if this design is correct where we require calculated dimension attributes based on fact records? How else columns like "Date of Last ...." can be computed? If we do at the report level, then everytime it will scan on-the-fly the whole fact table to get the results.

Thanks

suds.kumar

Posts : 1
Join date : 2012-12-11

View user profile

Back to top Go down

Re: Calculated dimension attributes based on fact

Post  BoxesAndLines on Tue Dec 11, 2012 10:12 am

So you have a type 2 and a type 1 customer dimensions and together that is called a type 4? I'm confused. Putting the date in a type 1 customer dimension is what I would strive to do. I would not want the massive history generated by a type 2. Alternatively, you can create a type 2 dimension and just not track history for the last purchase date. Either solution is acceptable.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Calculated dimension attributes based on fact

Post  ngalemmo on Tue Dec 11, 2012 3:34 pm

I'm lost after three.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Calculated dimension attributes based on fact

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