-
Formula
Hi, I am following all steps but it doesn't work properly. where am i going wrong? Please guide me? Thanks, Mark
-
Level 2 Sprint 3 INV01- Beginning Inventory Calculation Not Working
Hi, I am sure I am using correct formula for calculating Beginning Inventory but my module doesnt seem to reflect that. Formula - IF 'SYS01 Time Settings By Week'.'Not 1st week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory. But output for first month is coming 0 since…
-
REV03 Margin Calculation Module
Hi, When I check the REV03 Margin Calculation Module in Level 1 Course, I see that Cost of Sales is greater than Revenue in almost all cases after Jan 20. Maybe I am doing something wrong but I think this is not normal. Can you double check them for me? Thanks, Mark
-
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…
-
2.4.7.1 Conditional formatting
I have added the conditional formatting for Final Forecast, but not sure what to do for Initial Demand Forecast to make it look like the material provided screenshot. Here is the rule I have in place currently My other question is if it is okay that I do not have any data like the material shows for FY21?
-
2.4.11 Creating Roles
I am stuck on creating the roles and which access to provide to make the dashboards visible. Will the dashboards not show if they were made on My Pages?
-
8.5.3 Activity: Import Data into Volume Inputs Module
Hi everyone, I'm getting this error message and I don't know what I'm doing wrong.
-
Level 2 sprint 2 2.3.13 Activity: Create Global Demand Assumptions UX Page
Hi All, The task is to "Build the UX page using the guidelines that follow" (screenshot attached) Previously I was asked to create some saved views to use for this UX setup. However, It seems that time is both a row and selector, allowing the ability to toggle between H1 FY20 and H2 FY20. Any suggestions or ideas on how I…
-
Level 2 1.3.10.3 issues
Hello All, I am having a bit of an import issue when trying to create the G3 List for my model. I have gone back and resaved my views to include line items in the view to ultimately import into my model. The view in question should look like the view with the white background, however mine is turning out like the…
-
FORMULA HELP
Havıng hard tıme on buıldıng formula doıng 1.5.7.2 any advıce wıll work
-
L2 2.4.3 and 2.4.4 DEM03
The micro-lesson on 2.4.3 shows some different formulas than I have been using and then 2.4.4 shows the fy21 baseline forecast populated. Is this information to be updated further in the L2 Sprint or where am I making a mistake?
-
SYS14 Automatic sum over Flat List not possible
The line item "Data?" in Data Hub Model: SYS14 module was asked to reference SYS12 SKU Details and SYS13 Account SKU filter which were created during Level 2 Data Hub. However, both SYS12 and SYS13 were using SKU Flat as dimensions (as instructed in Level 2 training). When trying to reference the two modules, I got error…
-
2.3.9.1 Import data into DAT03 "Expected week number in date/period"
Hi Anaplan fam! Since I have read almost every post about importing into DAT03 and checked the instructions many times, it seems I have exhausted all possible options. The only way I can import from Datahub is by using Match names in the Time tab. When I add line item "Offset Volumes for 1st Forecast Year", the value is…
-
Formula
Hi, I don't understand it doesn't calculate margin/revenue properly. Thanks, Mark
-
Starting Your Anaplan Training
Getting ready for Anaplan is key to a collaborative and successful project, and our Level 1 Model Building course provides the quick start you need! Level 1 Model Building is comprised of 15 parts and a certification exam that gets your team enabled, empowered and excited about using Anaplan to drive business value.…
-
Page Builder Training
Hi All, I am trying to locate Page Builder Training. Can anyone help please? Thanks Karolina
-
Level 2 - Sprint: Activity import Data into DAT03 Historic Volumes Module
Hi guys, I've been trying to inport the 'Historic volume.csv' to the DAT03 Historic Volume Module for the past 2 hours. I already watched all the videos about importing data to module, etc. But I keep receiving this error, "invalid line item identifier", and I don't know what else I can try. Could someone give me a hint?…
-
Formula
Hi, Although I am following all the steps, 'Cost of Sales' line item shows different value (more than revenue) for the years of 2020 and 2021 in my module. Can you guide me, please? My screenshot: Expected screenshot: Thanks, Mark
-
Anaplan Connect 3.0 Training Refresh
The Anaplan Connect training was recently revised to include updates and best practices. Anaplan Connect is a simple connection tool for integrating data to and from Anaplan. This training provides an overview of Anaplan Connect 3.0, this includes: * 3.0 Overview * Setup requirements * Anaplan Connect Guide * Downloading,…
-
DEMO 03 Demand Forecast. Baseline Forecast formula
Hi, I am trying below formula for Baseline Forecast, its working for FY20, but for FY21, data is not populating as expected. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Final Forecast, -52, 0) Below is the Time Ranges selected for…
-
9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module Error
Hi, After I add Formulas to REV05 Price Growth Rates Staging Module, checking my work with the instructions as below: In the REV04 Price Growth Rates module, change the page selectors to US and Chocolates. Enter 5.00% for the FY19 Unit Cost %. Then, open the REV05 Price Growth Rates Staging module. Change the page…
-
Level 2 - 2.4.4.1 Update DEM03 Demand Forecast Module
Hi I dont think I'm doing this right. I've produced a correct looking output - which disappears when I change Hierarchy levels. The clue I think is in the words " Next, look at the Summary Method settings for the line items. * The Demand Forecast values will be viewed at every level of the Product hierarchy - by Product…
-
Level 1 Exam - Question 5
Need to update the formula in EMP02 with EMP03's info. But I keep getting an error and I have no idea where I have gone wrong... Can anyone point me at the right direction? This is the formula I used... IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP:…
-
filtering
Hi, Despite I filtered the module for monthly forecast, it shows same. My screenshot: It starts from Jan 19 but it should start from Jan 20. Expected screenshot: Thanks, Mark
-
Time Settings
Hi, I've changed the time settings a few times to fix the problem, but I haven't yet gotten the result I expected in my pages. I couldn't find where I went wrong. Please guide me... By the way, is there a risk of losing data when changing the time settings? Do I need to import again? My time settings’s screenshot : My…
-
REP02 All Sizes breakdowns are not appearing in Grid UX view
Hi everyone, I need to see this on REP02 Grid UX view: (please look at the red circle) However I can't see the breakdowns of "All Sizes". There's nothing under it; so I can't select 100g. There is no filter applied to the size. What I am getting is this: Thanks for any comments or recommendations in advance.
-
Level 2 sprint 3 Build Distribution Summary Dashboard
In the activity following instructions were given, where I am confused with the highlighted one 1) Applying a filter to DAT01 Beginning Inv - I am confused as in how to show which Product SKU is stored at which distribution center, what i thought was in the line item Nutzo bar EN SKU & New york as distribution center…
-
Hiding column
Hi, I want to hide the column showing FY21 in my pages. Could you guide me, please ? Thanks, Mark
-
SYS06 Sprint 1 L2 Mapping Problem
Please help , I am not getting the desired result.
-
Review SYS05 Region Details Module
I am not able to connect SYS05 , SYS06 , SYS07. Please guide Please resolve