-
1.3.10.2 Import Data into G2 Country List
I am having the same problem as 1.3.1.0.1 Import Data into G1Region. The code is not importing and yes I have made sure the parent is included. Katherine
-
Model Builder level one exam activity 5
In EMP02 Employee Expenses, I keep getting zeroes from my formulas This is an example of the formula I am using for Bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 What's also strange is that in SYS08, the…
-
Optimizer: Dynamic Time Setup
This video will demonstrate how to setup a dynamic time list for use with the Optimizer. Download the attachment for instructions on how to setup Dynamic Time. https://www.youtube.com/watch?v=hD7Wt4wcxwM
-
Optimizer: Exercise Walkthrough
This video is a walkthrough of an Optimizer exercise. Download the attachment for a printable version of the exercise instructions. https://www.youtube.com/watch?v=rwwXAB9Rbp4
-
Level 3 Sprint 2 Assign action [Finalize Assigments button error]
Hi Good day, Invalid selection message Can anyone give me some hint? Thanks
-
8.5.3 Activity: Import Data into Volume Inputs Module
how to import this please help me
-
Level 1 Exam Question 7
Hi all! Thank you for the help in advance. I answered correctly to question 6, but my question 7 answer is wrong - I noticed that in my REPO 04 I get the same number each year - what could be the issue here? same is for phone and car costs - is it the formula?
-
L1 Model Builder Exam - Question 5/6: Stuck!
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 1.5 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
2.3.9.1 Import data P3 SKU
I am having a hard time importing the data from the DAT03 Historic Volumes module, Export saved view. Everything else seems to be mapped correctly, but the P3 SKU is not. Do I need to change the target item to display the SKU? Thank you!
-
Level 3 - Build Sales Reps
Hi - In Building Sales Reps - in DH in the SYS09 Employee Details, you gave me a view "Build Employee" - do you expect that i use the view the way it is given to me OR do you expect that I apply Active? = True filters since you are showing the Active? column in that view. PLEASE PLEASE clarify. Thanks
-
Model Builder Level 1 7.2.2
When I upload the csv file to the SYS08 Employee Details module, I get errors for the Start Date and Leave date fields. I set those data types to "Date" within the module, but the csv pretty clearly contains simple numbers (ex: 20120601). The instructions further indicate that I should not manipulate the csv file so as not…
-
Level 3 - Employees Details file
Hi In DH, under Role Flat list currently I see the values as per screen shot. In the Employees file given as part of 5.5, User Story 3.1 i see only three roles Sales Principal, Sales Junior and Sales Senior. Is the expectation that we add new members to the current list OR are the three roles (Sales Principal, Sales Junior…
-
7.2.3 Activity: Import Data into Employee Details Module any one please resolve and explain it
-
how to import 8.5.3 Activity: Import Data into Volume Inputs Module
i am trying to import but i cont please help me to do this
-
Process Flow & UX Design
Hi all, I have started with my L3. The ask is to Create a UX prototype for the Regional Sales Executives to use to establish the sales revenue targets for each country they manage. Is there any kind of example or reference available for the same? Following are the points that I am stuck at: 1) What does a UX prototype look…
-
confirm something about G4T Territory>Account#
hi, thank you for attention. I want to confirm something about G4T Territory>Account# 1 Is this statement right? The Country of an Account had been told. The Country of a Territory had also been told. Therefor, for the numbered list "G4T Territory>Account#", The children(the Accounts) of a Territory, must be the Accounts…
-
I am getting negative values in Beginning Inventory and Ending Inventory. Can anyone help
-
L3 sprint 2 assign accounts to more than one territory
Hello, I am confused as to how it is possible to assign accounts to more than one territory. When we need to import into a numbered list, we need to uniquely identify each entry. I use the account code. As such, every time I change the territory assignment, the import function will automatically override it. What am I…
-
Lesson 12.4.3
I've only just realised after completing lesson 12.4.3. that all of my cells are displaying zeroes. Does anyone know what I've done wrong?
-
L1 model building exam
can anyone help me with L1 exam's 7th question
-
Common Department in 1 List
Hi Community, I would like to ask a question in my new setup where I can flag similar departments in a list. Using only the 3 letters of the code present on the list. In my example below there is 2 Office of the President 1 which is the child of the TMC Main parent and the other is the child of TMC SL. Requirement: I need…
-
L2 Sprint 3 - 3.3.6
Can anybody please help me with why my data is showing 0 instead of 16388 in Confirmed Purchase Order Receipt (week 3) after following the instructions in the screenshot? I have applied the following formulae: PO Submitted: IF Submit Purchase Order Request? THEN 1 ELSE 0 Confirmed PO Delivery: POST(PO Submitted, Final…
-
L2-Sprint 2, DEM03 module
Hi, In L2-Sprint 2, DEM03 module we created few line items and applied some formulaes, after applying formulaes the data is populated for only FY2020 since we have only 2019 actual data we pulled the data from 2019 to 2020 by applying OFFSET function. In DEM03 module, for Baseline forecast line item we applied a formulae…
-
assign action: Unassigned Candyose from the US Central Territory is missing
hi guys, In level 3 training lesson, sprint2, 4.5, after unassigning Candyose from the US Central Territory, I can not find the unassinged Candyose Shouldn't it be moved to the list root or somewhere else? It seems that it has been deleted from the list thoroughly, instead of moving to root. I searched it, but only find…
-
1.7.3.1 Import into P3 SKU list
I am having trouble importing the data from the Build SKU saved view. When selecting my sources for the data, I don't have many options to link the properties to the sources. Is there something I am missing?
-
How do I pursue the Certification if I do not have access to anaplan from a workspace perspective?
My company currently does not have Anaplan. How can one go about learning the tool without a workspace? Any help would be greatly appreciated. Thanks
-
Finditem blank but list already exist
if we see on the picture one, finditem is blank but if see the list already exist Why did it happen? thanks before
-
Courses for Anaplan Model Building Level 2 certification.
Hi All, Which courses / modules should be completed in order to complete Model Building Level 2 course and certification. L1 was quite easy to follow. Please suggest. Are these the modules? or I am missing on the others? (NMX) L2 Model Building - Introduction Level 2 Model Building: Home Page (NMX) L2 Model Building -…
-
Anaplan Connect / Upload .CSV files
Hello, The connector gives an error (screen) on the format file when working.csv with files .there are no such problems in the txt format. What can be caused by? (I need exactly .upload csv). There is no such problem with manual import.
-
dynamic Parent heirarchy
Hi Community, I created this system mapping module, and my Solution Architect asked me to make it dynamic by creating the hospital parent heirarchy. I have no idea what it means or how to execute it. She is unavailable at the moment for clarification so I am trying my best to build it. Do you guys know what it means or how…