-
3.3.5.2D Remaining Line Items , Reorder flags
Hello can you help me in perfecting my formula ? Reorder Flag: Identifies the week that an order must be placed before the ending inventory would drop below 0. As you see in the week 11 FY20 column, the reorder flag is not ticked even though the value is negative My doubt is, as per the hint, they suggested the use of the…
-
2.3.8.2 Import into DEM01 Module
Hi everyone, I'm having trouble importing the full data of the import file (Volume+Growth+Rates.csv). Here is my import mapping: The failure log: I don't know why there is data not being imported whilst having the same import pattern. My result: I have tried deleting the module and the import file (without opening it in…
-
3.3.5.2A Beginning Inventory formula
Hello I need some help in this formula Beginning Inventory: 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 for all other weeks of the year. i have just created these in my…
-
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…
-
Level 3 Sprint 1 3.2
As a Regional Sales Executive, I need to be able to add an annual percentage increase “stretch goal” to the Baseline Financial Forecast to establish the Initial Country Sales Target for each country that I manage. After completing the necessary model building activities to allow for the input of the percentage increase by…
-
TAR01 Detailed Sales Targets
Hello, I am having trouble getting my TAR01 Detailed Sales Targets check to reflect "1" for each country/product family/quarter intersection: compared to correct result: Am I on the right track with the PY Country and Product Family Sales line item and underlying Baseline Financial Forecast line item? I believe the data…
-
Hi Anaplanners, I have just started with the L3 course and I am stuck at the Target Review UX build
The ask is to design a UX prototype but I am not sure where to start with it. Any leads on that?
-
Level 2 Sprint1 DAT02 Shipping Metrics having problem in importing data
-
1.6.2.1 Import Data into DAT02 Shipping Metrics Module
Seem to be having some issues importing if anyone can assist ? Several issues Date mapping Expected character in date/period: FY20 Shipping methid plat and product flat tab don't seem to be correct screenshots provided
-
Level 3 TAR01 Detailed Sales Target
Hi Community, Needed some advice here. I understand that in order to get the PY Country and Product Family Sales amount, I will need to use PY actual sales sum by country and product family. However, how can I get the actual sales by country and product family when both my DAT01 PY revenue (imported from DAT05 in datahub)…
-
Anaplan Level 3 Badge
Hello everyone, I have one question. Do we know more or less how long it takes from the level 3 exam to receiving the badge? Thank you,
-
Anaplan Level 3 Badge
Hello everyone, I have one question. Do we know more or less how long it takes from the level 3 exam to receiving the badge? Thank you,
-
regarding L3 certification
Hi I am trying to reach academy to access tenant to access my previous models to complete my certification. I am able to access with workspace but it is empty now. Would some one guide me to how can I get it back my models and data hub for L3 certification. regards Mahesh
-
How to assign roles to Employees
I Need to assign two employees with analyst as a role to third employee as a Manger. As what ever the locations are accessible for analysts should also have the access to Manger.
-
Import stops at 91%, no model won't open on workspace anymore
Hey there, we have 2 workspaces. We have built different models on both WS and started imports from a large CSV. In both cases, the import stopped at 91%. Going back to model manager and stopping the process yielded in "model XYZ (closing)". When refreshing the page, we see all of our models, but cannot a) open any model…
-
Level 2 - 3.4.4 Activity: Create Stock Exceptions Review UX Page
Hello, As i am currently doing this activity, I am a bit lost with the 3rd Grid : Stock Exception count by product SKU and total for the parent Product at monthly, half-year, and year time periods. We are supposed to be using INV02, though in this module we did not aggregate by SKU but by product family so I am missing the…
-
How to create an import button?
2.3.13.2 Create a User Experience Page: The above is how my page looks, but I couldn't find out how to create an import button for end user manually enter monthly product Volume Growth Rates
-
Activity List for Level 2 Sprints 1, 2, 3 for repairing/fixing issues.
Made this as a reference since I haven't found one and needed it for my issues with my Sprint 3. It shouldn't violate anything as it is only indicating which activity is at which lesson number. MPW
-
2.3.10 Activity: Create Demand Forecast (Big doubt )
Hello Everyone I have a logical question to make sure my approach and formula is correct for demand forecast in question on the LEVEL 2 SPRINT 2 activity . As we see, we have to create the baseline forecast for the current FY by importing the historic volumes data to the current FY from previous year FY19 data which we…
-
2.3.10 Activity: Create Demand Forecast Sprint 2
Hello Everyone I have a logical question to make sure my approach and formula is correct for demand forecast in question on the LEVEL 2 SPRINT 2 activity . As we see, we have to create the baseline forecast for the current FY by importing the historic volumes data to the current FY from previous year FY19 data which we…
-
1.3.6.1 Create Build Region Saved View Level 2
1.3.6.1 Create Build Region Saved View Create a saved view for importing: Module Name: SYS05 Region Details Saved View Name: Build Region Include: Code and items Make sure to select SHOW for the Code line item and save the view. This will ensure that as new line items are added, they will not be included in the saved view…
-
DCA configuration in Level 3 Model Building
Hi, Can anyone confirm the user story for DCA configuration in Level 3 Model Building? Is it User Story 1.12? Also, can anyone confirm how can I test it? I mean how can I confirm whether I have created the DCA module correctly, as there aren't any screenshot available. Thanks BB
-
I am looking for use cases where we can use textlist function in a real project
-
User List Subset
I want to introduce a user dimension to a module with has 3 more lists. Due to huge cross section of dimensions, I am not able to add the user dimension. What are the possible workarounds for this problem statement?
-
Cant able to open Sprint 1 course in Level 2
Hello Everyone I have finished Level 1 and got the certification and continued to Level 2 introduction class, and I have finished it . but when I opened the sprint 1 class, the cursor was not changing to the input method ( hand symbol ) to click and start the course. the course open button remains like the text Can I know…
-
Mapping Time
Hello Anaplan's community , I created a time range FY19 so the time format will be " Week 1 FY19"," Week 2 FY19" and so on ( see picture 1) ! I want to know to set up time while importing my file ( what format I will choose) in order to get the file uploaded. And what column i will put in the the blurried area in yellow (…
-
Level 1 model building exam
Hello everyone😊 I am going to take level 1 in a couple of days. I am a bit stressed about exam questions since I feel it is a bit hard to write formulas and design system time settings etc; I feel it will be so hard for me to develop the output by just giving user stories and data . it was quite helpful when they guided us…
-
level 3 - 4.7 Check Your Build
I have completed this but wanted to check: my numbers seem correct (totals) but I have sparsity in my data also - null values; is this correct? Please see my attached screen shots for dat02, a2 account>product list, and screen shot for checking build. Can someone guide me if this is correct?
-
Level 2 Sprint 1 - Lesson 1.3.3 Import Data into Region Flat list
Hi All, I am not able to import the flat file into the Region. Please help. Attached are the screen shots. It says 0 updated. Please help. Regards, Ankita
-
Level 1 - Activity 5
In EMP02,The line item, Bonus has been populated but I am getting 0 for car costs, phone costs and medical costs. here are the formulas used, IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus%[LOOKUP: 'SYS08 Employee Details'.Department LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 IF Employed? THEN 'EMP03…