-
Level 1 ModelBuilder - How to make the time period extend to capture prior/future years?
I have downloaded all the csv files and have successfully loaded them with one exception. The data for 2019 and 2021 is not showing up for me - only data for 2020. I believe its a time setting issue. Can someone help me figure out how to widen the time to include the year prior and future year? For example: I am in Lesson…
-
Level 3 technical examination
Hi everyone, I was undergoing my level 3 examinations of which I have completed my model building Knowledge exam successfully. However, on the technical examination, I am not getting any answer correct, despite some of the questions being straight forward and can even be picked up from the excel dump provided. (Not that…
-
Level 1 8.8.4 Activity: Add Formulas to Size Margin Report Module
It won't accept the formulas for Revenue and COS. Not sure what's wrong.
-
3.3.5.3 Check Your Work
Hello, I need help with the "Shipping Method" & "Shipping Time Weeks" calculations. Below is a comparison of how the module should look like vs. how it looks like on my end: How it should look like: How it looks like on my end: Please let me know if I'm missing something. Thanks!
-
level2 - Create Inventory Ordering Saved View and Export- export setting
I am trying to do this activity: This is my export view: I used Tabular multiple column export, and got this result: which is differ from expected one: Which export setting needs? Regards Roya
-
3.4.4 Exceptions Review
I am in the process of creating the 3 different grids in the exceptions review dashboard. I added another grid with a link to the INV01 Inventory module and just included the stock exceptions line item. is this a correct approach? i was going to do something similar with the other grid as well. Lastly, the screenshot…
-
12.4.2 Create Saved View for Country Margin Report
Hi, I'm working on Lesson 12 in Level one. My issue is that the example data is slightly different from what I've been building so far. I'm not sure if it's the format or formula from the other modules. Please send suggestions
-
REV03 Margin Calculation Module (Margin%)
Hi, I am a newbie and I am confused when working on the Rev03 Margin Calculation on the Margin %. It should be an easy formula. My formula is the same as the "check your work" section but the result I get is not correct. The first attachment is the answer provided and the second one is mine. Could anyone tell me what I did…
-
Importing data but get different results
Hello community, I'm getting an issue while importing data with a csv, below i've attached data i'm trying to import but suddenly i get this kind of results which does not correspond to the data i supposed to get instead of getting 58.88 in anaplan ,i'm getting 5,887728739E9 even if i have set the format to 2 decimals.…
-
Level 3 - Sprint 2
Hello - This is the best i can do here. Can you please give me direction on where I am going wrong, i am not getting to the number that they have on the training screen shot. There were suggestions to go back through all the user stories and look at every little detail. I did all that i can, went through everything but i…
-
TAR01 Initial Account Sales Target
I am stuck at the final step in L3 6.3 not able to get the numbers to match from the lesson to my build. What am i doing wrong. Everything checked out until this point this is the expected result and this is my build
-
3.3.4 Activity: Create Shipping Metrics by Week
I keep getting invalid formulas. What am I doing wrong? This is what my DAT02 Shipping metrics module looks like.
-
3.3.5.2B Shipping Line Items
I'm only getting 0 for my Shipping Time Weeks line item This is the formula I used for shipping method: 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Supplied By] This is the formula I used for shipping Time weeks 'TRA01 Shipping Metrics By Week'.'Shipping Time (Weeks)'[LOOKUP: Shipping…
-
Issue in ALM Sync Up across Tenant
Hi Everyone, We have moved one workspace from one tenant to a new tenant in which the prod model was there. After its migration, I took a copy of the prod model and make a dev model from it and make a mock deployment but the ALM was not intact between them. Then I tried one more approach where I made a new model from…
-
Is the Solution Architect exam free or paid? And what about the Master Anaplanner exam?
Was curious to know whether the Solution Architect and Master Anaplanner exams are paid or free
-
when setting up a new module how do you know what dimensions go in the pages versus the columns
when setting up a new module how do you know what dimensions go in the pages versus the columns
-
Import Final Demand Forecast into DAT02 Module
Good Morning, While doing this activity in the Conclusion course, I got stuck Indeed, they are asking us to Import the Demand data into the DATA02 SKU Volumes module. But in the Level 1 model, there is not a module called data2. So do we have to create this module? If yes which line item, what to put as page selector, rows…
-
Time related question
I have 2 modules with year and entity as dimensions. In 1st module I am performing some calculations based on the result I am going to eliminate some of the entities. I want to bring only the remaining entities into my another module. How can I achieve this.
-
Integrating Anaplan to informatica
I am getting some errors while integrating Anaplan to informatica, I have an Anaplan export action which I am using to send data to a table through informatica, however it is failing with separator cannot be null or empty error. I am wondering if I need to have the export definition in a particular format or if it's…
-
2.3.10 Activity: Create Demand Forecast Formulas
My formulas are showing incorrect data. I don't know where I'm wrong. Can someone help
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello, Below are the steps I followed for this activity and the corresponding outcome *All other tabs are mapped correctly Outcome: Is there anything I'm missing that causes the other data to be ignored? Thank you in advance!
-
Run Process 9 Import Data from the Hub
Hi Team, While I'm Running the process I'm getting error. Please help me to run the process sucessfuly.
-
SYS08 SKU Details Missing Data
I am reviewing a specific module in the Lvl 2 Supply Chain Model and noticed the "distribution center" column in SYS08 SKU Details isn't populating. I have the format set correctly - list: s G3 Location: Distribution center. The data is just not showing up. Is there something I am missing?
-
Level 2 activity 3.3.5.2B formula for Shipping line items
Hi, 1) Could anyone help I tried to build the formula for 'Shipping Method': 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP:( 'SYS08 SKU Details'.Distribution Center)] and cross checked previous answers at forum that it should be right. But it still prompt invalid?I checked lists of SYS07 and SYS08 that…
-
why the data in the modules is disappearing after creating roles, giving selective access ??
please explain me this….
-
I am struggling with my mapping and import of E2 Employee List
Hello Model Builders! I need your help in Model Building. I have tried over 10 times to import data into E2 Employees# under Lesson 4.8.2. I have spoken to some colleagues on my team and the we were unable to resolve this issue. If anyone could assist please share a solution or trick to this. I noticed other colleagues had…
-
Similar department in each entity
hi Community, I have a new requirement where I need to flag similar department from all entities. Using the first 3 letters of their code. below is just a sample of the list: as you can see TMCI and TMSL has the same department (L3) Laboratory and Pharmacy they also have a similar code the 1st three letters starts with LAB…
-
Level 2, 1.3.10.1 Import Data into G1 Region List
Hello, I am having a hard time trying to import the code. Sorry for the large screenshot. I am still new using PCs. My apple died. This is from my Build Region, however, it falls under SYS05 Region Details. I might have done some wrong in that area. Please help as I am running out of time. Katherine
-
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…
