-
Sprint 3 Stock Exceptions UX Page
1. I having having trouble with getting the time context selector in the UX Page. I am sharing my screen and how i selected Time . But time hierarchy is off. I cannot change it. So please help. 2. Also I can see all the SKU in third grid (created based on INV01). I read it on the forums its supposed to be that way. So am I…
-
LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks
For Shipping Time weeks, below was the logic i applied and it went through, however the data i am getting is '0' 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] to further break down i searched for other modules for shipping method dimension but no…
-
getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the result"
I am doing level 1 model building(Activity-9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module) When i try to enter the formula for the lineitem 'Unit Price %' i get the following error- "Dimension of mapping used for lookup doesn't match any dimension of the result" . My Formula- 'REV04 Price Growth…
-
L2 Sprint 3: 3.5.4 INV04 Distribution Center Capacity
Hi, I used the formula for calculating total beginning inventory by referencing to beginning inventory in INV01 module and summing it by using Supplied by in SYS08 module but I'm getting negative values for total beginning inventory. Couldn't find out what and where I went wrong as the formula seems to be okay. Can someone…
-
Sales Planning Model: A2 List
Hi, I'm having trouble when trying to import into the Sales Planning Model: A2 List in the Sales Planning Model. I created the necessary System Module in the Data Hub in order to use to populate the A2 List. I also filtered the module so only the valid Account>Product combos show and saved as a view. I then imported this…
-
L2 Sprint 3 Distribution Center Summary Module
Hi, When the summary method is set to none there is no output for All Products and All Regions level but when I change the summary method to sum, I can see the output of stock exceptions line item. But the instructions states to set summary method in INV03 as none. Please help me to find out a solution to it. The summary…
-
Sprint 3 Dat03 Historic Volumes
I have done till half of Sprint 3 and was checking my data back . I found my DAT03 Historic Volumes Module are missing the forecast years. It is having value only till year 2019 and nothing further Earlier everything was working fine. Checked in history also , all looks good. Please let me know why this happened. I am…
-
Sprint 3 Work Check -- All disappeared
I have completed all the activities till 3.3.12 Create Product Replenishment page. But when I go back and see my module DEM03 everything is blank in this. Due to this the reorder flag is not correct in INV01 module . I went back and checked DAT03 Historic Volumes. It is showing me only till year 19 . not year 2020. Why is…
-
Sprint 3 Create Product Replenishment Page
Can anyone help me with the conditional formatting for ending inventory. I am not getting what to write for minimum and max value so as to get the red flag Regards, Ankita
-
L2 Sprint 1 - L1.3.10.2 Import Data into G2 Country list
Hello, Task require to import data into G2 Country List using the Build Country Saved View completed in an earlier activity L1.3.6.2. Below is screenshot of the mapping and import result. Import result I didn't designate a Parent in the mapping because the saved view didn't have Region for me to select from. Regions in the…
-
L2 Sprint 3 3.3.5.3 All Products level
Hi, I am getting values for Safety Stock Target line items when I switch to All Products level whereas in the course there are no values that are being displayed for the same line items. Please help me with this.
-
Data type mismatch: format other than LIST or DATE being referenced as a relation
Not sure what the issue is! Please help.
-
3.3.12 Create product Replenishment Page
I am trying to create UX page for this. I am getting all Checked by default in the saved view for the months but when I am using the same saved view in UX page I am not able to edit any of them. Selection of months in the top most grid. My Saved view All are editable in this. now in UX page They become uneditable. I dont…
-
GTM Certification
Community, Is GTM certificates/course available only for partners? Off lately seeing a lot of folks getting GTM certified RM
-
Level 1 Model Building 9.2.5 Adding the two formulas
When I try to copy and paste the formulas it tells me that the “Dimension of mapping used for lookup doesn’t match any dimension of the result” please help.
-
Formula not accepted in exam for FX
Hello, I need some help here. I am attempting the exam and I dont get why the below is getting rejected? This formula works fine <Formula edited to remove answer> I know this is exam question but I went through the FX task again and again and it is using the same format. Is there a point I am missing?
-
L2 3.5.3 INV03 Stock Exceptions formula
Hello, I have come across an issue with 'Stock Exceptions' and for some reason I get blank. If I set the Summary method as Sum, then it works but the task clearly says it should be kept None. I am attaching INV03, INV01 (source) and SKU08 if you can think if I did anything wrong there.
-
Anaplan Cerificate
Hi, I have completed my exam with 90% marks, screen shot attached. But the Level 1 certificate link if not available for printing.
-
Level 2 INV01 Begging inventory and Confirmed PO line item
Hi All, Please help me with the formula for Beginning Inventory My formula is - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory I don't know why I am getting everything negative in Beginning Inventory Also let me know If i…
-
L2 Sprint 3 INV01 formulas
Hello, I have finished writing up the formulas for all the line items, they also match the figures in next slide. How can I make sure that they are all correct (as there are multiple ways to write them)? Is there anyone in Anaplan I can email to verify? The reason I ask is few steps into the course I avoid a situation that…
-
Sprint 3 - INV01 - Confirmed PO line item formula
Hi All, I am stuck up on building the formula Confirmed PO Delivery . I searched on the forums and it says to use line item "Final Shipping Time Weeks" . But it is saying no where to create that line item. I am super confused Regards, Ankita
-
Level 2 Sprint 2 Detail Demand Review UX
I just finished building my detailed demand review UX. The top grid which is adjustments to demand does not match my bottom grid which is Initial/Final Forecast. And my Override option has disappeared on the UX page. When I go into DEM03 it is still there and nothing has changed. Why would my override option disappear?
-
Level 2 Sprint 3 Question 3
Any idea why below formula is wrong for this question? POST(Final Shipment Amount, Final Shipping Time Weeks)
-
Level 2 Sprint 2 Test as an end user
Hey All, I am not able to understand this testing and how it needs to be implemented. Please guide with step by step process. Regards, Ankita
-
2.4.7.1 Create Demand Forecast Grid UX saved view
Hi All, Please help me in creating the conditional formatting rule for this saved view. I am missing something. Regards, Ankita