Forum Discussion
Custom Item Hierarchy
Resident Rockstarabergman -
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.
- ChrisMendoza
abergman -
Sound like in your project you'll end up with three tables: [Hierarchy Structure_DIM], [ITEM_DIM], & [ITEM_FACT].
In my implementation, as an example, I have [ORG_STRUCTURE], [EMPLOYEE], & [PAYROLL_FACT_DATA].
Ah, I see. So in my ITEM_STRUCTURE table, I would just have Level 1, Level 2, and Level 3, and the other associated measures and columns used in the article, and that's it? How would I join that hierarchy table to my ITEM_DIM table and my ITEM_FACT table?
- ChrisMendoza
abergman -
abergman wrote:Ah, I see. So in my ITEM_STRUCTURE table, I would just have Level 1, Level 2, and Level 3, and the other associated measures and columns used in the article, and that's it?
This is how I implemented in my project. Hard to say if similar would work for you.
abergman wrote:How would I join that hierarchy table to my ITEM_DIM table and my ITEM_FACT table?
Likely, again without knowing your details, ITEM_DIM > ITEM_STRUCTURE > ITEM_FACT.