-
2.3.9 Activity: Historic Volumes to Baseline Forecast
I am having trouble with 2.3.9 Activity: Historic Volumes to Baseline Forecast and 2.3.9.1 Import data into DAT03 Historic Volumes module. For the first part, I'm unsure what needed to be done, if anything. Then when I tried too run process 9, this is the error message I received. Can anyone help me with what I am doing…
-
Error -'Another row has already been processed with this key'
Hi, I was trying to import data from a module to a list and I am getting the following error- "Another row has already been processed with this key" Current chapter fro reference- 1.4.5 Activity: Import Data from Saved Views I have attached the error screenshots for reference
-
formula help on L2 Sprint, task 1.4.3.2
Hi In the above task on L2 Sprint 1 I have set up the module and imported the data into SYS12 SKE Details module, however drawing a blank on the requirement to 'Add the formula for the Code line item' I need a steer on what this means and where i might build the formula please Thanks Simon
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, Can someone help me out with this issue of running 9 Import Data Hub:
-
Can anyone make a suggestion please? Level 1 6.11.2 Budget$ Formula Error
Hello - I am getting a formula error when trying to enter the formula for Budget$. Please see the attached. Thanks for any assistance!
-
Import Shipping Expenses into OTH01 Module
I don't understand why we added the code line item to INV05 module. I deleted that line item and I was able to complete the import process without a problem (I changed the time format to MMM YY). However, I am getting errors in the presence of the code line item. I got the error "Invalid date or timescale identifier". When…
-
2.4.7.1 Create Demand Forecast Grid UX saved view
I really need some help for this step. I completed to first conditional formatting rule set up for Final Forecast line, but I have no idea how to set up the for Initial demand Forecast. In case, I attached example from training and how I set up and result that came out. Please help me with this. Thank you
-
Level 2 1.7.3.2 Import into SYS08 SKU Details module
Hi Folks, I am facing error in Distribution center Mapping. attached is my model view. Please guide .
-
2.4.8 Activity: Create Detailed Demand Review UX Page
Hi, I am ask to do this... However, this is my screen, how do to have the Jan20 filter? thanks in advanced.
-
Rounding Currency Rates
When I import a .csv file, the values are rounding in the module. I have checked the layout and the row is set to NUMBER with Decimals set to true. Why is this rounding the values that are imported?
-
Referenced by column in blueprint
Dear Friends, While working in Level 1 Model, in REV04 Price growth rates, blueprint, i see the referenced by column refereeing to REV03 margin calculations, I have not put any formulas, how is this happening? Thanks in Adv Tej
-
L1MB Creating a module
I am having an issue populating the right information. After I create the module I complete all of the steps yet my model does not pull up the correct information. Does anyone know if I am missing something? The first picture is what is supposed to be there and then the second is the one mine looks like.
-
3.3.3.2 Import Data into DAT04 module
While trying to import Distribution center parameter from Datahub to the DAT04 module in Supplychain, I can't manage to import data (ignored). I don't know if it hs something to see with the data in Datahub is stored on Half year whereas the DAT04 where I try to import data is structured by week/month. Could anyone help me…
-
Upload the Territory to Accounts data file into the Sales Planning model.
Hello! I am stuck at the point where I need to upload the territory to account data from the CYW Scenario Territory to Accounts.csv file. In order to populate the G4T Territory>Account# list, I need a Territory and Account combination code which is not available in the csv file. Do I need to create a module to upload the…
-
Level 3 - Quaterly Distribution Percentage according to previous year data
Dear Support, I think my Quarterly % calculation is not correct because according with the example on the user story 1.11: The Years total is correct in my case but not the Quarters: Based on training explanation the % should be calculated considering previous year data, therefore I've created the following line items: -…
-
Level 3 Model Building User Story 1.7 - 1.10
Hi Community, I had a question regarding the Override, Hold and Redistribution factor module using TAR02 and TAR03 modules. Is there a function that enables a SUM process excluding accounts that have Override or Hold selected? I tried a SYS module using the List Lookup as a potential to overcome this problem. I had two…
-
Model building Lv2 version
I just begin my level 2 model building, and realized it demonstrated with classic version not NMX. Should I do with classic version or can I still work with NMX version? Thank you
-
Unable to map time in Level 3 user story 1.1
Hi all, I just started my level 3 training and I'm having issues. I've tried almost every combination and I cannot map time for some reason. Does anyone know why? I'm sure it's something simple.
-
L1 Activity 6 - Wrong Calculations... Help Please!
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from SYS08: I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.…
-
Level 1 Model Builder / Building 8.2.1 Activity
Hello, I am having some trouble with page selectors not showing up as expected. Here is the expected output from the lesson: Here is mine showing up without page selectors: I had some trouble mapping in the data upload for employees in lesson 7 but that shouldn't be the problem. Is there a quick fix or anyway to tell where…
-
Level 2 Sprint 3 Question 3
Any idea why below formula is wrong for this question? POST(Final Shipment Amount, Final Shipping Time Weeks)
-
FAQ for Anaplan Live! Free Class Promo
This promo offer expired on May 31, 2022. What do I do if all the classes are full? If you have not used the promo code yet and the class you would like to take is full, we encourage you to register for one of the waitlists. Based off this demand, we will add more classes. You must have either registered for a class or be…
-
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…
-
L1 Exam Activity 6
How would I go about adding Department and Role to SYS08? I don't believe that was a part of the exercises which I followed step by step. This is what I have for my SYS08: I have Department and Country...
-
L1 Exam Activity 5 - Stuck for a Week, Spinning Wheels
Hi all - I have been stuck on the L1 Exam Activity 5 for over a week now and the 'hints' have not been helpful at all. I have been spinning my wheels and do not know where I am going wrong. This is the formula I used for bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'EMP03 Employee…
-
TAR01 Level 3 Model Building
Hi, Would like to know if my DAT02 Formula and Dim are correct. I'm not able to LOOKUP or SUM in Country and P1 Product Family into my TAR01 Module and it is saying because Dimensionality. Below is a screen shot. dim is A2 Account>Product Thank you
-
Level 3 Model Build TAR01 Module/SYS03 Module
Hi, I'm having trouble with putting together the TAR01 Module. I understand the task is to get the Total Revenues of my Products (P1 List) by Country and it's "Children" (G2 List), and then fine the percentage of that by dividing by total annual revenue of a country (Total Annual Revenue by Country and Product / Total…
-
SYS08 Employee Details Region and Role
Hi - I am trying to bring in Region and Role. I added them as a line item in my module: Here are all the modules: And here are my lists: Can anyone help me with how to write a formula to bring in Region and Role?
-
Dependent dropdown
I want to create dependant dropdown for Accounts (Dependent on Country and Segment) to complete the user story 2.5 Level 3. However I am able to select only one either country or segment. How can I create account dependency on both? Thanks -Pooja
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Been trying to run the 9 Import data hub process and getting error and values are being ignored