Arvin discussed on how to add new store from JDA to pentaho this reflects the store details in the reports to be generated in Pentaho Inventory/Sales reports Gap Zalora - 9829 BR Zalora - 9828. He showed me how to get the data from JDA and input it to gap_dm database under location_dim table Input the following details for SQLyog -location_id, location_name, location_type and short_name Data need from JDA -STRNUM,STRNAM,STRTYP,STSHRT He let me shadow on doing the step by step procedure explaining how to do this kind of request from the stakeholder.