Level 1 - Importing Data into Product Details and Employee Details modules

I am hitting errors when importing data into both modules for product details and employee details. I am not sure if I am mapping it correctly or if I have created the modules / dimensions correctly in the first place. When I look at the exaple Model, my modules look different to the modules in the example model - I have attached screenshots of my working model and the example model. Appreciate any guidnce on this. Thanks. 

 

Answers

  • I think the structure of your module is okay, if you pivot it around you should get a view which is similar to the example.

     

    When you import the data are you mapping on the Product Code, and Employee Code, and not the names. If I recall these lists are numbered lists so you should be using the codes when importing as this is what uniquely identifies the records.