Need support for normalize data

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.

Part	Original Factory	New Factory	Apply from
A100	CN	VN	Nov-18
A101	HK	VN	Oct-18

Part	Factory	Type	From	To
A100	CN	Original	Jan-2018	Oct-2018
A100	VN	New	Nov-2018	Dec-2019

Find more posts tagged with

Accepted answers

All comments

Björn Reuber

Hi,

do you need this only for reporting, or also for some calculations (cause the user are planing on Part Nr and you want to move this to factory)?

Regards

Björn

William Le

Hi Björn Reuber,

Thank you very much. I need to move it to factory, because i want to make a forecast for each factory, not for each Part Nr. I hope that will be possible to implement it on Board. But maybe we will have an issue is the relationship between Part Nr and Factory is n:m. Thank you very much.

Thanks and best regards

Minh Le

Björn Reuber

Hi William Le

you can use the idea from the article Dimension as a Stand Alone Entity and/or Hierarchy.

So you have "current Factory" (same as Salesman in Article) and "Factory" (same as Historical Salesman).

You can create a cube on Article, Month and Factory to assign which Article is create in which Factory at a common time.

It contains a 1 if a Artice is produced from a factory in a month (whole production) or maybe 2 times a 0.5 if 2 factorys are producing an Article.

Furthermore you're doing the Forecast DataEntry only on Article and Month level. So you can multply both Cubes and get the Result

I hope my example is clear, otherwise I could create a small application.

Regards

Björn