-
ISFIRSTOCCURENCE() issue in model when more users are added.
Hi Everyone, I added 1 user into my system and as soon as I run one process, it is failing to say that "Too many cells for ISFIRSTOCCURENCE calculation: actual =50000094 maximum=50000000". But as I remove 1 user from the users tab the process starts running fine again. I am a little bit confused about why this kind of…
-
Assign action in NUX – the ability to review already assigned elements only
Context menu of Assign action in Classic UX allows users to see all the list elements already assigned to the selected parent element in one place - the right panel (Screenshot 1). This view is very convenient for many users. At the same time, in the Assign action menu in NUX already assigned elements are displayed…
-
Getting 0 results from a COLLECT line item
Hello, I have a line item that has a COLLECT() formula. This returns the values just fine. But when I use this line item and Lookup or Select a specific member, it doesn't return any value. Is there a way to do this, or am I doing it incorrectly? LINE ITEM FORMULA APPLIES TO SUMMARY TIME Source line item COLLECT() List 1 &…
-
Invalid Formula error?
Hi - I am copying the same formula from another cell, and adjusting the start of the formula to another cell so should be straight forward, but I keep getting 'invalid formula'. Please see screenshot below. Can someone please advise? Thanks
-
Action button in the source model
In UX page grid which is from the source model the forecasting data is updated by the users. Post the users enters the data it should get copy pasted in another UX page which has another model which is the target model. The action is created in the target model to get data from the source model but the customer requires…
-
Is that possible to customize the time scale text?
Users export forecast report every day, they are wondering if the time scale here e.g. "Week 1 FY25" could be "Week 1 FY25 (2024-09-29)" which add a START date of this week, otherwise they have to manually add it in the excel file. Thank you
-
Freeze Column - Make it persistent across user sessions
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: A frequent request from users is the ability to retain the Freeze Columns setting in worksheets, similar to how filtering works in…
-
Smart (or Filtered) Context Selectors
Where we have more than one context selector on a page (e.g., a Product and a Location), it would be helpful if the list of items in each menu would update based on the selection made in the other context selector. So, if I selected a Location, it would only show the valid Products that are active in that Location—or vice…
-
New UX - Keep Show/Hide Selection when doing a re-pivot
Currently, if I do the show/hide in a Custom View, then changing the position of dimension (re-pivoting) causing resetting of Show/Hide selection. I would like to be able to keep the selection even after re-pivoting, similarly to Classic UX.
-
Provide Capability for Timeless Line Items
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: We have several line items that aren't necessaryily tied to specific time period. It appears we are forced to design particular…
-
Re-order line items in New UX personal views based on order selected
Hi Team, Would be great to allow users to choose the order in which line items are represented in the UX Dashboards when using the show/hide function. This could be captured by recording the order in which line items are selected in the show/hide panel. Users could then save a personal view of the changes to return to…
-
Sort on multiple line items like Excel
To enhance the usability of UX grids, it would be nice if users had the option to sort on multiple line items at once. This would mimic Excel functionality that allows for multiple fields and sorting logic in one sort:
-
Conditional Formatting on Booleans
As a model Builder I would like to use Booleans as a Basis for Conditional formatting. For example. I have a Boolean/ Checkbox which indicates that not all fields in a new Item/ setting has been filled. I would like to be able to use that boolean directly instead of reverting to a number. The advantage would be to save on…
-
Unlock Efficiency with Hierarchy Filters in Anaplan NUX
As Anaplan Model Builders, we’re always looking for ways to streamline processes and deliver exceptional user experiences. One of the most powerful tools at our disposal is the Hierarchy Filter in Anaplan’s NUX. When used effectively, it can save time, reduce redundancy, and ensure consistency across your models. The key…
-
カスタマーケアポータルについて
こんにちは！ 2025年2月よりカスタマーケアポータルがオープンいたしました。 Anaplan Support（support@anaplan.com） 宛てにメールでお問い合わせいただいていた内容を、今後は カスタマーケアポータル からお問い合わせいただくようになります。 カスタマーケアポータルでできること 問い合わせ起票からクローズまで、End to Endのケース管理 直感的なインターフェースとAI搭載の検索機能 サポート記事、既知の問題、Anapediaの豊富な技術ドキュメントなどを入手できる一元サイト Ask…
-
Plan IQ Setup
Hi Team, I have a Demand Quantity for different products. I want use PLAN IQ to setup the forecast. I have followed the PlanIQ training video but as i have no Related data and attributes data. The process is failing. Could someone please assist on this. Dimensions: Product, Orders. Data: Demand quantity in (Data wise…
-
Anaplan User unable to pull data in one of the dashboard on Google Chrome
One of our Anaplan Users is unable to pull data in one of the dashboard on Google Chrome. However when the user is trying to open the same dashboard in Chrome incognito window is able to pull the data. She tried to clear the cache, cookies and browsing history but that didn't help in Chrome. She has the same access as…
-
return the light blue color for the input data
Until recently, the input data in applications was blue. Now both the data entered and fixed by the formula are the same black color (or too dark blue??), which is absolutely inconvenient. I hope the color for the input data will be returned to a lighter blue or an alternative will be found, please.
-
Efficiency of the lookup formula
I have some question about how efficient the lookup formula is I have a situation where we when we have new items have the ability to give that item a mapping to another item to pull some initial data for since we don't have anything for it yet. we used a lookup instead of just repopulating the initial data so the users…
-
Latest platform releases
We publish regular articles that showcase our latest platform enhancements and offer updates about fixes we've delivered. If you'd like to receive a notification each time we publish a new announcement or update, please follow these steps to subscribe: Sign in to your Community account. Visit this page and click on the…
-
SLA Function for Call Center Planning
I need some clarification on how/what the SLA function is calculating. Here I have an example of a call center planning scenario where I first input an SLA, Target Response Time, Average Arrival Rate and Average duration to get # of servers using the AGENTS function. I then allow for adjustment to # agents and re-calculate…
-
Counting Headcounts of Male Fulltime Employees Using IFTHEN Formula
Hello, I am having trouble counting the number of headcounts using the IFTHEN formula in Anaplan. My formula: IF '01_PSFT・Excel data'.Contract = "Fulltime" AND '01_PSFT・Excel data'.Gender = "Male" THEN 1 ELSE 0 What I want to count: people to be categorized as both ・Contract column:Fulltime ・Gender column:Male I created…
-
How do I get the correct mapping?
Hello, I'm facing a mapping issue, wherein I've a module with 3 dimensions & few line items- Lets say Dimension X, Y & UID with a line item formatted as dimension ZZ Then there's a 2nd module with the dimension ZZ , Y & the same line items- There's a mapping between ZZ & X so I can lookup that & pull the values, dimension…
-
Anaplan Id Merge
Hi Team, I have a team member who has currently changed the organisation. She is Anaplan certified resource. She was having id with the previous company credentials want to merge it with current company credentials. Can you please help us with the process.
-
How to Allow user to select (boolean) both parent and child in the same grid.
Hi Anaplanners, I know this is a long shot… is it at all possible for users to manually select both the Parent and the Child in the same grid like other applications (I believe Salesforce can do it) in the screenshot below? Thanks, Jim
-
The Anaplan model 1
dear all kindly help in to access in the Anaplan model 1 after completing the The Anaplan way
-
Level 1 11.3.4 REP03 Profit and Loss
Hi, I'm having trouble getting my data to match that of Anaplan's. My headcount and expenses are off. Headcount at 7 when it should be 8. I've been reading through these community forums and can't seem to find a solution that works here. Any insight on this would be greatly appreciated.
-
Start small to achieve larger implementation goals
Author: David Edwards is a Certified Master Anaplanner and Associate Partner at Columbus Consulting. Whether you are an Anaplan customer or implementation partner, it can sometimes be difficult to convince business stakeholders to invest in large digital transformation initiatives. This is often the case when positioning…
-
How can I import this data in the correct way?
Hi, I am facing a challenge with uploading a file, can someone help me? This comes from the training level 1, chapter 8 I don't know what I have to fill in at the forth line option? This needs to be the outcome:
-
Are all models slow to open in the morning?
Our model takes about 10 minutes to open every morning. Our implementation partner told us that is not uncommon for the first person to open it in the morning. Is this something other users have experienced or is it a performance issue?