About filip.sypniewski

filip.sypniewski

Hi @y_wang77, that is very weird, I do not recall having any troubles with copy pasting the formula. Worst case scenario you would need to write it... Regarding second part of your post. It's a bit tricky actually, and I was not happy about it as well. Therefore, it is important to check during Level 2 that you use exactly the same names of line items for example. The instructions specifically ask you to follow naming conventions as given to you.

filip.sypniewski

Hi @Star, I had similar issue during Level 2. Academy Team solved it very quickly for me, please contact them at academy@anaplan.com

filip.sypniewski

Yes! Then in one package also when line item is used as a Read/Write driver for Dynamic Cell Access.

filip.sypniewski

Hi @gregtan, check out this thread, you should find a solution: https://community.anaplan.com/t5/Anaplan-Platform/Publishing-List-as-Page-Selector-Without-Parent-Levels/td-p/41165 Let me know if you have other questions!

filip.sypniewski

Hi @Sravan_Kumar. I think the New UX course will answer all your questions, check it out: https://learning.anaplan.com/course/view.php?id=949

filip.sypniewski

Hi @Tsuyoshi_Inoue, do you get this error every time you try to write your formula? I would expect that this was caused due to the restore action performed by someone else in the meantime. Anyway, your syntax is also not correct, should be SUM: XX, LOOKUP: XX. However, as a part of best practices, it is not recommended to combine this two functions together. Check out this short class: https://community.anaplan.com/t5/On-Demand-Courses/Compound-Functions-SUM-LOOKUP-SELECT/ta-p/63715

filip.sypniewski

If I recall there was one importing activity in the last sprint of the training.

filip.sypniewski

Hi @satyamarora85, you can archive Data Hub and only change the mode when you need it at some point of the training. Afterwards, you can archive your Data Hub again. Good luck!

filip.sypniewski

@chrised209 You can post your idea on Idea Exchange! https://community.anaplan.com/t5/Idea-Exchange/idb-p/AnaplanIdeas

filip.sypniewski

I am sure it is due to the file that you are importing. See my other post in this thread that I just published. When I download the file I do not see "#E2 Employee" as a second column. I think it's the same case for David.

filip.sypniewski

@chrised209 I understand your point. I am pretty sure that I followed a video once in which import into modules was explained in details. I cannot find it at this moment, but maybe @ChrisMullen will identify it quickly. I think you are free to share also your feedback with Academy team and help make the courses better for everyone! In the file that I just downloaded from Level 1 course and tried to load in to my list, I did however not see the second column "#E2 Employee". Can you check that and download the file again? Indeed it might be misleading for you. I can see Column 2 being a Code. At this moment, sharing the article in which import into modules with numbered list is also explained, but I will get back if I find corresponding video. https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Lists_and_Roll-ups/Numbered_Lists/Working_with_Numbered_Lists.html#Import%20Module

filip.sypniewski

@chrised209 I compared your screenshots with my Level 1 model and indeed it looks exactly the same. The only differences I noticed are following: I can see Code in Column 2, Active? in Column 9, as well as my codes are 001 instead of 1. Though, these of course do not make any difference. Let me know if you have other questions!

filip.sypniewski

@davidmccarty @chrised209 It would be indeed not feasible to map thousands of items manually. That's why we are using Codes in Anaplan, they are particularly important while working with numbered lists, for example in a case like this. If you built up your #E2 Employees list correctly, it should have Code for each employee. 1. On Mapping Tab, you need to choose column with 'Code' from source files. 2. Then on #E2 Employees tab, you select match on names or codes and... done. All elements of your list (employees) are mapped automatically. Useful lessons on this topic below: https://community.anaplan.com/t5/On-Demand-Courses/Manually-Import-Data-to-a-List/ta-p/64043 https://community.anaplan.com/t5/On-Demand-Courses/Introduction-to-Numbered-Lists/ta-p/63913 https://community.anaplan.com/t5/On-Demand-Courses/Introduction-to-List-Codes/ta-p/63916

filip.sypniewski

Hi @Donna Marie, Monthvalue formula is pretty easy, you can find all information here https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/MONTHVALUE.html I am not completely sure about the rest of you questions, what exactly you would like to filter?

filip.sypniewski

Hi @davidmccarty, I can see in my Level 1 model, that I have 'Name' loaded together with other information. Maybe you could review your import into SYS08 and check the mapping? This is available in the file provided so you should be able to load it. Let me know if you have any additional questions!

filip.sypniewski

Hi @xrprasadx, 1. First, you need to update List of territories and afterwards System module with Territory list. 2. It's just an information for you at this point, that you do not need to do anything manually, just build the process. In User Story 2.5 you will be provided with a file to load the data. You can also find more Q&A for this Sprint in this thread https://community.anaplan.com/t5/Level-3-Course-Forum/Designating-Sales-Reps-to-Accounts-Process-Questions/td-p/59347

filip.sypniewski

It is new Supply Chain model, however you will also need to make a connection between two models.

filip.sypniewski

Hi @satyamarora85, I just checked the model I built last year. It has 515 MB. Good luck with your level 2!

filip.sypniewski

@Sravan_Kumar Ah sorry, you meant Source Models on the panel, now I understand. You will find there different Models from which you imported data into your model. Indeed, Data Hub model is good example. You will often find your Data Hub model on the list. It will appear once you make a connection e.g. import your hierarchies or data from Data Hub. Please try to make an import and you will see! Does it solve your question? Please let me know 🙂

filip.sypniewski

Hi @Sravan_Kumar, what exactly do you mean? You source module can be for example module in which you store loaded Data, it will be your source for your Calculations, Output... You build modules based on your needs. Check out this great article about module desgin: https://community.anaplan.com/t5/Best-Practices/Best-Practices-for-Module-Design/ta-p/35993

filip.sypniewski

Hi @Olli, I think you should base your calculation in INV05 based on module INV01 which contains you Final Shipping Cost per week, not on DAT02. That is why in my previous message I indicated that the amounts will be automatically aggregated from weeks to months based on Summary settings. in INV01 the dimension is SKU, however in INV05 you have Location, therefore make a good use of SKU system module to sum the data correctly. By the way, in general, you can read more about Time functions here -> https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Time_Date_Functions.htm

filip.sypniewski

Hi @Olli, please make sure that the summary of your line item "Final Shipping Cost" in module INV 01 is set us SUM. This will automatically aggregate the weeks to months, so you do not need any additional formula in this case. However, remember that you need to take into account SKU to Location relation (TIP: You will probably need to use System module with details about SKU). Good luck! Let us know if you have other questions.

filip.sypniewski

Hi @Misbah, Thanks for sharing, great article! Bookmarked already too 🙂

filip.sypniewski

Hi All, I recently thought about gathering the most important articles & resources that every Anaplanner should be familiar with. I was actually preparing it for myself, but decided to give it a go and share with everyone since it could be useful! Of course, all these materials are available at Anaplan Resources, but I wanted to gather some of the most important in one place. Within these resources, many more detailed articles can be found. The Planual https://community.anaplan.com/t5/Best-Practices/The-Planual/ta-p/49773 The Anaplan Way Guide https://community.anaplan.com/t5/The-Anaplan-Way-Guide/ct-p/The_Anaplan_Way_Guide PLANS/DISCO https://community.anaplan.com/t5/Best-Practices/PLANS-This-Is-How-We-Model/ta-p/33530 https://community.anaplan.com/t5/Best-Practices/Best-Practices-for-Module-Design/ta-p/35993 https://community.anaplan.com/t5/Blog/The-Planual-Rises/ba-p/48321 Connected Planning Playbook https://community.anaplan.com/t5/Connected-Planning-Playbook/tkb-p/CPP Center of Excellence https://community.anaplan.com/t5/Resources/Introduction-to-Centers-of-Excellence/ta-p/43912 https://community.anaplan.com/t5/Resources/Center-of-Excellence-Roles-and-Responsibilities/ta-p/46953 All Micro-Lessons https://community.anaplan.com/t5/On-Demand-Courses/tkb-p/TrainingClasses On a more technical side, I have this one in my bookmarks Reverse Lookup https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Reverse%20Lookup.htm?cshid=1569 What would you add to the list?

filip.sypniewski

It means that your line item is formatted as a "Size" list. However, what you are trying to import does not exists on "Size" list. First, you need to update your "Size" list and then import. Maybe you missed this point of creating "Size" list? Go back to Part 4 of Level 1 training and double check 🙂 Hope this helps!

filip.sypniewski

Hi @KMc, I think you have not attached screenshots. If you add them, I will try to assist!

filip.sypniewski

In my opinion, the course is well structured and very informative in general! Academy Team did really good job on the new courses. Let us know if you need any tips, good luck 🙂

filip.sypniewski

L2 training still gives you some guidance, but already requires you to be more independent. You will need to be build Data Hub and Supply Chain Model as well as connect both. It provides additional practice and covers more advanced topics of model building as well as best practices. There are 3 exams after each sprint as well as conclusion exam. Good luck!

filip.sypniewski

It should be dimension of your module so 'G1 - Region' as a dimension ('Applies To') for your module as well as line items:

filip.sypniewski

Hi @vickyaladro, I just tested myself. I changed the browser language from English to Polish in Google Chrome settings -> closed the browser and opened it again (if it does not work, I would also check with keyboard settings). Now, in Anaplan, certain parts are in Polish, the only odd thing is that "Run" button is never translated.. I know from colleagues from Spanish office that it's the same for them.