-
Edit submitted budget numbers
Is there a way to edit submitted Plan/ Budget 2025 numbers in 2025? Are there any similar use cases that anyone has worked upon? The model has been rolled forward but there is a need to accommodate newly acquired companies and edit the budget.
-
Request to Increase IP Allowlisting Limit in Anaplan
I am writing to suggest an enhancement to the IP allowlisting feature in Anaplan, specifically regarding the current limit of 200 IP addresses. This limitation poses challenges for organizations with complex network environments, especially those leveraging dynamic scaling, multi-regional operations, or stringent security…
-
Did You Know: Multi-dimensionality overview
Author: Allison Slaught is a Certified Master Anaplanner, Anaplan Community Boss, and Senior Principal Solution Architect at Anaplan. Hello Anaplan Community! The objective of this ‘Did You Know’ tutorial is to provide a brief recap of multi-dimensionality in Anaplan and provide a framework for identifying how formulas…
-
"Which target items to clear prior to import?" doesn't work as i expect
Hi Guys! I would like to clear all data from my module before a new data import is done. This is important for my process as there is not always data for all combinations. But I'm not having any success with it. I created a module to exemplify my error: "TEST01 Clear Data" has data for all combinations (1 a 10) My import…
-
Data Hub Imports without manual uploads, how?
In the Data Hub training it says 'DO NOT' use manual uploads to the data hub. Use ETL Tools. We receive data in flat files (csv) for many of our data sources, and have no 'link' to their systems. So how do I utilise my data hub it if am not supposed to manually upload these files?
-
Data Export Options in Anaplan Data Orchestrator ?
Hi Anaplan Community, I'm new to Anaplan and exploring integration options for moving data between Anaplan and cloud services. I successfully exported model data to Google Cloud BigQuery using the CloudWorks integration. However, I couldn't find an option within Anaplan Data Orchestrator (ADO) to directly link model data…
-
Reference of numbered list via display name
I have a numbered list where code property is an index like 1,2,3,…… which i cannot use to pull the properties from the list. In this list i have 3 other columns p1, p2, p3 and in another module i have a line item which has similar values like p3. In this same module i am trying to get the values from p2 & p1 in another…
-
How can I build this filter without using 4 billion cells!
My end users want to see transaction level data being pulled into our model with the ability to filter by account code and time. The filter is currently set up as displayed in the attachment, but takes up way too much space in the model. Any ideas on how I can build a smaller filter for this to continue working? Thanks…
-
Forecast Moving Average
Hi guys I want ask you, why doesn't the value on FY25 continue? it stops calculating week 1, I want to continue the calculation (for example week2 in FY25 is the sum of week 52 fY24 and week1 FY25 div 2. Is it possible for me to do that? Week 1 FY 25 = (Week 51 FY 24 + Week 52 FY 24)/2 Week 2 FY 25 = (Week 52 FY 25 + Week…
-
Access to Apps and Pages
Hi, Could someone please help how do I provide access to someone to view the Pages and Apps that I created. I shared the link and the user was not able to view. Should the user be provided 'Page Builder' access even to view an App or Page? Thanks, Gokul.
-
.NDVLSNVLSDNVJDS
demand forecast the result is a circular reference screen
-
How to create multiple file ID for the same process?
My Anaplan model is connected to an outside system by API, user can accept or reject a request in a workflow in the outside system and the result is transferred to Anaplan by API, then Anaplan will refer to the result file and update the status to proved/rejected. However when multiple users run the same workflow at the…
-
Level 2(Conclusion) Currency Conversion
Hi all… I've been trying to import to Country Currency list but getting errors. Please find my mapping screenshot… I've used Name or Code when mapping because each currency has both country name and code. Thanks in advance!!
-
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Hi, I am getting the wrong values for "Beginning Inventory" and "Forecast Demand" in INV01. I have used the following formulas.. Beginning Inventory: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory Forecast Demand: 'DEM03…
-
[In Saved View] column in Blueprint
Hi everyone, As the model grows and everchanges to client demands, model builders have to gradually clean up unused/irrelevant line items. For me, I can detect those unused line items when checking the [Referenced By] column in the blueprint, but for those that aren't referenced by any other line items, I need to check…
-
【2024年12月】プラットフォームアップデート
New UXの機能アップデート ・Line Itemsに対するフィルタ機能追加 ・階層リストの折り畳み/展開機能追加 ・Gridの行/列項目に対する書式設定機能追加
-
Distributing values based on Mapping.
Hi All, I have a module MOD1 which is dimensioned by Product Group, Customer and Time and has line item Cost. I have another module MOD2 which is dimensioned by Product, Customer and Time and has line item Sales. I have a mapping between Product Group and Product Lists. Every Product Group has multiple products. I want to…
-
Request for Hints on Level 3 Q2 and Q3
Hi all, I hope you're doing well. I’m looking for some hints regarding Level 3 Q2 and Q3. I tried re-importing the data provided in the files, but for some reason, I can’t retrieve the Amount Increased or the Initial Country Sales Target for Chocolates/US. Could anyone provide a hint on what I might be doing wrong? The…
-
Getting Invalid date format while data import into module
hi, my source file contain time in format 201901 201902.. etc as line item. while importing i am getting error as above . which time format i have to select.? adding source file below. please help to resolve the error. Thanks Jerin
-
why all roles empty?
-
Level 2 training 1.5.7.2 Add Formula to SYS13 Line Item
Help please!! Line item: Has Data? Format: Boolean Formula: IF TIMESUM('DAT03 Historic Volumes'.Volume) <> 0 THEN TRUE ELSE FALSE Somehow, it did not give me correct result. Not sure what's wrong here.
-
Integration via Amazon S3
Hi, I created a connection via Amazon S3 without any problem, the status is "Connected", but I don't manage to select a file when I try to create the integration : Thank you in advance for your help. Best Regards Alex
-
Compare value on current logged in user email
I have a module with historicals captured by different users via another Model. My module has one line Item which has the email ID(Customer Email) of that particular user, however this module is not dimensioned by Users. For this module i only have one dimension which is basically the Index for the records, rest other data…
-
How to retrieve Current user
Hi everyone. i read some of the post here regarding retrieving current user but unfortunately cant find the answer. Since retrieving current user without user list dimension is not allowed, how can i transfer the current user from module with user list dimension to a module without user list dimension. thank you.
-
Hot fix
Hi All, I couldn't get clear outlook of implementing hot fix in prod environment, when we have development in progress in dev mode. We don't need the development to go to prod only the issue needs to be fixed and later we must progress with the dev model with out loosing the development. I am unclear of how many revision…
-
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
-
why I importad data from csv show 100x bigger than the original file?
hello I tried to finish the L1 training and in the 8.5.2 steps when I import the price book data in the anaplan model I saw values that 100x bigger than the original values in the csv file. like example csv file show: 0,84 in my model I see 84.0. not sure what cause this problem. is it coming from my local xls settings? if…
-
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
-
source to target data is getting loaded partially via IICS
Hello, i'm fairly new to Anaplan but come from BI products world. I have a situation, an Import action is created in Anaplan dev. This action picks up the .csv file from source location (This has been working perfectly fine in our environment for last 4 years) and loads it in to one of the Modules. This process has been…
-
Links in page tasks in a workflow are not working
Hi all, I have a problem: in a workflow I use a page that contains links. Before when starting a task that takes you to that page you could navigate from those links. Now, the page is "static" and the links do not work when you are in the task page. Is something new? Can it be changed?