-
TAR01 Detailed Sales Target module
In the description from '5.2 Model Build Specifications', we need to calculate the proportion of a country's total sales revenue by product family each account's product sales contributed. The TAR01 was created already in the model, it's dimentioned "A2 Account>Product#' only. However the first line item is to calculate PY…
-
Level 2 - Sprint 2 - 2.3.9.1 Import DAT03 Historic Volumes module
I referred the community thread to understand my doubt while running the process. I am not able to figure it out. Attached are the screenshots .
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi All, I am not able to understand actually what exactly needs to be done. I am trying to run the action 9.1 but I am getting an error Below is the screen shot of what I need to do Regards, Ankita
-
11.3.4 Values for Employee Expenses didn't match
I applied all formulas correctly and check the data loaded, having a correct validation, but still the amounts where different from those in the sample image. Checking the data in EMP02 Employee Expenses, for the Line Item Left? I identified that for all employees withe a Leave Date, had this checkbox marked, even if the…
-
1.3.6.3 Create Build Location Saved View & 1.3.6.4 Create Import Distribution Center Details Saved V
Hi, When I work on the above activity and create the saved view I accidentally saved or overwrite to the default view and now all columns of data gone. How can I restore the original data? Please help.
-
Inv01 Level 2 Safety Stock Target
Hi, I'm stuck and can't figure out why I am not getting data in the Safety Stock Target Line Item in the INV01 Inventory Ordering module. This is what I have for source data: This is what I have in the INV01 Formula and summary settings And here is my result (lack of data): Must be something simple, any ideas?
-
2.3.9.1 Import data into DAT03 Historic Volumes module
hi I'm trying to import the DAT03 Historic Volumes module save view Export but I'm getting a lot of ignore items and Failed items
-
Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file
When i am trying for 2.3.9.1 getting error as "Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file map to the correct dimensions in your module, then run the import again."
-
Level 3 Sprint 1 User Story 1.3 DAT02 PY Revenue to CY
Hi, Please advise what am I doing wrong. I imported PY Revenue data from Data Hub Model to Sales Planning Model. Source - DAT05 Historic Revenue by Product, Applies To: Accounts Flat (150 members), Products Flat (53 members), Time scale: Quarter, Time range: FY19 Line item: Revenue Cell count: 31,800 = 1 x 150 x 53 x 4…
-
SYS04 Product Family Details import problems
I have rebuilt each module associated with sys04 multiple times, have changed the Region codes in the Excel file (as suggested by Vera), have added formulas in the rows for Code and Region, but something is wrong with Country. It keeps giving me the message shown. What have I done incorrectly? Thanks MPW
-
DEM03 Demand Forecast Module
Hello.Can somebody please me with this error. In DEM03 Demand module i am unable to get a data for Year 21,till year 20 all looks good to me,but from week1 FY 21 Baseline,default Forecast,Intial Demand Forecast all values are 0.I i have attached the blueprint too so i can get a better picture where i am doing something…
-
Level 1 Import settings for Modules and Lists?
Level 1 Import settings for Modules and Lists?Is there someplace that shows what you need to have in each section for importing to lists and modules so I can attempt it several times and then find where I am wrong by checking what is right? I feel I am wasting an inordinate amount of my learning time trying to figure out…
-
Level 1 Import settings for Modules and Lists?
Is there someplace that shows what you need to have in each section for importing to lists and modules so I can attempt it several times and then find where I am wrong by checking what is right? I feel I am wasting an inordinate amount of my learning time trying to figure out by brute force, checking for people who have…
-
8.6.4 Activity of level 1 : The output numbers are different than the correct solution.
Hi, Could possibly someone help me to solve this problem? The output numbers (1'st Pic) are different than the correct solution. In 2'nd Pic you can see the correct numbers, which must seen at the end of the activity. My set up is shown below. Thank in advance!
-
SYS14 Create Account>Product, Line Item "Data?" can't refer SYS12 and SYS13
I've create on Data Hub the module SYS14 Create Account>Product and looks like: But I am blocked by Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13 Account SKU filter. * If you downloaded a new Data Hub…
-
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…
