Currently, i want to create a forecast report. I will explain my situation. Please take a look at below table. I have a part id 'A100' and this part is manufactured in CN currently and will be manufactured in VN from Nov-2018 completely. In this case, i need to create a forecast for CN Factory from Jan-2018 to Oct -2018 and a forecast for VN Factory from Nov- 2018 to Nov-2019. Actually, i don't know how to implement it on Board. Currently, i created on cube with part, original factory, new factory as dimensions, and user will enter the 'apply from' information. i have a idea to make 2 cubes and dataview like second table, then maybe I would be possible user can enter Factory and choose the type, then enter apply from and apply to infor. I'm looking for some ideas and support from all of you. Thank you very much and have a nice day all.
|Part||Original Factory||New Factory||Apply from|