-
Help on 8.5.3 Activity: Import Data into Volume Inputs Module
I am trying to import data in the training exercise, but not sure how to select multiple columns for volume. I chose the header to be row 2 and first data row to be 3 in preceding tab.
-
Level 2 - 1.7.3.2 Import into SYS08 SKU Details module
Hi, In activity 1.7.3.2Import into SYS08 SKU Details module it says Use the saved view from the Data Hub model to import into the Supply Chain model SYS08 SKU Details module. In this which saved view we have to import there are 2 saved view. 1. Build SKU 2. Import SKU Details In Supply Chain model SYS08 SKU Details module…
-
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 2 - 1.3.10.2 Import Data into G2 Country List - Error
Hi, 1.3.10.2 Import Data into G2 Country List In the Data Hub model, import data from the source saved view into the target list: * Source: SYS06 Country Details module, Build Country saved view * Target: G2 Country list NOTE: This list is part of the geographic hierarchy. Remember to designate the Parent when importing…
-
2.4.8 Create Detailed Demand Review
Hi Team, May I have your support with a query I had raised and to which I have not had a response yet. This is my original query. When pivoting time, I lose the weekly views and can only see the month's numbers, may I confirm how I can retain the weekly views whilst moving the months into the pages section. I was advised…
-
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.
-
Level 2 Activity 1.5.8.1 - Create Saved View for DAT03 Module: How to setup filter?
I need to get the following desired view: However, when I try to setup a filter, I am getting the following dialogue box, which enlists 'Time' in it: Can anyone tell me that why am I getting an additional 'Time' filter? My current model looks like this:
-
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…
-
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 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…
-
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
-
Train the Trainer
Will there be "Train the Trainer" courses beyond Level 2, so our Team can be certified Anaplan trainers? If so, has the course changed titles? We can't seem to locate any current "Train the Trainer" courses. Thank you for any help you can provide.
-
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…
-
13.6.3
I'm not sure how to sync module information, specifically: Thank you!! * Data Source: Module views >> REV03 Margin Calculation >> Forecast Periods
-
Level 1 Model Builder: 13.9.3 Activity: Add Primary Grid to Volume Entry Page
The instructions tell me to enable editing however this is not an option to me as it is greyed out. Have I missed a setting somewhere back in the process?
-
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 1 Model Building Exam - Model Building Activity 6
Hello all, I have been trying to work through Model Building Activity level 6 and cannot seem to understand why my lookup formula is off. I am trying to add a formula to REP04 that shows Total Salary expenses by Region and Role. The formula I am using is 'EMP02 Employee Expenses'.Salary[Lookup: 'SYS08 Employee…
-
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…
-
1.5.6.2 Import Data into Historic Volumes Module
Hi I am having the much trouble trying to import data to the module: I've matched all Run the upload and says it is successful: But then there is no data loaded? I also not that the Time is incorrect? Have spent about 3 hours trying to mitigate this with no resolution. Please help! 😞
-
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 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…
-
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
-
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