How to Model Store-specific Product attributes

jjplet at 18h13
15
Apr
2011
How to Model Store-specific Product attributes

Hello -

I'm trying to determine the best way to model Store specific product attributes and need a second (or third) opinion. Here's the deal...

Pretty straightforward retail scenario - Products are sold thru stores. Most Products are sold in all stores, though some products are unique to certain stores. There are about 100,000 products total (all stores), and there are about 20 stores. Most product attribut

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Clients with different attributes that are not all the same
I have been given the project of building a master client database. I work in a financial environment where we client/product/account information. For some types of client they have specific information related just to them, unique identifier, name, but
Store the tax rate as the attribute of product in product dimension table?
Hi All, This is my first post, so hi and nice to meet you all. My Business Requirement: client wants the amounts of sale tax. And client offers the list the tax rate for certain product categories, for the rest, no tax rate. My question would be:
Customer Dimension
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
Model for storing dimension attributes in multiple languages
We have a traditional dimensional model and are about to add multiple languages to our source systems and need the option of reporting certain dimensional attributes in either the local language or English. Has anyone developed a flexible model for this
How to model Product Bundles
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
Forums from same category
See also
more_less
Informations

5 Replies For the topic :
"How to Model Store-specific Product attributes"

This topic has been viewed 968 times.

Last message :
15/04/2011 at 18h13 by "jjplet"