Line items with list dimension - Importing data and design of model
I am modeling our warehouse operations and it has a bunch of line items and "categories" as follows:
The line items I have are Operation1, Op2, and so on.
For each line item, they are either a function that is "Inbound"/"Outbound" and belong to "Direct Labor" or "Indirect Labor". These categories go into tracking KPIs eventually.
Each line item also has associated measures like Volume, # of headcount on that operation, throughput and so on.
I have modeled the above as follows:
Module with line items as above.
List dimension that has measures like: Volume, headcount, etc; and "Applies To" all line items
Any ideas on how to model the "categories" and also, how to import the data into the module (I ignored categories for now, and am stuck on how to import it as the columns are three in number for each Date/Time dimension as seen in the data table I have posted)
Please guide on how to model this, and how to import.