-
Level 2 Sprint 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module
My Export View from the Data Hub model always has the Line Items of Volumes as a column. The first column can't be ignored in mapping. Although the data can be imported correctly, there's always an error message. Is there a way to avoid this? How I add pivot the view so that the Volumes wouldn't show up as a column? Thx!
-
Level 3 User Story 1.5 numbers mismatch
Hello. 1st question - is this total for the US? 2nd question - We match on Candyate but we do not match on All Accounts. Has the data changed? Or is it me doing something wrong? Training Screen shot: My screen shots:
-
Level 2 Sprint 3 TRA01 module creation
Hi - I am facing issues when trying to create the TRA01 module. I am getting zeros when I am trying to map the weekly values: TRA01 module - formula Shipping Time = WEEKVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)') Cost per 1000 Units = WEEKVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units') Results Please help…
-
Hi. Who can help? :) filters from saved view do not remain active on grid view on my pages
Hi. Need some help :) I am at the lesson 13.6.3 point to add a grid card on My pages. The issue is that the saved view from the module part, with filters and some hide line items do not remain available when I selecte it to the grid card side. The filters remain active but the hide lines appear again on the grid card . Do…
-
Can someone HELP on User Story 1.6 PLEASE
Can someone dummy it down for me and tell me what two modules should i compare here? I do NOT understand what exactly am I being asked to do. I did this and I cant understand AM i wrong? Can i move on to next user story without downstream impacts? Am I way off? Am I missing something?
-
How to return the day os the week (e.g. "Monday") based on the date of the module
Hi, I have module with time scale "day". I have a line item called: Workday, and I need it to return the day of the week (e.g. "Monday") based on the date of the module. I need this so that the person has to tick only the weekdays. Can you help me ? Thank you in advance!
-
Which Model Builder Training Program is Right for Me?
The Anaplan Academy has training solutions to fit the needs of every aspiring model builder. Use the chart below to determine which program works best for you. Paid Programs Public Workshops | Private Workshops Free Programs Talent Builder Guided | Talent Builder Independent | On Demand Training
-
Absolute value on List
Hi Community, I would like to inquire something to make absolute value on a module with specific list members only.So the requirement is that the COS and Admin list members will be alsolute value. see below. Blueprint view: only the highlighted items should have an absolute value. the columns are the line item and the row…
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
I do not seem to be seeing the 1st Forceast Year as a line item in my SYS01 Time Settings by week module. Could someone assist me with what the problem could be?
-
Extending a week
Hi All, Is it possible to add a week in the model calender for a new year without adding a new year in the time settings. TIA.
-
Level 2 Sprint 3 Product Replenishment UX Page
Okay so I've been stuck at it for so many hours now. First, I'm noot able to add the instructional text to the grid card. Second, I'm not able to do the conditional formatting for the INV01 module in the UX page due to the min and max. I'm attaching the screenshots, please help!
-
Error
Hi Community, I was trying to follow the instruction given by @pyrypeura on conversion of time to text. I followed how he made it but I keep getting error. Am I doing something wrong here? Kindly correct me if I am doing something wrong. THanks and Regards,
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell Access to perform as shown in the example below: 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…
-
Date Conversion
Hi Community, Can i have help in converting date into a text formatted version date. Like1/1/2019 convert it to January 01 2019. I already have the days line item I just need to convert it to a text format date. Any ideas is welcomed, Thank you and Regards,
-
Lvl 3 TAR04 Account segment total by country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the individual segment data(small,medium,large) aren't. See attached image; first grid is my build and second the one from training. I checked my system module and all segments are mapped to each account. what is it that I am missing?
-
Anaplan Level 1 Certification cost and support
Does Level 1 and Level 2 certification cost me anything? Will able to download the Anaplan Certificate after completing both the levels? What does instructor led version mean? Please brief. Please find the attachment.
-
Level 3 - User Story 1.6
Why am i getting 0s in Previous Year Actual Revenue - even if i use the SUM: 'SYS03 Account>Product Details'.'A1 Account' for the SUM, i am still getting ? Is my Initial Account Sales Targets correct? What is the math for Final Account Sales Targets? Do you want me to show Final Account Sales Targets in TAR04? What exactly…
-
L3 Account Segment by Country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the segment data aren't. See attached image; first grid is my build and second the one from training. My understanding is that this would happen is I dont have the right Segment for each Account. Can you let me know if this is possible?
-
LEVEL 2 SPRINT 3 ENDING INVENTORY
Hi, I am using this formula for ending inventory: Ending Inventory = Beginning Inventory + Confirmed Purchase Order Receipt- Forecast Demand but i am getting the following error message: 'INV01 Inventory Ordering'.Ending Inventory has NUMBER format but the formula resolves to BOOLEAN format Please help! Thanks
-
Decimal difference
On the L3 training: Why does your screen shot include decimals in the lowest level and does not calculate in decimals on the lower levels? My results are all one decimal place. If i leave it with one decimal place would that cause me mismatches downstream?
-
Level 3 sprint 1
Hi Experts, A couple of weeks ago, I imported data into the below module. Then, I summarized the above data into the below module. I have no clue to get data PY Country and Product Family Sales in the below module. Please advise me. Regards,
-
Find item function
can someone explain how finditem function work with an example?
-
Line item to match boolean
Hi Community, I would like to ask a little bit simple question. i already have the Current Month +1 line item working. So now the requirement is to match Current month +1 to a line item which is a Boolean. I tried the formula IF item(time)= Current MOnth +1 (text) then true else false. it was not accepted. I am thinking…
-
Level 3 - % question
I am getting the exact same amounts are per the screen shot from the training. Why does your % show as 105? If i leave mine the way i have it would that cause me any issues with the training downstream? Thank you
-
Level 1 Exam attempts
Hello, Where can I find the number of attempts to clear the Anaplan Level 1 exam . Its only mentioned we can take the exam again in the Exam module. Thanks
-
Lost all modules and apps
Hello to you all, I'm preparing to take the Level 1 exam. I finished all the exercices (modules and apps). I dont know if it's due to the maintenance schedueled the 25th or something else but I lost all my workspace last Sunday. I have mailed Anaplan to see if I can get my workspace back but I'm afraid i wont have enough…
-
Level 1 activity 3 ... look up returning double desired amount
Hi, i understand what my problem is but i cant seem to solve it i am using a look up to link 2 modules together see below 'DATA02 SKU Volumes'.Volumes[LOOKUP: 'SYS04 Location Details'.Country] However i am not able to find a module that contains a list of locations i can map my look up to, the above is returning the double…
-
3.3.5.1 Create Inventory Ordering Module Confirmed Purchase Order:
Hello, It seems my confirmed PO delivery and Confirmed Purchase Order Recipt are always zero. Does my confirmed purchase order formula look correct ? Confirmed Purchase Order: IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, Shipping Time Weeks, 0) ELSE 0
-
Next month label.
Hi Community, I have a simple question and a new requirement by the client. What the client wants is to display in the title page a label that shows Next Month. So for example if the user selected a Jan 23 time, the label on the header form our sys module will show Feb 23 instead of Jan 23. Right now we have a sys module…
-
REV 03 results discrepancy. No data shows in year 2019
I do not get any data for 2019. Data start just in 2020 REV03. Would you be able to tell me where I can look for the mistake