-
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…
-
level 1 Exam activity 4
Hi, I have been stuck on this question from past few days can anyone please assist me asap Have tried my best but couldn't correctly complete it. The formula I am using for Bonus in EMP002 is IF Employed? THEN salary* 'EMP03 Employee Drivers by Role'.Bonus%[LOOKUP:'SYS08 Employee Details'.Role] ELSE 0. is this correct?…
-
L3, Sprint 2, 7.3 Commissions FC
Hi all, I'm currently struggling with the calculation of the monthly commissions FC. There seems to be a slight difference. The targets check was correct earlier for Janell Wetzel. This is my SYS01 Time Settings Module. Any ideas why there a slightly different results in my FC calculation? This should be the correct…
-
LEVEL 2 SPRINT 3 INV01 3.3.7.2
@JaredDolich I am at the point where I have added DCA to INV01 and added formulas to AD02. My numbers do not match the example given. I know in the past I've been told not to worry about the numbers being off but is that the case with this example? Here are my numbers: Thank you for your help.
-
LEVEL 3 Subsidiary view
Dear Members , I have done the following as shown in the screen shot . Is this Correct ? If no/yes , why ? For subsidiary view for Location : has taken (G3 Distribution center list )--- Is this correct ? or should I Take ( G3 location list ) Need Guidance in this regard Thank you
-
11.3.4- Values Not Matched
In this lesson, my values don't match those of the example. Everything was fine until I put in the formulas. When mapping, everything matched perfectly. May someone assist with finding the issue? The formulas are in correctly.
-
Anaplan way
Hi Members , To get a Certificate , Is it necessary to Complete " My Anaplan way " If Yes , how much does it take to complete ? Thanks
-
Level 2 DEM03 - Baseline Forecast
Hi, I have recently started my Level 2 and was wondering if someone could offer me some guidance. I'm currently working through sprint 2 but I'm struggling with the formulas for the Baseline forecast FY21. This is what I have so far. Baseline Forecast - IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03…
-
Formula Help
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…
-
Data import
Hello, Something wrong when importing P1 Product Family datas( instead the respectif family code and name, on my model. I dont know what the problem's. Your help will be helpful, thanks in advanvce.
-
L2 2.3.10 Growth rate % formula is working however cell remains empty.
I am stuck with an issue which I can not solve. Pretty sure this is a simple thing I am missing. Please see attached screenshots. Growth Rate % is not showing any value, however the formula in "Default forecast" is using the value from "Growth Rate %" and calculates a value.
-
3.4.3 Activity: Create Country Summary Module
Hello, This is my proposed formula for the Flag Count line item - taking into account the mapping for both country and product family that are dimensions in the INV02 module 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In, SUM: 'SYS08 SKU Details'.Product Family] When…
-
1.6.5 Activity: Verify Model Organization
Functional Area assignment of SYS13 Account SKU Filter Module seems to be confusing. Image in 1.6.5 Verify your model's Functional Area assignments and module organization is showing: SYS13 Account SKU Filter Module Functional Area: Hierarchies Category: System Modules However, in 1.5.7.1 it is mentioned to…
-
Level 2 2.3.10 Activity: Create Demand Forecast
Hi, I am checking my answers at the end of this lesson and realize that I do not have any data populating for FY21 (attached). I have included my formulas and looking for any help and guidance on this issue. Thanks, Stephanie
-
Create Demand Export Module and Create a Saved View - DEM04
Hi, I am trying to do this activity: Here is what I did for DEM04: And this is my export view: There are two problem comparing with the expected result 1. The SKU Code and Location Codes does not appear in my saved view.( I put all line items as column) 2.The Demand amounts are not correct, here is the expected view: I…
-
Level 1 Lesson 4.6.9 File Mapping Guide
Hi Everyone My import was successful however it doesn't match the guide Here's the result of my mapping Here's the guide Hope to hear from everyone soon!
-
Create Shipping Export Module and Create a Saved View
Hi All, Can someone help? I am currently Working on INV05 Shipping exports Module. I have set the Formulae As attached screenshots Below. But the shipping cost In inv05 is mostly zeros. Attached screenshot is form Inv01 module Thanks.
-
Sprint 3
Hi Members , Tried creating the below mentioned requirement with the formula written below , but not getting it correct . Line Item Format Purpose Safety Stock Flag CountNumberIdentify number of Stock Exceptions by Country and Product Family…
-
Level 2 - Sprint 3 - 3.3.12
@Misbah Let me know if this is right?
-
2.4.11.1 Create Product Family Manager Role
Each Product Family Manager should be able to make changes to the Volume Growth Rates for only their assigned Product Family, but only view the data for the other three Product Families. The Product Family Manager role should be able to see the Detailed Demand data but not override any values. The Product Family Manager…
-
Historic Volumes data
Hi Can anyone reply to the below I am also facing same issue with time scale the Hint says NOTE: The Historic Volumes data includes the ACTUAL sales volume of product SKU from FY19. The Supply Chain model's Model Calendar begins in 2020 and does not include any previous years. If you run the Import Process as-is, you will…
-
3.2.11.3 Create Saved View for Combination Chart
The Product Replenishment User Experience page will include a combination chart of data from the INV01 Inventory Ordering module that displays the weekly data for the months selected with the Planning Period Filter. In the INV01 Inventory Ordering module, create a saved view: Saved View Name: Chart for UX * Include…
-
Level 2 - Sprint 3 - 3.4.3
The formula for Country Made in" is Parent(distribution center) I am getting an error, I need assistance
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hello , I am working on Level 2 training and have been stuck on this activity. I am not able to set up page to sync as well as not able to set up SKU view from INV2 module. I would really appreciate support with this. Thanks, Alina
-
New Bee How to get Workspace
Hi All, I ma new Bee and little confused with the process to learn Anaplan. While activating account, I did apply for 90 day workspace and started the course for level 1 Modelling. The course steps asked me to confirm if I have workspace and admin privileges'. Not sure where to look for to see I have workspace allocation…
-
3.2.11.3 Create Saved View for Combination Chart
Hi, I am trying to create Saved View. Time skips from Week 4 FY20 to Week 1 FY21. Please see my screenshot and guide me. Thanks, Mark
-
3.2.11.3 Create Saved View for Combination Chart
Hi, It says here that "Filter the data using the Planning Period Filter Weeks Only line item in the SYS01 Time Settings by Week module. " I did just as instructed but then i came out with this. Can anyone tell me what I did wrong? Thank you. Best Regards, CK
-
2.4.11.1 Create Product Family Manager Role
In the Supply Chain model, add a new role: Product Family Manager. Each Product Family Manager should be able to make changes to the Volume Growth Rates for only their assigned Product Family, but only view the data for the other three Product Families. The Product Family Manager role should be able to see the Detailed…
-
3.3.5.4 Update INV01 to Allow Override of Order Amount
@Misbah Can u let me know if its right? are my formulas right?
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell Access to perform as shown in the example below: Week 1 & 2 (blue highlight) * Week 1 shows the result when Submit Purchase Order Request is NOT checked. * Week 2 shows the result when Submit Purchase Order Request is checked…