AnsweredAssumed Answered

Need support for normalize data

Question asked by william.le on Mar 23, 2018
Latest reply on Mar 27, 2018 by breuber

Dear All,

 

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.

 

PartOriginal FactoryNew FactoryApply from
A100CNVNNov-18
A101HKVNOct-18

 

PartFactoryTypeFromTo
A100CNOriginalJan-2018Oct-2018
A100VNNewNov-2018Dec-2019

Outcomes