Modeling Descriptive Flex Fields (Attribute Columns) on an Order Line

kkgronemeier at 19h24
15
Feb
2011
Modeling Descriptive Flex Fields (Attribute Columns) on an Order Line

For an order line that contains 15 generic attribute columns, how would one model all the miscellaneous data elements (i.e Vendor SKU, Customer Part Number, RMA Product Condition, etc) to make it available to end users as part of the order fact table?

While some of the attributes contain discrete data, when comparing all fifteen attributes as a group on a line by line basis 75% of the data is unique.

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 : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Order Header fact and multiple payment methods
I need some help in designing this particular situation. Here are some details: 1)The grain is one row per order 2)Each order can have multiple payment methods ex: cash,credit card,customer account,due bill,gift card 3)A combination of payments is
SCD 2 Audit / Metadata Columns
What are the standard audit columns / meta data columns that you will create in a SCD 2 Dimension table. potentially we will get more than one data feed from the same vendor for any given day and we need to track the versions / historical changes to
Model for these charges
How would I model the following order system? Base Daily 4 x $50 | $200 Extra Hourly 5 x $25 | $125 Extra Weekly 3 x $300 | $900 Discount A | -$20 Discount B Percentage 5% of base @ $200 = -$10 Extra Option Z | $600 Extra Option Q | $100 Tax |
Modeling help on dimension with many boolean value
Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of
What to do when a single attribute rolls up to multiple categories?
I'm working with healthcare claims data, and developing a new data warehouse. A single pharmacy claim line will have a drug identifier called a NDC (national drug code). A single NDC may belong to one or more drug categories. Given the one-to-many
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Modeling Descriptive Flex Fields (Attribute Columns) on an Order Line"

This topic has been viewed 1111 times.

Last message :
15/02/2011 at 19h24 by "kkgronemeier"