-
TAR03 Country Account Calculation
Hi @Misbah,@JaredDolich How are you? I am filling the TAR03 Country Account Calculation module. I want to know if Targets is SUM of Initial Account Sales Targets. What is the Check? Any hint/clue is very appreciated. I am looking forward to hearing from you soon. Best regards. Wei
-
Checking Work for 12.4.6 Activity
In the Level 1 training, it was great to check our work with screenshots provided after completing the activity. However, check your work option was not available for the 12.4.6. activity. Thus, I searched the forum to proceed confidently, but could not find any shared sample. I'd like to share a screenshot of my workspace…
-
Sprint 1 User Story 1.4
Hi All, I've been stuck on this for a very long time. I thought I was doing ok, but when I got to the % verification module, I did not have 1s. Here is my TAR01 & DAT02 - any help would be great!
-
New user guidance
Dear All I am new one here,keen to learn Anplan please help me to guide steps. Just for the infoemation i am Hyperion Consultant with 8 years of relevent implementaion exposure. Highly appreciated for the quick reaponse. Regards Anwar Abbas,FCCA
-
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…
-
Question on Sprint 2 Detailed Demand Review Dashboard
Hi - UPDATE: 24 April 2019 - I had an error in one of my formulas (found out on Sprint 2 exam) that I corrected (retook test to ensure I had it fixed the issue). I had thought that by fixing that formula it would resolve the below discrepancy but it didn't. I have a question similar to this one posted in Anaplan Platform…
-
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.
-
Level 2 Sprint 3 INV01 Inventory ordering Boolean line items
Hello guys, I've noticed that my Boolean line items have stopped functioning somehow. It was okay when I first created them and stopped working when I added DCA. I checked the formulas and write accesses but they seem fine.... Any ideas?