Data Modeling: Show dimensions side by side

[b2wise]

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?

[b2wise · Accepted solution]

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.

[Anonymous]

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