About mwood

mwood · ‎03-09-2022

Hi anaplaners. I am giving my level 1 exam. currently stuck on activity 4 where we need to import data into Sys 08file. for that I have added Region & role to Sys08 module. Step 2: import data into Sys08. (SS 2). for some reason I am not being allowed to manually map - department with department. (source & target) Errors: Expected 2-digit month number in date/period (12 occurrences) ITem not located in E2 Employees# list (am i supposed to update the list here too) Kindly give me ur help ASAP

mwood · ‎01-09-2022

Hi shyam, it just shows the entire list, which is already present in one of the views. I need the filter to show me city wise totals for forecast period for chocolates or any other product category as required.

mwood · ‎01-09-2022

hi, For one of the exercise in the lvl 1 program (i dont re-call may be lsn 13, as I went ahead and completed the rest) I want to prepare for the exam now, so I thought would look into this incomplete work) we were supposed to create a view wherein, the total volumes for chocolates for any city for the forecast period is visible monthly. these are the filter views set for the UX view, no filter under location and line items.

mwood · ‎01-08-2022

Hi Shyam, I am getting all those views as listed by you. My issue is when I want to look only at the forecast period and within that for a particular city. i am not getting the subtotals the month. regards, Malcolm

mwood · ‎01-08-2022

Hi, please find below blue print view of the UX page i am trying to get help on

mwood · ‎01-08-2022

hi Shyam, please check the screenshot, P1 product family has all products as top level item and P2 has p1 product family name in parent hierarchy i hope this is what you were referring too thanks.

mwood · ‎01-08-2022

Hi @bhatjaved Here are the screenshots ,there is no P3 in the example in LV 1 this is P2 rolled up to P1 P1 rolled up to P2 or am i missing something ?

mwood · ‎01-08-2022

Hello All, I am in the process of completing Level 1 training for Anaplan. I have finished all the exercise. however there is one exercise I was not able to complete. that is set up a UX view for Rev02 Volume inputs as required under the exercise. the View has been created but I am not able to get totals for the columns (monthly totals). I tried almost everything. Under Data > Totals Positions>After. please let me know what options should i look at to resolve this. thanks Screen Shot attached

mwood · ‎10-01-2021

Hi Misbah, Yes may be. i have done the same. waiting for a response.

mwood · ‎10-01-2021

HI Misbah, I do agree its not a good practise to write manually but in this case after trying several times, i tried the manual option. Please note in Rev 01 Price book, only 'Unit Cost' is mentioned so the additional "S" is not working in this case. the error i am getting is Unit Cost Growth % is not recognized line item or list member

mwood · ‎09-30-2021

Hi I am on learning level 1 activity 9.2.6 of Anaplan. I am struggling to insert the right formula for cost of sales formula as per training module is : Cost of Sales 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %) All the other formulas are working well. I also tried to write the formula manually, alas it gives me the same error message. i.e Unit cost growth % is not a recognized item or list member. Need help on this plz. attached are the screen shots

About mwood

Level 1 Exam activity 4

Re: Totals for Columns

Re: Totals for Columns

Re: Totals for Columns

Re: Totals for Columns

Re: Totals for Columns

Re: Totals for Columns

Totals for Columns

Re: Level 1 Activity 9.2.6 add formula to Margin c...

Re: Level 1 Activity 9.2.6 add formula to Margin c...

Level 1 Activity 9.2.6 add formula to Margin calcu...

Re: Level 1 Model Building Exam - Model Building A...