How to model Product Bundles

DanColbert at 19h18
19
May
2009
How to model Product Bundles

The situation:
Wholesale sales business process
  1. SKU1 and SKU2 can each be sold separately.
  2. SKU3 can also be sold separately but is a kit of SKU1 and SKU2.
  3. We need to calculate royalties for each unit we sell of SKU1 and SKU2.
  4. SKU1 has two royalty payments. (two different licensors)
  5. SKU2 has one royalty payment. (to a third licensor)
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hi, I have a Product dimension table which I need to populate. There are 2 columns in this dimension 'Product Code' and 'Product Description'. The Product Code comes from a concatenation of 2 columns from my staging table (which forms the business
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship
Looking for Remington Model #29 shotgun. Not real common, the 4-5 I've seen were rough shape. Would like to find one decent shape and price, no polychokes or recoil pads.
I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model. I have made the papers available on my
http://www.cse.lk/cmt/upload_report_file/670_1296617668150.pdf
Forums from same category
See also
more_less
Informations

8 Replies For the topic :
"How to model Product Bundles"

This topic has been viewed 2838 times.

Last message :
19/05/2009 at 19h18 by "DanColbert"