Forum Discussion
Custom Item Hierarchy
All, I am stuck on a project I'm working on. What I am trying to do is create a custom hierarchy for items and am not sure how to model the data. I am currently setting up my table to look l...
Yeah that makes sense. To give a few more details on my tables:
ITEM_DIM:
- item #
- item description
- item class
- item subclass
- product group
- product code
ITEM_HIERARCHY:
- item #
- parent item #
- isleaf
- hierarchy path
- hierarchy depth
- level 1
- level 2
- level 3
ITEM_FACT
- qty on hand
- qty on order
- qty on work order
- qty committed
- next month forecast
So I would join my ITEM_DIM table to the HIERARCHY table on the item #. Then, I would join the HIERARCHY table to my FACT table through the same item #. Does that sound correct?
abergman -
Sound about right.