DanColbert at 19h18
19
May
2009
How to model Product Bundles
The situation:
Wholesale sales business process
The situation:
Wholesale sales business process
- SKU1 and SKU2 can each be sold separately.
- SKU3 can also be sold separately but is a kit of SKU1 and SKU2.
- We need to calculate royalties for each unit we sell of SKU1 and SKU2.
- SKU1 has two royalty payments. (two different licensors)
- 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
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
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"






