Modelling inventory quantities - fact or dimension

Inventory Fact Table: How to load it?

Hi all, I need to load a huge inventory fact snapshot table. My source table is not tracking changes, but I need to be carefully loading only changed row to fact table because this is a huge fact table. What is the best method to track changes between

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

Dimension same size as Fact

I have a fact table designed to hold catalog information where the grain is defined as one row = one catalog item fact by warehouse by warehouse location in order to show warehouse inventories. One item may be in multiple warehouses, and in each the item

Dimensional modelling

I have created a dimensional model for inventory of products. I have added quantity on hand in fact table, what else can be useful for strategic information analysis? It is a periodic snapshot fact table.

Complex Inventory Model

I am designing an inventory model with dimensions: Product, Location, Time, and Collection Type. The relationships here are: 1. A Location is assigned Items that they can only have in stock 2. A Collection is assigned Items. 3. A Location is assigne

Modelling Dimension relations over time

Hi, We are planning to model a star schema based data warehouse with the following challenges: 1- The fact table is dimensioned across sales rep postion (a logical designation), geography, product, sales and atime 2- The sales reps have different

Inventory Model

I work in manufacturing, and we would like to be able to report on current inventory levels and current shipments of finished goods for the month. I can see declaring the grain at tag level saying a fact row is created when a tag is created, or the

Some Practical Challenges

Hi All I am facing some challenges in my dimensional modeling and most of these are covered in many books too.But i have practical limitation for that 1st Challenge :Unbalanced Hierarchy In one of the dimension we are tracking employees and their

2 fact at different granuality demanding different level of a dimension hierarchy.

Hi, Here is what i am trying to design. There is a transaction level fact table say Fact1.. One of the dimensions for this fact table is Dim1, which has hierarchy as L1>L1>R1.. leaf to root. The Leaf node (L1) of the dimension is Foreign key in the

Health Care Dimensional Modelling

Hi, I am working on Health care project to do data modeling to create either star or snow flake schema. Here is my table list Dimensions Tables: Patient, Provider, Medication, vaccination, procedure, observation, diagnosis and lab results(These are just

Inventory Checked! Items Found! GREAT DEALS!

So we've been working extra hard the past few days and did a full inventory scan... AND found some great items to sell for CHEAP! Please call us (888)-310-2247 extension 111 I will be taking orders over the phone only so we can get them out immediately

Skyrim

OKAY Day one: GENERAL: Made a male Imperial The customisation options are cool, and you can finally make a character who doesn't look like he's from, well, Oblivion. The most immediate improvement over Oblivion is, of course, the graphics. However,

10 Random Unknown Facts

Lets all get to know each other a little better! Write ten facts about yourself that others probably don't know, and lets get to know the person BEHIND the YouTube name! 1. Im very insecure about myself in real life. Whenever I appear confident it is