About rmat066sysf

rmat066sysf

Hi Im unable to upload Model history for Supply Chain Model although Ive completed the Conclusion Exam. Is there anything missing/undone to be able to activate the link to upload the Model history file.

rmat066sysf

Hi Thank for your response. Agreed. Checked the beginning inventory formula and it is good. Cheers

rmat066sysf

Hi My Capacity % numbers look weird, Am I missing something when calculating the beginning inventory. Pls refer to img. Appreciate your help. Thanks

rmat066sysf

Thank you. It worked. Cheers

rmat066sysf

Hi Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls The formula for 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' is invalid: 'Shipping Time (Weeks)' = YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)' [LOOKUP: 'SYS01 Time Settings By Week'.Current Period?] Thanks in advance for your help and guidance. Lookup Ref: Source Target DAT02 Map TRA01 P2 Products Ok P2 Products Ship Methods Ok Ship Methods Year Lookup SYS01 Week

rmat066sysf

Hi Vignesh Im trying to create a system module to identify years of the week as suggested with formula period(start()) but it gives an error. Appreciate your help Thanks

rmat066sysf

Thank you

rmat066sysf

Looking for an opinion Is it best practice(DISCO) to have the following in a single module or is it preferred to have it in separate modules DEM01 & DEM02: Line 1 : Growth % by Month ( time set to month) Line 2: Growth % by Week ( time set to week) Thanks

rmat066sysf

Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast Year',-52,0) Appreciate your help. Thanks in advance The formula for 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' is invalid: 'Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast Year',-52,0)

rmat066sysf

IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 IF Employed? THEN 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 Hi Misbah changed format to list:Role in SYS08 Attached are the screen shots of blueprint view, and the formula's that returns an error. Appreciate your help. Thanks

rmat066sysf

Hi Misbah SYS08 Data is imported from a emplee detail by role txt file that has Role populated, so the format cannot be a list:Role...i guess.

rmat066sysf

Thanks, that the screen shot of my formula. Thanks for your help, still get the same error.

rmat066sysf

Hi Pls can you help : ----------------------------------------------------------------------------------------------------------------------------------------------------- The formula for 'EMP02 Employee Expenses By Dept & Role'.Bonus is invalid: Bonus = IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 'EMP03 Employee Drivers by Role'.Bonus % is not a recognized line item or list member ----------------------------------------------------------------------------------------------------------------------------------- Is it something to do with the data type? if so is it in SYS08 or EMP03. Appreciate your help. Regards Richard

rmat066sysf

Hi Im having the same issue, can you elaborate on the which module "Data Type was incorrect" pls. Regards Your Ref: Thank you, my lookups are working now, brilliant, my data type was incorrect.

Online Status	Offline
Date Last Visited	yesterday

About rmat066sysf

Unable to upload Model history for Supply Chain Mo...

Re: INV04 Distribution Center Capacity

INV04 Distribution Center Capacity

Re: Model Builder 2/- TRA01 Shipping Time in Weeks

Model Builder 2/- TRA01 Shipping Time in Weeks

Re: Data import of different Dimension

Re: L2 Supply Chain Model DEM01 & DEM02

L2 Supply Chain Model DEM01 & DEM02

Update Historic Volumes for Baseline Forecast

Re: Formula Error

Re: Formula Error

Re: Formula Error

Formula Error

Re: Level 1 Model : Dimension of mapping used for ...

Re: INV04 Distribution Center Capacity

Re: Model Builder 2/- TRA01 Shipping Time in Weeks

Re: Formula Error