-
Level 2 Model Building Month and Year Lookup DEM02
Hey All, I'm stuck on the level 2 model building on what appears to be a simple lookup that for some reason is posting back NULL. It is asking me to take the monthly rate of growth from one model which is in a monthly time scale and apply it to another module which is in weekly time scale. The ask is that each week should…
-
Level 2 Sprint 3 INV01
Hi, I see conflicting info regarding the formula for ReOrder Flag line item in the INV01 module. The section that details the formulas for the "ReOrder Flag" line item indicates "Ending Inventory" should be referenced in the formula. Further along in the same lesson it indicates the "ReOrder Flag" line item formula should…
-
Level 2 - Sprint 2
Historic volumes are imported to Supply Chain model - DAT03 Historic Volumes from Data Hub model - DAT03 Historic Volumes.Export (Saved View). Data Hub model - DAT03 Historic Volumes.Export is a Saved View with filter criteria displaying Historic Volumes <> 0 so that data with zeros are not displayed and hence not…
-
Level 2 - Current Period
Hi In the diagram below, the formulas for Current period? and Current period2? produce the same result i.e. Jan 20: 1) Current period? ---> CURRENTPERIODSTART() = START() 2) Current period2? ---> ITEM(Time) = TIME.'Current Period' In what way would they be different?
-
LM2 - Size of Model
Hi Team, This could be seen as nitpicking but Anaplan seems to ask very specific questions on tests & hence I thought this was relevant In LM2 when it discusses the size of models it summaries by stating that Model size is calculated by Number of cells, size of lists & Format of Line Items/List Properties But in reality…
-
Level 2 Model Building Sprint 2 - DAT04 Module
Hi, Somehow I could not find DAT04 module building description in Level 2 model building activities instructions in Level 2 Supply Chain Demand Planning (Sprint 2). Can someone please tell me where or which part of Sprint 2 activities talks about DAT04 module?
-
Level 3 TAR 01
Hi I try to make a rate of PY Revenue by Product Family In order to do it, I want to take All Products figure in PY Q total (120,580) It didn't work to use PY Revenue[lookup: parent(item(P1 product family)] Could you help me to figure this out?
-
Level 2 - Sprint 1
Hi In the activities, we were to import into SYS07 - Location Details and SYS12 - SKU Details. The Distribution Center for the above were loaded. As they both appear to be independent, does it mean that there is always a chance of mismatch between them? E.g. In SYS12, Chicago is selected but in SYS07, it is not selected.…
-
LM2 - Exam Question Answers
Hi Team, I answered a question incorrectly on the Sprint 1 Exam (Delete List Using Selection) & cannot determine why my answer was incorrect. The exam does not provide the answers for you once complete How am I able to determine my error? Thanks Mark
-
Level 2 - Sprint 1 User Story 1 Distribution Centre
Hi I have imported Distribution Centre into Location Flat list and SYS07 Location Details. Is this the intent? It would seem that importing into both places would mean that any changes would have to be updated in both places. What is the purpose of importing twice in both places or are we to import into Location Flat list…
-
Level 1 - Dashboard - Optional Activity - Add Location and Product Page Selectors to Dashboard
Hi In the Dashboard - Optional Activity, should the page selector for Product related be at Product or Product Family level?
-
Level 2 Model Building - Sprint 1 Data hub model - Activity: Import from Data Hub to Supply Chain
Activity: Import from Data Hub to Supply Chain model There are the following instructions in the activity: Set up an import into the P3 SKU list in Supply Chain model from the saved view in the Data Hub model. Set up an import into the SYS08 SKU Details module in the Supply Chain model from the saved view in the Data Hub…
-
Input for Actual and Formulas for Other Versions(e.g. Budget, Forecast1, Forecast2) for entire model
Hi In a scenario where Actuals are input and formulaes are defined for other versions e.g. Budget, Forecast1, Forecast2) for the entire model, how can the SYS module be created for versions so that they can be referenced in Calculation or other modules?
-
Level 1 Model Building Training Feedback
Hi Community! I realised that there wasn't a topic to enable users of the community to post feedback for the Level 1 training program specifically so please reply to this thread and post! I was recently supporting someone with their Level 1 Anaplan training and noticed the following: In "Level 1 Model Building: Lists |…
-
Level 1 Training - Feedback on Course/Exam
A new model builder at our company recently noted that there were some questions that were very confusing. She said questions 5 and 6 were confusing with edits to module calculations. I think there was also a bit of confusion on her part in the sections on creating saved views. In some cases the saved view instructions…
-
Complete Training for Model Builders from Anaplan Academy
New, aspiring, and experienced Model Builders can now come to Anaplan Academy for all the training they need to improve their Anaplan skills. Here’s an overview of the three levels available on demand in the Learning Center or with an instructor either in-person or virtually. Level 1 Model Builder Training is meant for…
-
Level 2 Sprint 3 INV01
Hi all, So in building the INV01 Inventory Ordering module, I managed to get the same answer as the example given by the course module as follow: Course Example: My Module: Unfortunately in my first attempt of exam, the formula for "Confirm Purchase Order Receipt" is incorrect, even though my answer is the same as the…
-
Helpful best practice in Level 2 MB to make sure line item names are correct
Hi - Having module and line item names in Level 2 is critical to having the correct formulas for the exams. I am not the best typer so what I do to eliminate any error is: * Copy the table that is listed in the training instructions to Excel * When adding in the line items, copy/paste from Excel the names of the line items…
-
Dashboard - Page selectors and security
Hi The below two dashboards were created. INV02 were published to both dashboards. No change in other accesses such as modules, lists etc. The only difference is test2 has page selectors published whereas test1 does not have. However, when selecting landing dashboard, only test1 is available for selection. Is it because…
-
Level 2 - Sprint 3 - Create Combination Chart for Dashboard
Hi How do we get the dashboard to automatically refresh (without having to manually click 'Refresh') whenever we select a month for 'Planning Period Filter'?
-
Level 2 - Sprint 2 YEARVALUE formula for Model Calendar and Time Ranges gave different results
Hi In the following two examples, the difference is the Time Range applied - Model Calendar vs FY19-FY20 The results are as follows: 1) 1st Forecast Year? - Model Calendar - Tick-marked for Weeks for FY20 2) 1st Forecast Year? Test2 - FY19-FY20 - None tick-marked for all time periods. Refer to purple box below. I was…
-
Level 2 - Sprint 2 SYS01 Time Setting by Week module
Hi I was going through this module and need to understand the functions in the orange box below. I read through the explanations Anapedia to get some sense of how it is applied but need help for further understanding? Thanks.
-
Granting access for Action (Processes)
Hi, where does one grant access to for Actions (Processes type)? Doesn't seem like possible at Users --> Roles--> Actions (refer to screenshot below).
-
Level 2 Sprint 2 - Assigning Dashboard to Product Family Managers Role
Hi The Global Demands Assumption is created, however, it is not available to be assigned to Product Family Managers role. Is there any step that is still required?
-
Level 2 - Sprint 2 - Test Dashboard for Product Family Managers
Hi The following were assigned to the Product Family Managers: 1) At the dashboard, where the Used Modules were stated 2) The lists defined in the dashboards In testing the Dashboard as Product Family Managers, I encountered following screen. The months for second grid is missing and the chart as well. There is no…
-
LEVEL 2 MODEL BUILDING ERROR - Sprint 1 Activity: Create Saved Views for Importing
Says Code and "Parent". Should Say Code and "Product".
-
Sprint 3 - Missing Line items
While Verifying line item names in modules before sprint 3 exam, SYS08 SKU Details. Supplied By (in my model, i see only SYS08 SKU Details.Distribution Centre) DAT01 Beginning Inventory.Produces SKU (i dont see this line item, i just have only one line item Beginning Inventory) Can anyone confirm these line items comes…
-
Level 2 - Sprint 1
Hi I have completed Level 2 - Sprint 1 exam but the system kept saying it is not completed. I re-did it the exam again and it is still saying it is not completed. I even have the congratulatory results printed. What should I do or who should I contact to address this?
-
Level 2 Sprint 3 INV01
Hi, Im working on the formulas for Level 2 Sprint 3 and a couple of things dont make sense to me: 1. The formula for Confirmed PO Delivery give an example "For example, if a PO Submitted has a value in Week 1 and the Shipping Time Weeks has a value of 2, there would be a value of 1 in the Confirmed Purchase Order Receipt…
-
Level 1 Part 7 - SYS08 Employee Details - question on Line Item "Name"
Hi - I just completed Part 7 of Level 1 Model Builder and am thinking I have done something incorrectly. Here is the grid view of my module I would think that the employee names should be repeated in the "Name" column...have I either messed up the creation of the #E2 Employees List or the data import? Or is this OK?…