Forum Discussion
Data Modeling: Show dimensions side by side
Hi all,
I need to make a report for our warehouse which will show the item in a given location along with the item and location dimensions.
| Location | Location Height | Location Width | Location Length | Item | Item Qty | Item Height | Item Width | Item Length |
| h034567 | 1 | 1.5 | 1 | 999-abc | 3 | 0.25 | 1 | 0.25 |
The report itself is pretty simple I just don't know how to model my data so I can show all these values in one table. The problem is that all the values sit in different tables.
The fact table for item qty and current location is called PACKAGES.
Location height, width, and length, are in BoxTypes which is a parent to LOCATION.
Item height, width, and length, are PARTDIM which has a many to one relationship with PARTATTR which is the item master table.
Relationship fields are in green, other needed fields are in yellow.
How do I do this?
I think the answer is to consolidate, i.e. flatten, dimension tables so the schema is star and not snowflake. Basically if a dimension table has a parent table there probably is a way to combine them to simplify the schema.
2 Replies
Hi b2wise ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I think the answer is to consolidate, i.e. flatten, dimension tables so the schema is star and not snowflake. Basically if a dimension table has a parent table there probably is a way to combine them to simplify the schema.
