-
Connecting Anaplan Connect to Snowflake Using JDBC Driver with Java 16 or Higher
Addressing JDBC Driver Compatibility Issues Intended Audience Level of Difficulty: Intermediate Requires some familiarity with APIs, scripting, or database concepts Resources Required: Internal Expertise: Data Engineer/IT Admin/Integration Admin Tools Needed: Anaplan Connect, Snowflake, Notepad Editor Access Requirements:…
-
Include Calculation Effort metric in Anaplan Classic
I have found this feature available in Polaris to be very valuable. So I would like to request it to be included in Anaplan Classic as well. Thought there was already an existing idea request for this but couldn't find it. When I encountered performance issues during a list item insert that was taking 90 seconds to execute…
-
Anaplan Data Orchestrator (ADO) - Usage Values Missing
As an Integration Administrator (IA), I would like to view my ADO usage not just in % terms but in value terms, So that I can plan my ADO Storage and Tables consumption reasonably, if my tenant is going to have limited numbers on those two usage categories. Currently it is not transparent to me as an IA on what is the…
-
Quick way to open referenced Line Item or List Property
It would be great to have a quick way to open a referenced Line Item or List Property from an existing formula. It can be very tedious & time consuming to hunt through the modules & lists, then again through the line items & properties to locate the reference, especially when there are multiple levels of references to…
-
OEG Best Practice: Imports and exports and their effects on model performance
Overview Imports are blocking operations. To maintain a consistent view of the data, the model is locked during the import, and concurrent imports run by end users will need to run one after the other and will block the model for everyone else. Exports are blocking for data entry while the export data is retrieved, and…
-
Data Quality Orchestration : a simple example with ADO & Workflow - Part 1/2
In this article, you'll find a simple but hopefully inspiring illustration of the power of Anaplan Data Orchestrator (ADO) combined with Workflow. This is a 2 parts article. This Part 1 focuses on the Workflow and the steps to achieve Data Quality tasks. The Part 2 is a deep dive on some details. Summary For illustration,…
-
Wildcard Searches/Filtering in Context Selectors
The option to filter to a selection in a context selector requires an exact match. It would be more effective if we could use wildcards or enter key words separated by a space or a special character (e.g., a "?" or a "*") and have the menu show items that have both (or all) of the key words in the menu list—even if the key…
-
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…
-
Management report should support more dynamic layouts (e.g. filtering on columns to display)
Below is an issue which is stopping me from using Management Report (UX Page type = Report). The issue is that once a card is published to the page: * Dynamic columns are not respected if based on a filter there should be more columns than initially published, it won’t show * Dynamic columns are not respected if based on a…
-
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.
-
Excel Add-In OLE Action
Hi All, I wanted to see if anyone has been encountering this issue with the Excel Add-In. Oftentimes members of my team will go into Excel, log into the add-in, and then the whole Excel Application feezes. It freezes for a few minutes and then comes up with a message box saying "Microsoft excel is waiting for another…
-
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…