-
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…
-
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.
-
Do we have recorded sessions for building models?
Do we have recorded sessions for building models?
-
3.4.4 Activity: Create Stock Exceptions Review UX Page - SKU Product detail
Hello! The course instruction tells us to add P1 product list as a dimension but while creating the UX page it tell us to create a view at Product SKU. What am I missing here?
-
Sprint 3 INV04
Hi, Could someone please help me with the module below? I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line. I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong? I also could use a…
-
Invisible UX pages
Hi, How do I make UX pages I have created in My Pages visible when they disappear from the landing page? I created a UX page called Margin Summary. Days later, I visit My Pages landing page and find the landing page empty (no pages found there). When I try to re-create it, I get the message that a page with that name…
-
Beginner to Anaplan
Hi Team, I am a beginner to Anaplan with no previous knowledge about this software but with an interest in training myself in Anaplan followed by certifications. Please tell me from where should I begin with, how should I download Anaplan on my local system for practice and prepare myself for certifications. Thanks, Dhaval…
-
Versions
Hello everyone, I have just started my Level 1 course, I have a small doubt regarding versions. In the version tab we can see Current as an option, what does the tick mark under forecast, current and budget line item exactly mean? I have also attached the snap of the doubt. Anaplan Home Thank you in advance.
-
Level 2 Sprint 3 Exam passed, but can I please be given the answer to my incorrect question?
Hi community I've completed the Level 2 Sprint 3 Exam, but not knowing the answer to the question that I got wrong is really bugging me. I think that it would be valuable for me (sanity and anaplan understanding) to know the answer. Is there some way that I can send someone my L2S3 downoaded certificate and they can send…
-
Struggling with training link
Great if someone could help me with this, I was training to take level 1 model builder training however I have been getting the below error "The webpage at https://anaplanenablement.s3.amazonaws.com/Academy/Platform/Level_1/L1_P01/WEB/story.html might be temporarily down or it may have moved permanently to a new web…
-
3.3.5.2 - NOT First Week of Timescale
Good evening, I am asking for a hint, according to the formula for the item NOT First Week of Timescale ?. I saw here prompted that the solution lies in the OFFFSET formula, but I have something that is not correct. I decided by forming 3 items, but I'm not sure if this is correct. Now everything looks something like this…
-
Error while editing TOP LEVEL hierarchy
I am not able to configure TOP LEVEL hierarchy for Product family list and Employee department list. screenshot attached. Due to the error in top level, I am not able to add the formula to Profit and loss report module. Can anyone let me know what i need to do or where I am going wrong..
-
8.8.2 Activity
Hello! I am receiving a message that a formula that I copied from the exercise is invalid. Can anyone offer an assistance? Thank you so much!
-
L2 S3 Activity - highlighting in Anaplan
Is this activity tasking us to use conditional formatting? Activity instructions given in L1S3: Week 1 & 2 (blue highlight) * Week 1 shows the result when Submit Purchase Order Request is NOT checked. * Week 2 shows the result when Submit Purchase Order Request is checked (however, in the example nothing is writable). Week…
-
Slight differences in numbers between what's been showed in the L3 Lesson Plan and what I'm getting
Dear Academy, As I progress through the sprints I'm seeing some slight differences at the account level between what I'm getting and the numbers shown in the progressive Check Your Builds although the totals are the same. The fact that I'm getting the same totals reassures me I'm heading in the right direction but…
-
Do we use Classic Dashboards or New UX
Hi, As I progress through both sprints on the L3 training I can see quite a few references to doing things on the Classic Dashboard and am wondering is this a function more about the training not being updated to the New UX or an expectation that we still do things on using the Classic Dashboard? I appreciate feedback now…
-
3.3.5.3 Check Your Work Level 2 Sprint 3
Hi everyone, I'm checking my work of my INV01 module and my numbers are slightly different in the line item Safety Stock Exception Count to the ones provided by Anaplan to check our work. I already checked the summaries and the totals and they look fine, I would really appreciate some help. My INV01 module below, you can…
-
Level 2 Sprint 3
Hello, In level 2 Sprint 3, after I ran the import from Data hub DAT04 Distribution Center Parameters to DAT04 Distribution Center Parameters, I am not able to see any data after the import. My import was successful and time scale and time range did match in both the modules. Please suggest.
-
L1 model builder exam, q 4,5 and 6
Hello, I'm struggling to get the correct answers for these questions,,i believe my formulas are correct and I've made an error with the module creation. Can anyone point my in the direction of either anapedia topics or forum posts which can help, or the lessons within the training I might need to revisit please? Many…