-
2.3.10 Activity: Create Demand Forecast
Can anyone help what's wrong here? Not getting the required values.
-
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
-
How many hours of work would you estimate it takes to obtain "Certified Anaplan Model Builder"?
Specifically referring to the timeline from the beginning of level 1 trainings, through "Intro to Polaris". If you could also provide an hour estimate to becoming a certified solution architect. I understand there should be 9-12 months of real-world project experience. For this I'm just concerned about the hourly…
-
regards to talent builder program..
I submitted a request for access to the workspace this Monday, but I haven't received any updates on my application so far. Is there a way to contact Anaplan members to inquire about gaining access to the workspace for practice?
-
L2 INV05 Shipping Cost Conclusion
Hello, Im having an issue where my values for the Shipping costs on the INV05 Shipping Export module are much larger than what the training check your work has presented. I know there is a disclaimer at the bottom of the check your work that the values may be different but mine seem to be much larger. I want to know if…
-
Where can I find Location details for Accounts in level 3 Sprint 1
Hi, I am completing the Level 3 Sprint 1 and there is repeated references to Accounts rolling up to Locations. I can't see anywhere in the Model or the Data Hub where that relationship is spelled out. There is room for Location and Country in SYS02, but the field is blank so none of the formulas work. I assume that you…
-
level 3 Model Builder
Hi, I'm going through Level 3 at present. When I complete a task in the Sprint, I can't view the details when it tells me to compare my work. The worksheet to compare is not viewable on the screen. Is there any way that I can download the comparison files so that I can log my progress as I'm going along?
-
Level2- Sprint1- 1.3.8 model to model import-unable to import parent from saved view build location
Level2- Sprint1- 1.3.8 model to model import -unable to import parent country column in G3 Location list from saved view - build location. Please help me out to resolve the same.
-
Level 2, Sprint 1, 1.7.3.1 Import into P3 SKU list
Hi all, I'm trying to import data into the list P3 SKU, and faced some problem. Please attached the screenshots of the step-by-step of what i did and the problem. Kindly need help to resolve this issue. Thank you so much!
-
l2 INV01 Inventory Ordering - Confirmed Purchase Order Receipt
I currently have used two different formulas for this line item. They are: IF Confirmed PO Delivery <> 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0 And: IF Confirmed PO Delivery = 0 THEN 0 ELSE POST (Final Shipment Amount, Final Shipping Time Weeks) These both appear to work perfectly fine in my…
-
L2 INV03 Distribution Summary - Stock Exceptions
I wanted to get some help with my formula for the Stock Exceptions line item. Previously my formula for this line item was: INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product] This worked, but was giving me large stock exceptions and was unsure if it was correct or not because the…
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hello, What am I doing wrong here color coded DCA not working ? Below are formulas for AD02 module and access setup for INV01 ? 'INV01 Inventory Ordering'.Submit Purchase Order Request? 'INV01 Inventory Ordering'.Submit Purchase Order Request? AND 'INV01 Inventory Ordering'.Override Suggested Order Amount? 'INV01 Inventory…
-
Level 2 Sprint 3 - 3.4.4 Stock Exceptions UX
Hello! I am struggling to complete the 3rd grid for the stock exceptions review UX. It is not syncing with the Region context selector. Grid 1 and 2 seem to be working correctly. Grid 1 and 2 pull from INV02 Country Summary Grid 3 pulls from INV01 Inventory Ordering INV01 doesn't have a geographical dimensions, I'm not…
-
Moved: Anaplan Certified Solution Architect FAQ
This discussion has been moved.
-
Level 3
Should I build the dashboards in the New UX environment or the Classic environment?
-
Level 1 Exam - Activity 5
Please confirm if the formula is correct for Medical Costs. I missed the link now (and a bit lost),since My question 5 got wrong.I undertand model building activity in Question 5 is to be proper to answer question 6. Now i want attempting Question 6 and not clear what formula to use for answering question 6. Urgently…
-
Activity: Prepare Data Exports - comparing results to INV01 Inventory Ordering.csv
In the Level 2 Conclusion, Activity: Prepare Data Exports, Anaplan gives a csv to download and compare our results to. Is anyone else having issues with their numbers tying out? After a lot of analysis, it seems the Weekly Order Schedule that I uploaded from the Level 2 Sprint 3 exam is not what should actually be loaded.…
-
TAR03 Country Account Calculationを使用するべきかどうか
本来ならば行うべきではないのかもしれませんが別の方法でユーザーストーリー1.7~1.10を解決してしまいました。 TAR03 Country Account Calculationのモジュールを使用せず、自分で新しくCALCモジュールを作成し計算をさせました。 そのためTAR03 Country Account Calculationのラインアイテムを作成できていないのですが、作成するべきでしょうか？ また、作成するべきであれば添付ファイルのラインアイテムのどれがTAR03 Country Account Calculationのそれぞれのラインアイテムと等しいのかヒントを教えてほしいです。 例：TAR03 Country Account…
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
I want the check boxes to appear the same way as desired output below. Any assistance would be valued. 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 (however, in the example nothing is writable).…
-
Level 2 Sprint 2 - 2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Hi Experts - I am trying to understnad the way to Get the Weekly value for the "DEM02 Volume Growth Rates by Week module ", from what I understand, based on the Montly Growth % in the DEM01 DEM02 has to sholw the weekly Growth %. And I intially tried to use the WEEKVALUE formula but that did not work and when looking at…
-
3.3.6 Air Override not showing correct figures for Nutzo Bar_EN
Hello, Below are my formulas and lists I overrode with shipping method AIR. I believe its related to way my list is setup see below, any insight would be valued. Air resutls for Nutzo Bar_EN not showing correct. Final Shipping Cost Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time…
-
isblank
Hi how to apply ISBLANK in Boolean format for multiple columns. I am not getting error if it is one column but if it is for multiple columns Im getting error IF ISBLANK(Market) THEN TRUE ELSE FALSE
-
L2S3 Activity 3.3.12 Sys01 time settings by week module
May I know if I have this correct: Line Item Planning Period Filter: the formula is 'Sys00 Time settings by month'.planning period filter Line Item Planning period Filter weeks only: monthvalue('Sys00 Time settings by month'.planning period filter)
-
LM2 - Data Hub SYS13 - Formula Hint 2
Hi Team, In the Data Hub in module SYS13 Account SKU Filter you setup a Boolean line item to determine whether there is data in DAT03 My formula to be used would of been: TIMESUM(DAT03) > 0 or TIMESUM(DAT03) <> 0 The 2nd Anaplan formula hint is below: This is confusing as when/why would you use a Number (1/2) to determine…
-
Anaplan bring data to future week
Hi, How can we calculate the collection of Revenue for future week? See example below, our Week13 fy24 data is to be collected in Week18 Fy24. Thanks in advance for helping. Regards, Tom
-
Formulating and capturing the no of orders count based on orders placed between time scale.
Hello Community, Process explanation based on below screenshot is basically on the left part we have module in which time is recorded for the orders placed and we need to gather and capture the count or no. of orders placed between the time series. EX: Orders between 14-15 PM is placed at 14.30 PM and 14.45 PM we need to…
-
Question on Sprint 2 Detailed Demand Review Dashboard
Hi - UPDATE: 24 April 2019 - I had an error in one of my formulas (found out on Sprint 2 exam) that I corrected (retook test to ensure I had it fixed the issue). I had thought that by fixing that formula it would resolve the below discrepancy but it didn't. I have a question similar to this one posted in Anaplan Platform…
-
Parenth
Hi all, a simple one this time. I am trying to get the parenth member of the list. But I keep getting this error. my formula as i remember it is Parent(Item(L3 Department)). then i got an error on it Any idea what I am doing wrong. Appreciate the help on this one. Regards,
-
Account Assignment
Hello, I also have a question concerning assignment. I don't understand how it can be possible that an account may have more than one territory assignment. The account is unique and we assign a territory for it or change it but it remains only one territory by account from my understanding. Could you please explain what I…
-
My request to join Talent Builder Independent has been declined, what should I do?
Hi, I just got the Anaplan Way Course Certificate. I fullfill all the listed requisites as well, but the request to join the Talent Builder Independent Program was declined. I'm wondering if I did something wrong. Is there any chance of requesting, or getting these 90 days free trial access without having to wait 30 days?