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...
abergman -
My guess is you have duplicate values in [SHORT_ITEM_NUMBER]. You should have two tables; one is the structure of the hierarchy and the other is your fact table. Possibly you can share your file?
Currently, I have an ITEM_DIM table, and an ITEM_FACT table. My hierarchy was created within my fact table. Should I have made it in my dimension table? My dimension table just has information like item description, etc.