Modeling

Abnormal behaviour of Actions
Hi Anaplanners ! Is Anaplan facing issues in the Action Mappings? I had renamed few line items(eg: Line Item A renamed to Line Item B) in the model, and tried to test the actions, but none of them worked. When i checked the mapping of the actions, what i saw is really strange. I saw two line items (Line Item A and Line…
New Modeling Experience Quick Edit in Formula Editor
To all the Model Builders and SAs using the New Modeling Experience - we have a new feature that just dropped today. We have just switched on a new formula editor feature to help you quickly enter edit mode if you have edit permissions. How it works You can kick off edit mode by: * Double click (left mouse button) in the…
Summary of Visible Items Only
Note: please send Kudos to this post to get it on the roadmap. Please can either model builders or end users have the option to toggle the summary method used on lists where it is possible to view the total of visible items only. For example, consider a list Countries in a module with one line item, Revenue. Countries…
not recognised as a hierarchy
Hi getting below message when I try to add formula to code as per 6.8.2 Activity .
Add Syntax Highlighting
As a Model Builder, I would like to have "syntax highlighting" when I create my formulas in order to improve readability.
Missing data when importing flat file
Hey! I am facing an issue when it comes to a data import. I want to build lists based on a flat file, and I get the file from another system, so I do not have option to modify the source file. The file structure is like the one below: Product CategoryProductCatregory AProduct A Product B Product CCategory BProduct…
Spare Anaplan Talent Builder Account
Hi all - I am trying to learn Anaplan and am currently on L1 model building training. It says to "Click to download a copy of the Level 1 Model Building 2.0 (New UX) model" but I am unable to do so because Anaplan requires a separate account from Anaplan Community. Since I am not currently with a company, I have to use an…
Values not being displayed in the TAR01 Detailed Sales Target module.
Hi, I am unable to view the values even after entering the formulas in the TAR01 module. The dimensions are quarterly but no value is being displayed in any format. Please refer the screenshots attached below. Please help in this anyone. Regards,
SYS05 Region not populating with Region List
Hi, The 'Region list' is populated but still the 'SYS05' code line item is not populating with the region code. What can be the issue. I have not made any changes to the 'SYS05' module. Screenshots attached. Pls guide.
New UX - Formula Editor
Why doesn't the new UX for model builder select Line Items when you click on them from in the Formula editor?
Activity: Import from Data Hub to Supply Chain model
Hello, Below is the prompt from Level 2 Model building. My question is the following: 1. How does one import a saved view Data Hub Model into the P3 SKU list? What am I missing? What am I mapping to the Code, Parent, and P3 SKU? a. The import video & materials don't seem to go over importing modules into lists Please advise
List properties in formula not clickable (new modeling experience)
In the new modeling experience, list properties cannot be clicked anymore to be automatically added in formulas
level 3 tar01 - initial acc sales target
Hi clarificiation - I used 'TAR00 Sales Targets'.Initial Country Sales Target * 'PY Account / PY Country Product Family' I see these results the total for candygate relates to learning center screen : the problem is the formula totals everything for all accounts; so i feel it is incorrect and requires an edit - lookup ‘PY…
Mailto Limitation
Anaplanners, I have created a mailto logic which is pretty comprehensive which has around 10 questions and each question has about 2 lines in it. But the number of characters come around 600, i'm using quote remover logic to para-space each questions. I'm also using some line items to get results for some of the questions…
FINDITEM of first 3 character in List
Hi, I have a module with say a Product dimension consisting of 3 Letter product codes, e.g. APP, ORG, PEA. I would like to find these items in a list where the Names in the List are 5 Letters e.g. APPUS, ORGUS, PEAUS. How am I able to lookup APP against the list of APPUS (first 3 letter) and return ÀPPUS?
New User
Hi All, I am logistics professional and i want to learn the Anaplan and need your guidance to start the journey. pl help. Regds, Chetan pophale
Find a list member based on boolean check
I have a scenario module dimensioned by scenario. And a line item formatted as boolean. Based on the selected boolean check, the corresponding scenario should appear in a 'scenario' formatted line item in a module with no dimensions
One place to Manage all Saved Views
As We moved to New UX, There is immense work related to managing saved views from modules. urrently set up does not allow to edit Saved views with ease. Having a single place to manage/edit saved view like we have a button for Modules/Dashboards will make a significant difference to Developer life. Thanks Ramu
Getting Error "format of mapping used for lookup doenst match any dimension of the source" no clue
I have a source module dimensioned by tmpSalesTerritory list, that is a numbered list Need to get “final_segment_country” and put it in this module below on yellow marked The problem is when I lookup the value from property module I received the msg below… Can you help me to understand what is happening? Since I getting…
FIND Function
Hi Team, I'm using the FIND function for the 1st time & it not working as I expected. It seems like a basic Function so I must be missing something easy but I would assume that below the value returned in the FIND line item would be 1 as it would find ANZ? Thanks
Calculate MOVINGSUM from module with no time to module with time
Hi there, I need to reference a source module line item with time to a target module line item without time to achieve an Actuals Rolling [6, 12, 28, 24 months] SUM using MOVINGSUM. In this case, it would be the sum of the previous 6 months from Jan 22. Please see attached screenshots and let me know if I can provide any…
Number Import
Dear Community, I am importing 1.000- into a numbered format line item, system is recognizing it as 1000. Any reasons, why it is happening and how can we overcome it? Thanks & Regards Badam
2.3.8 Activity: Volume Growth Rates
I input formula Growth%= MONTHVALUE('DEM01 Volume Growth Rates'.Growth %). Timescale has been set to week. Summary is None. View on DEMO 2 shows zero. attached screenshots. Am I in the correct direction? Thanks.
Scenario Question for Time Settings.
IF MODULE A = CUSTOM CALENDAR & FY19 DATA, MODULE B = MODEL CALENDAR of FY21, then how can we get MODULE A DATA to Module B as FY21?
Data from With time to No time Dimension
How can i pull a data from a module with time dimension to target module with no time dimension using a finditem mapping made in the source data? To illustrate, my total sales of 1,000,000 was divided into 3 months(using a time dimension) using a condition that turns the distribution this way: Jan 20 - 3,000,0000 Feb 20 -…
LVL 2 DEM03 Override? formula
Hi Team, Inserting formula for a boolean line item as: IF Override? THEN Final Forecast = Override Forecast ELSE Final Forecast = Initial Demand Forecast Error is throwing as "Circular references:Override?" What am i doing wrong? please help.
LVL2 inv01. Forecast demand
Hello everyone. there is a small question - the forecast demand field in my model is different from the screenshots in the tutorial. Was it me wrong in the formula? baseline forecast formula: IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0) ELSE 'DAT03 Historic Volumes'.'Offset…
DEM03 Week 3 FY20
I'm trying to find the reason why my number for Final Forecast (for All Accounts) in Week 3 FY20 does not match Initial Demand Forecast number. I attached the screenshot from the page.
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hello Anaplan! It will be very helpful to bulk updates in the Actions settings. In particular, the setting "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. Anaplan, Could you create something to do so? Thank you in advance!
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hi there! I would like to know how can I change one settings characteristic in my Actions. In particular, would be to change from "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. It would be very usefull. Thank you in advance Community!

Modeling

Discussion List