-
Level 2 - Sprint 1 (User Story 3) - Time Range related
Hi The historic volume for FY19 was imported as below. and the following SYS13 Account SKU Filter system Module was created. I then tested further with by changing the Time Scale to Week. and got the following results (changed the pivoting to reflect the below format) I am intrigue with the results above as we only loaded…
-
Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %
I am able to have the correctly summed PY Country and Product Family sales roll into the PY Account revenue but my % don't add up to 100% in the check module. They are about 3-5X higher. I have validated all input data but can't seem to get them to only add to 100%. Any help would be appreciated.
-
Re: SYSY03 Account>Product Details (L3)
SYSY03 Account>Product Details (L3) In my SYS03 Account>Product Details module, I can't seem to populate my P2 Product. Everything I have tried returns a blank - doesn't show any data. I wonder what I'm doing wrong.
-
15.2.1 Adding a Role, Knowledge Check Question 2
Hey there, In the Level 1 training, "15.2.1 Adding a Role, "Knowledge Check Question 2. The answer states: "The None permission should be used for the Price Book module, HR Manager role.", however since The HR Manager should have the ability to view and write to the module, how could the permission be set to "none"? Can…
-
L2 Conclusion: Importing Currency data
Hi guys, I'm struggling to import the data into my new list created: Country Currency. Error shows that the duplicates under Euros are not populating in the list Could I get some guidance as to how I am supposed to approach this and populate the countries using Euros as well? Thanks in advance
-
Level 1 6.6.5 FY19 checked
Hey, When checking my work versus the example, I see that FY19 is checked for Module 'SYS01 Time Settings' for Forecast Year? Below is the correct solution: Here is what I have: This is what I have for both modules: For summary on Forecast Period? I also did 'None' and 'Any'. In both cases, the check on FY19 was checked. I…
-
Level 2 Activity 2.3.11.2 and 2.3.11.3
These activities ask us to build two views. They both seem to be the same to me. Can someone tell me how these are different? Thank you for any help, David
-
Level 1 8.8.4 Activity: Add Formulas to Size Margin Report Module
For level 1 training lesson 8's Activity: Add Formulas to Size Margin Report Module. I have a question regards to the summary setting. As the screenshot below indicated, if I don't alter the summary method for line item "Margin %" and leave it as default(sum), it would produce the wired number in the second picture shows.…
-
Running Action Process Error
Hi, I' am running action process in Supply Chain model Sprint 2 but I got error message like Model object "'DAT03 Historic Volumes'.Export" could not be located.
-
13.6.3
I'm not sure how to sync module information, specifically: Thank you!! * Data Source: Module views >> REV03 Margin Calculation >> Forecast Periods
-
Event Recording: Master Anaplanner Q&A | Einas Ibrahim (Feb 10, 2021)
On February 10, 2021, the Learner's Lounge hosted a virtual Q&A with Master Anaplanner Einas Ibrahim (@einas.ibrahim). The original event wrap-up (along with follow-up questions and answers) were originally hosted in the Forum here, but we are now adding it to the group's knowledge base archive. In this event, Einas…
-
Unable to click on 2021 Certified Model Builder Certificate
Hello, I have completed the Level 1 and Level 2 along with The Anaplan Way, but still can't get the Model Builder certification. But it ask me to became a member of the Audience: 2021 Certified Model Builders.(Attached a screenshot) How to became a member? Thanks
-
level 2 sprint 3 hide/show selections in UX page
Hello everyone! In the Sprint 3 of level 2 I need to build a UX page with INV01. I have to follow this direction : * Do not show the Safety Stock Exception Count, PO Submitted, and Confirmed PO Delivery line items. (on my screen I can't find the "eye" button) However I have some trouble finding the way to do that. Could…
-
Level 3 Model Builder Training Feedback - Post Completion
First off, I want to say that I definitely appreciated the L3 training and it was very different than any prior Anaplan training I had taken. This one really did feel more like a real implementation, and put you in situations that model builders actually face. While much of it was review for me, I definitely learned a few…
-
Level 1: Anaplan cannot see "dot" as decimal separator
Hi everyone, I don't know if someone encounters the same problem as me: whenever I import data containing dot as decimal separator into anaplan, it does not recognise the dot and include the decimal party in the absolute value. For example, this is the value imported And this is the value affiched: Here's the format…
-
Level 1 model Builder, lession 7: importing data to module
Hi all, I am being blocked at the lession 7 while importing the list Employees# to model SYS08 Employees Detail. This is the mapping. And here is the result: no line is mapped and imported: Even though the format is well defined Here is the detail of the error log: Someone please kindly help. I am so confused. Thanks in…
-
LEVEL 2 - Sprint 3 Shipping Time Weeks INV01
I am currently on sprint 3. Even though I have almost figured out every formula in INV 01. I am not able to get the formula for pulling data for shipping times weeks. I am currently using the formula: 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product] The value is 0 for each…
-
Level 2 Sprint 2 - 2.4.7 Create Saved view for UX
Hello! I have some trouble getting the same saved view as shown in the example. I think I've done the conditionnal formatting the right way, but I don't know how to view the line items by month (I have to scroll very far to the right to see final forecast). Thank you!
-
Level 2 : sprin1 :1.5.6.2 Import Data into Historic Volumes Module
when importing Data into Historic Volumes Module, it gets error. What need to do in Time settings. I attached below screen shtos importing datatime as period , showing error time as match names , then records are ignoreds
-
PostgreSQL: Take last 3 hours and group by 5 minutes [duplicate]
I was wondering if you can help me write a query that should just SELECT count(*) but only include data from last 3 hours and group it by 5 minutes. So I have a table that has a createdts so I have the date there. I just want to see how many entries I have in the last 3 hours, but group COUNT(*) per 5 minutes. SELECT…
-
Not able to register for Level 2 Model Building
Hi,I'm not able register for level 2 model building training. I have attached the error screenshot below.Please note I have already completed Level 1 & Anaplan Way training with New UX training also.Please guide me for the same.Thanks in advance
-
Incorrect import for commission % in 7.2.3 level 1 activity
Hello everyone! I have some trouble importing data in the Employee Datails module. I think I did almost everything right, but for some reason the data in commission % are not the same as the ones in the csv file (I have 15, 1, 9, 8 instead of 0.15 or 0). Would you have any suggestion for me ? Thank you!
-
Level 2 Sprint 2 - 2.3.8.4 Time Aggregation
Hello everyone ! I am currently trying to convert month values from DEM01 into week values in DEM02. I am using this formula : "MONTHVALUE('DEM01 Volume Growth Rates'.Growth %) / 4" I think it works well when we have 4 weeks in a month, however there are months with 5 weeks. Thus I would like to turn my formula into : "IF…
-
L2 3.4.4 Stock Exception Review Dasboard
Hi Team, I am getting a disparity in the numbers visible in the 3rd grid vs values in first two grids. Ideally the value should be flowing through these grids. Can someone point out what I could be doing wrong here? Please refer the attached screenshot.
-
The Anaplan Way On Demand
Customers, employees, and partners have been clamoring for opportunities to learn The Anaplan Way so they can complete their Model Builder certification. We now have a way for anyone in the Anaplan eco-system to learn The Anaplan Way free of charge, at their own pace, and on their own schedule: The Anaplan Way On Demand in…
-
Level 2 Model Building: Sprint 1 Section 1.5.2
While importing the Beginning Inventory Data into DAT01 , I come across this error message "The list specified as the page selector is empty so there are no items to select."(Reference image attached below) Can someone help what I must do before importing the data to this module?
-
help with offset formula
Hi I'm going through L2MB training and trying to figure out how to work this formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 I think the first part of the formula is correct but I'm not sure if the second part within OFFSET(...) is. Volumes is where the historical data is…
-
DAT03 Historic Volume
Hello, On DAT03 Historic Volumes my volume line item don't match with the values for FY20 but does match with Offset volumes for Fy20. I used the following formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0. And, also DEM03 demand forecast pulls only FY20 data not FY21, used…
-
Level 2 - Import from INV05
Hi When an export was done from Supply Chain Model->INV05-> Saved View and the file was then imported to FP&A Model, it was successful --> no errors. However , the import from FP&A->Connect to Anaplan Model -> Supply Chain Model -> INV05 -> Saved View, the following error was encountered (related to date) This is very…
-
How to access Anaplan Workspace
Have logged in but not able to see Workspace. Kindly navigate me to the Workspace for learning and training purposes.