Forum Discussion
Custom Item Hierarchy
Having trouble with the Node Keys and Parent Keys. My data set is essentially a bill of materials. I have one item that is composed of another item which is composed of another (3 levels total). These are broken down into item numbers.
I created my Path column fine, and my hierarchy depth column worked as well. But when I went to use the code to create my level columns, I used the following code and got an error. Any ideas? Thanks in advance.
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?