-
Model Builder Level 1 - Rev02 Volume Input question
Hello, I'm working on the Model Builder Level 1 training course, I have run into an issue, need help in solving it. The issue is at REV02 Volume Inputs module. I'm trying to import the Volume input csv file and trying to map the source to target columns, have been unsuccessful. Any help is greatly appreciated. Regards,…
-
Level 1 Model Building Exam -- Activity 5
I thought I was pulling the data correctly but I guess I was not. Can anyone tell me if there is a problem with my formulas? Or maybe I should make some adjustments to my SYS08 Employee Details Module? Any Help would be much appreciated. Thank You!
-
Level 1 model building exam question 4
Hi guys, I'm trying to change the format of item list: Role, from text to list and the below message came up. Do you know how can I fix it?
-
Level 1 MB Exam - Activity 5
I thought I was pulling the data correctly but I guess I was not. Can anyone tell me if there is a problem with my formulas? Or maybe I should make some adjustments to my SYS08 Employee Details Module? Any Help would be much appreciated. Thank You!
-
Level 1 Cert Exam - Data02 SKU Volumes
I am struggling with the data pull from Data02 SKU Volumes to Rev Volume inputs. I was using a LOOKUP formula. Am I on the right track and are there any common mistakes on this step.
-
Model change has been rejected to prevent the workspace exceeding its size limit
Hi - working through sprint two of level two The module uses the lists P3 SKU and Accounts, Timescale is Week and Time Range is Model Calendar. Total cells is 34,721,544. Error message: Model change has been rejected to prevent the workspace exceeding its size limit Current model size: 417135690 Rejected model size:…
-
Level2 Model Build, Sprint 2, 1.7.3.2 Import into SYS08 SKU Details module
I have downloaded the Supply chain model and am running through the final steps of the L2 Sprint 1. 1.7.3.2 Asks for data from the Data Hub to be loaded into the SYS08 SKU module. The only data that would be updatable by load in the SYS08 module is the "Supplied by" Line Item, all other line items are look-ups to other…
-
Level 2 2.3.10 Growth Rate Formula Error
Hello All- I am getting an error when applying the growth percentage formula Dimension of mapping used for lookup doesn't match any dimension of the result Here is the formula I am using: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?'THEN…
-
SYS08 Importing data
I have been having difficulty importing Employee details into SYS08. I have tried dozens of configurations and can't seem to find the right correction to make it work. I have included pictures of my last attempt. Thanks for any help you can give me. MPW
-
Level 1 Model Building Exam – Model Building Activity 5 - 2 error messages
Hi Anaplan community, Whilst updating line items: Bonus, Car Costs, Phone Costs, Medical Costs I’m getting 2 types of error message: First error message: Data type mismatch: format other than LIST or DATE being referenced as a relation. I've spent close to 4 hours browsing Anaplan community, hoever I still haven't managed…
-
Level 3 Sprint 2 section 4.4 Model Build Specifications
The file provided to download contains two records for the Candyose account, one for a territory in the US and a second one for territory ME North. This account is in Mexico, so should I delete the first record from the file in order to get a clean import?
-
Activity 5
I have mapped everything right , but the medical cost for December 2020 is showing 36,800 and that is not the right answer. Can anyone please help me with , where I am making the mistake .
-
2.4.4.1 Update DEM03 Demand Forecast Module
Good morning, I am doing this activity by pivoting my module. With P3 SKU and account set up as default ( Nutzo bar EN and Candyate), i can flag or unflag the "override?" check box. Then I want to set up as the activity asks me but the checkbox of override? disappears, and cannot set up final forecast at 71 Is there any…
-
Mapping problem in level 1
I'm getting this mapping problem as mentioned above please give the hint to go ahead with my learning. Advance Thanks for help.
-
Level 1 Model Building Exam - Activity 2
Hi, I got stuck on "importing the data from SKU Volumes.csv data file into the DATA02 module". As you can see in the last pic, the form contains invalid entries. I am not able to run import, as a result. More importantly, there is no drop-down menu for me to select. The dropdown menu is blank. I do not know what's wrong in…
-
Level 2 - Sprint 3 Exam
Hello, My INV01 module works perfectly well and matches the training screen shots. I am juste facing an issue when trying to upload the weekly + Order + Schedule to answer a question. When i try to import i have a problem : Anaplan says that some P3 SKU are not found in the list. When i check the mapping i find those SKU's…
-
Level 2 - Sprint 1 - Activity 1.3.10.2
I want help with the mapping. Below is the attachment of What I did. Let me knw , if its right or wrong
-
L2 3.3.5 problem with check box
Hello everyone, I have a problem with the line item "Submit Purchase Order Request?". I followed all the instructions but in the end I can't check. I attach the screenshots. help.
-
L2 3.3.5 Blocked chek box
Hello everyone, I have a problem with the line item "Submit Purchase Order Request?". I followed all the instructions but in the end I can't check. I attach the screenshots. And it haven't DCA placed on the line item. help please
-
L1MB Activity 8.8.4 - Unable to Add Formula
Hi there, I am trying to use the following formula, as stated in the training curriculum, but continue to get an error for "Data type mismatch" (attached). I've read through the related issues but none seem to be the same error. Wondering if I imported the size incorrectly? The numbers lined up correctly but did not have…
-
10.2.4 Activity: Import Data into Employee Drivers Module
Not sure why this is happening?
-
Level 1 exam - model building activity 2
Hi, I'm trying to do the activity 2: "update the REV02 volume inputs module to include a formula to pull data from the DATA 02 SKU Volumes module". And tried the formula: 'DATA02 SKU Volumes'.Volumes but I got the error message: Level mismatch on common dimension
-
13.3.1 Activity: Create Margin Summary Page
I don't see the option to create an APP. I've administrator role though. Help me sort this out please?
-
10.2.2 Activity: Import Data into Non Employee Expenses Module
tHE TOTAL TAB VALUES WON'T SHOW?
-
L1 Model Builder: Lesson 6: 6.6.4 Activity Add Time Settings by Year Module
There is a frame at the beginning of the topic that says that the "Time Scale" needs to be adjusted but I can't find how to do this? I don't recall seeing that in a previous lesson, did I miss it? Can you help me out?
-
Level 2 - Sprint 1- 1.5.3.1
1.5.3.1 Create Filter and Saved View for DAT01 Module In the Data Hub model, DAT01 Beginning Inventory module, apply a filter and create a saved view: * Module Name: DAT01 Beginning Inventory * Saved View Name: Export The filter needs to work on one axis, so pivot the module view: * Columns: Line Items * Rows: SKU Flat…
-
Level 2 - Sprint 1 - 1.5.6.2
Attached is the picture after the import. Can anyone let me know if its right.
-
L2 Sprint 1 - Lesson 1.5.3.1 Create Filter and Saved View for DAT01 Module
Hello, I'm stuck on below task. I'm just confuse on the part where Filter is equal to checked? Below is what I have done. End Result Can anyone confirm if what I've done is correct? Much appreciated. 😊 Candy
-
level 1 exam - model building activity 2
Question: In the Level 1 model, update the REV02 Volume Inputs Module to include a formula to pull data from the DATA02 SKU Volumes module When I enter the formula: 'DATA02 SKU Volumes'.Volumes , all my data in the REV02 Volume Inputs module erases and becomes zero. Also in the REV03 Margin Calculation Module. I have set…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi everyone, it seems that I have made a mistake and I can't quite pin down where it is. Here is my table: