Item Costs - Dimension or Fact

lmetodiev at 14h29
20
Feb
2009
Item Costs - Dimension or Fact

For each item we have a few different cost types - frozen, standard, pending,...
In each pair (item,cost type) there are different cost buckets - material cost, material overhead, labour cost, overheads, outside operation costs, etc.
Some of the cost types are updated monthly, some yearly.
It is very hard to me to determine whetrher item costs and item costs per bucket are dimensions or facts.
I appreciate any suggestions abo

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
Transaction fact table and Transaction line item fact table
Hello, i am building a data warehouse for an ecommerce shop. My first idea was to follow the best practices to make a fact table on line item level. But my boss doesn't want the costs for coupons, vouchers, etc allocated on item level. That is why I
Insured item
I support multiple insurance products e.g. home and motor. I have a policy holder dimension and an insured item dimension. A fact table records The insured item could be a house or a car. What's best practice for storing textual attributes? Should
Order Dimension and Order Fact
Hello All, I am creating a model. In the data mart/warehouse, I have the fact tables, Orders and OrderItem (transaction). In my model, I have used the Orders table as both a fact and dimension...to satisfy how the users see the data relationally. In
Cost plans for projects - One fact table or several fact tables?
Hi, I'm currently struggling with my Dimensional Model. It is about projects with their related cost plans. Every project starts with an initial cost plan (called WIPL), the project is saved as version 0 and the WIPL attribute and the ACTUAL attribute i
Item Master and Inventory Organisation
In Oracle eBusiness Suite there is an Item Master on Instance Level. Each item can be attached to each inventory organisation and each item attribute from item master can be overwritten on inventory organisation level. For different purposes can be used
Forums from same category
See also
more_less
Informations

12 Replies For the topic :
"Item Costs - Dimension or Fact"

This topic has been viewed 2275 times.

Last message :
20/02/2009 at 14h29 by "lmetodiev"