About Younes

Younes · ‎06-08-2020

HI @einas.ibrahim Well i chose to map manually Mumbai to Bombay. In a real life situation, i would have asked the client to clarify if its normal or not.

Younes · ‎06-08-2020

Hello @filip.sypniewski Thnaks for sharing your knowledge. I am trying to upload data in OTH01 module of the FP&A model from INV05 in the supply chain model. Every thing looks perfect. I juste have a problem when matching the location. As you can see in the source module i have Mumbai as location while in the target module i have Bombay. Is it normal ? What module should i update ? The training says that i shoudn't have any item ignored. Any help ? Thanks Younes

Younes · ‎06-08-2020

Hello, I am trying to upload data in OTH01 module of the FP&A model from INV05 in the supply chain model. Every thing looks perfect. I juste have a problem when matching the location. As you can see in the source module i have Mumbai as location while in the target module i have Bombay. Is it normal ? What module should i update ? The training says that i shoudn't have any item ignored. Thank you for your help Younes

Younes · ‎06-08-2020

@Misbah DO you mean i need to update it from the data hub ? Or download a new csv file ?

Younes · ‎06-07-2020

Hello, My INV01 module works perfectly well and matches the training screen shots. I am juste facing an issue when trying to upload the weekly + Order + Schedule to answer a question. When i try to import i have a problem : Anaplan says that some P3 SKU are not found in the list. When i check the mapping i find those SKU's : The import doesn't work so i can't answer the question. Any help ? Is it normal that Csv file includes SKU's that are not in the module. Younes

Younes · ‎06-06-2020

I think your formula is correct. The system does the agregation to sum the stock exception count on SKU and get them on product because of the hierarchy. I think your first formula is correct. Younes

Younes · ‎06-06-2020

Hello @einas.ibrahim Thank you for help and contributions. This is how i transformed the formula : 'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country] based on your note. Younes

Younes · ‎06-06-2020

Hello @VIGNESH.M @Donna Marie I tried this formula : 'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country, SUM: 'SYS08 SKU Details'.Product Family]. But i don't understand. Normaly INV01 does'nt have geography as dimension, so the data displayed at INV01 (source module) is at All Region Level, while INV02 (target) is at country level. So normally, the maaping is used with a LOOKUP and not a SUM. When i try to do it with a lookup, the system says that there is a mapping error. Could you help me ? Thanks Younes

Younes · ‎06-05-2020

Hello, I am having issues calculating the shipping costs. I thought that my formula wasn't working but it's working perfectly . You can check with SHipping cost per 1000 that the value is correcly imported (65). Then when i multuply this amount by Final shipping amount 8149 i get 532610 ijnstead of 529685 like presented in the course exemple (i didn't divide by 1000 yet but that's not the problem here). It's driving me crazy and i still can find where is the mistake. The formula is very a very simple multiplication. Could you please help me please ?

Younes · ‎06-05-2020

Tanks a lot @Misbah , that is extremely helpful !

Younes · ‎06-05-2020

Hello @einas.ibrahim @Misbah Thank you for your help. I'd like to understand more the formula. How does Anaplan know with this formula that we are talking about the Time scale whe writing OFFSET(1,-1,0) ? Younes

Younes · ‎06-04-2020

Hello, I used the "NOT INPERIOD(CURRENTPERIODSTART())" formula to calculate to determine if it's the first week of the time scale or not and it's working. But i know that if we change the current period my formula doesn't not work anymore. I couldn't find a formula that targets the start of time scale and not the current period. Could you help me ? @einas.ibrahim Thank you Younes

Younes · ‎06-04-2020

Hello @einas.ibrahim Thnak you for your insights, they are always helpful. Concerning this topic i have a question. I used the "NOT INPERIOD(CURRENTPERIODSTART())" formula and it's working. But i know that if we change the current period my formula doesn't not work anymore. I couldn't find a formula that targets the start of time scale and not the current period. Could you help me ?

Younes · ‎06-04-2020

Hello @davidmccarty , That's it. That's what explains my problem. Thank you Younes

Younes · ‎06-03-2020

Hello everyone, On my dashboards, i can't find the edit button so i can edit my dashboards as you can see below. Has any one faced this issue ? Thanks a lot Younes

Younes · ‎06-03-2020

Hello @davidmccarty @Misbah Thanks for sharing your issue. I have an issue that i see resolved in your screenshots. In fact i can't display the grid like you. I have first initial demand for all months of the year then final demand for all the months of the year as shown below : Could you telle me how did you dio it Thanks a lot Younes

Younes · ‎06-03-2020

@Tiffany.Rice Thanks a lot Tiffany, that exactly it. I changed and it works perfectly 🙂

Younes · ‎06-03-2020

Hello @Misbah , Thnaks for your insights. I am facing some issues since the data in the dashboards doesn't match with example. My DEM03 looks like the example (data matches) : That means my formulas worked well for calculating the forecasts. But when i try to look for the result for All Account, All SKU the result is different from that is displayed in the dashboard : So naturally my dashboard is wrong. Could you help me please ? It's like the aggregation is not working correctly Younes

Younes · ‎06-03-2020

Hello @Sorna Raja Prabhu Thnaks for you response. It's already my format :

Younes · ‎06-03-2020

Hello I have a format problem in this module. Instead of having 58.88 for example like @Lkishko , i have 5,887,728... like shown below : Insted of having this format : Any help ? Thanks Younes

Younes · ‎06-03-2020

Hello @Tiffany.Rice Thanks for you help. I am at the same level of the trainig and i have a format problem in this module. Instead of having 58.88 for example like @Lkishko , i have 5,887,728... like shown below : Can you tell me how to fix it ? Thanks

Younes · ‎06-03-2020

Hello Misbah, Thanks a lot, that was the problem. I corrected it and it worked !

Younes · ‎06-03-2020

Hello, I have a problem when importing percentages from a CSV file into the DEM01 Volume Growth. In fact after importing, it looks like all the percentages from the CSV file have been multiplied by 100. Any one has faced this issue ? This is my number format configuration. I tried ti change it but it didn't have any impact :

Younes · ‎06-03-2020

There is a hook missing before the Lookup. This is the right formula.

Younes · ‎05-29-2020

Hello, I had the same problem. I corrected it by changing the type of Role in the SYS08 module to List. Before doing this you shoud, delete the formulas where you're referencing SYS08.Role and recreate them after changing the type, unless you won't be able to change the type.