-
Level 1, 9.2.5 Activity: Dimension Error
Hello, I'm working on Level 1 Model Building (9.2.5: Add Formulas to Price Growth Rates Staging Module). When I try to enter the LOOKUP formula for the line item 'Unit Price %' in REV05, I get the error: "Dimension of mapping used for lookup doesn't match any dimension of the result" I verified that in REV05 the "Applies…
-
3.3.6 Activity: Test the Shipping Cost Formulas
The Final Shipping Time Weeks is right? Why is it not 1 in my module?
-
First day of the week for fake week
Hi, I have calculations in a module with time day and the calendar type is calendar month. I have created fake weeks and needs to calculate first day of the week and last day of the week. Havent found a good solution for that. Does anyone have an idea?
-
Level 2 Sprint 3 activity 3.4 & 3.5
Hi, So while creating these UX pages I noticed my conditional formatting and and my chart as well is starting from week 5 onwards and not from week 1 , I don't understand the reason behind this , can someone explain , what I might be doing wrong .
-
Calculation Error
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 2 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Level 1; Course 8.5.3 - need assistance mapping volume into module
I’m having issues mapping out the attached file; any assistance would be appreciated!! Thank you!
-
L2 Actions at beginning of Sprint 3
As I start Sprint 3, the first activity was to create a new Action and place it into Process 9. I am looking for validation that my action tab looks correct or was I supposed to add the import volume growth rates to process 9 as well? I vaguely remember specific instructions to make this one action into its own process. If…
-
Level 1 4.6.6 Activity: Import Data into P1 Product Family List.
Hi you amazing community 🙂 When I import the data for P1 list and map it, I either get an error that family name doesn't exist (chocolates doesn't exist), or CH maps under chocolate, etc. There's also no option for parent mapping. My grid doesn't look like the training instructions and I'm stuck. Thanks so much in advance
-
3.3.5.3 Check Your Work
The method and Shipping Time weeks are not getting populated in my module. I don't know why? Help me resolve this?
-
3.2.11.1 Create Planning Period Filters
Confused on which Line Item I'm building a formula for, I'm assuming both. Also this is the formula I used to so that the weeks in that month are selected as well when you select the month are as follows. Please advise. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter), Kind of confused why would not want…
-
Level 2 - Sprint 3 - 3.3.5.2
Let me know, if what I did is right or not Create a Filter You will need to create two Boolean-formatted line items in the SYS01 Time Settings by Week systems module: * Line Item Name: First Week of Timescale? * Use this Boolean-formatted line item to select the first week of the timescale. * End users can manually select…
-
Level 2 - Sprint 3 - 3.3.5.2
Can I get help regarding this? This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week. The syntax of the formula should be written: If it is not the first week of the year, then use…
-
Error at SYS03 Country Details
Hi, While importing into the general list G2 country, i might have done some mistake while importing countries.csv due to whcih country code was not imported. now i am at the stage of creating modules(SYS03 Country Details ). Here country codes were not shown. so, now i realized. How can i import code only to the g2…
-
3.3.12 Activity: Create Product Replenishment UX Page
Hi, I've created everything as asked , but when I select a single month or multiple months , my data in the grid and the chart view is going blank , can someone please tell me the reason for it , and how may I be able to resolve it. I have attached the screenshots below of the months selected and unselected for reference.
-
Level2 3.4.3 Formula to add SYS08 'Country Made In'
Hi, I added the formula for INV02 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] But nothing show at the grid. Did I miss something at the setting of SYS08 'Country Made In'? Please help.
-
Issue in Level 2
Hello Community , Facing an issue in Level 2 1.5.7.1 Create SYS13 Account SKU Filter Module In this I am unable to create ---- 1.5.7.2 Add Formula to SYS13 Line Item where " * The formula should check the total of all product SKU volumes over all time periods to determine if the value is not equal to zero." Can Someone…
-
3.3.7 Activity: Add DCA to Inventory Ordering
Hi, I'm done with DCA and formulas , where I have difference when comparing to the example is , I am not getting the totals for Shipping Cost, Final Shipping Costs and Shipping Costs Variance, I checked the summary it is already set to Sum, please guide me how can I get the summary for these Line items. Attaching my module…
-
2.4.6.2 Apply Dynamic Cell Access to Demand Forecast
The Override forecast line item won't accept the formula? What am I doing wrong?
-
Level 3 Sprint 1 5.2 - Initial Account Sales Target (3.1.5.2)
Hi, I've been stuck on this task for some time and I don't understand what we are meant to do with Initial Account Sales Target Line Item do we use the same percentage Increases from the Data Hub model used for the Initial Country Sales Target Line Item. I'm a bit clueless and would really appreciate any guidance I've…
-
Model change has been rejected to prevent the workspace exceeding its size limit in supply chain
IM GETTING THIS ERROR WHILE CREATING A NEW MODULE IN THE SUPPLY CHAIN FOR L2 SPRINT 4 Model change has been rejected to prevent the workspace exceeding its size limit Current model size: 637670764 Rejected model size: 720294076 Current workspace size: 1023483953 Workspace limit: 1073741824
-
Level 2 - Sprint 2 - 2.9.3.2
Hi In my Supply Chain model, I'm trying to run the action which inside there are 3 processes: with the 9.1 import action is the new action I previously did But when I run the action, it shows but this model is something I downloaded from the anaplan. What can I do to fix that? Thanks
-
3.3.11.1 Create Planning Period Filters
Hi, A bit confused about what formula is to be used in the line item 'Planning Period Filter Weeks Only' I have used the formula 'MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter)' for the line item 'Planning Period Filter' Please suggest.
-
Level 2 - Sprint 2 - 2.4.11.1
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…
-
Level 2 3.3.6 Confirmed Purchase Order Receipt shows no value???
I can't get the value or in others words add the numbers in the Suggested order amount of the month. The line item always shows 0 no matter how hard I try. You can see my formula on the formula bar. Where do you think I have done wrong?
-
Level1 Training 4.6.5 Activity: Import Data into G3 Location List
How can I set Mapping ? Is it correct below? -Mapping Column2: Location Name => G3 Location Column3: Country => Parent Column1: Location code => Code -Items uniquely identified by Name or Code
-
2.3.9.1 Import data into DAT03 Historic Volumes module
The instructions in Level 2 model builder say to follow these steps. * Run Process 9 Import Data from the Hub. * This will pull the data into the Supply Chain model from the Data Hub model. * Make adjustments in order to avoid errors in the import process I got no errors running it and everything imported without me…
-
L3 TAR01 Module and it's check Module
Having trouble seeing why my check is not coming through for my TAR01 module. Attached are screenshots. Thank you
-
Level 2 Sprint 2 2.4.8 Activity: Create Detailed Demand Review UX Page
I understand that little instructions in the said section is intentional, but I am hoping someone help me out break it to me, maybe rephrase to include a little more detailed, if possible. Thank you,
-
10.2.2 Activity: Import Data into Non Employee Expenses Module
Dear all, I am having another issue in importing files. but this time it has no errors but values were ignored during importing process. I am trying to import NonEmpExp.csv into OTH01 Non Emp Expenses module Pls refer to both attachment. Pls advise/assist. Thanks.
-
Stuck on sprint 2 Question 5
Hi, I have attempted the exam multiple times now and cant get out of the first and 5th question on Level 2 sprint 2 exam. I have reviewed all available resources on Roles, Selective Access, Dynamic Cell Action and WORKSPACE Adminstrator Many times and still getting the Question wrong. Please help anyone. My email is…