-
Deletion of comments in UX pages - Month on Month
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 got this requests from our stakeholders if there is option to clear out the comments they have entered over the cards month…
-
Global selectors in management reporting
I have several management reporting packs with different pages, all set to a global time selector. However, this selector keeps changing periods unexpectedly. It seems to be linked to the last time period I selected on another UX page using the same module. The issue is that the time I need for the reporting pack is not…
-
Optimizer Help
I am trying to learn and understand how optimizer works in Anaplan and need some assistance in overcoming a roadblock. I am going over a practice problem that I have created in excel and am having difficulties with one of the constraints. The Problem: Without getting to into the weeds this practice problem is about making…
-
Adjusting CloudWorks Integration Schedules for Daylight Saving Time (DST) Using Postman
Intended Audience Level of Difficulty: Intermediate Requires familiarity with APIs and Postman Resources Required: Internal Expertise: IT Developer / API User Tools Needed: Postman, CloudWorks Access Requirements: CloudWorks, Postman, Anaplan Integration Admin Estimated Level of Effort (LoE): Low Approximately 1-2 hours…
-
Adjusting CloudWorks Integration Schedules for Daylight Saving Time (DST) Using Python
Intended Audience Level of Difficulty: Intermediate Requires familiarity with APIs and python scripting Resources Required: Internal Expertise: Python Developer / API Expert Tools Needed: Python, CloudWorks, Code Editor Access Requirements: CloudWorks, Anaplan Integration Admin Estimated Level of Effort (LoE): Low A few…
-
February 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our February 2025 official release notes. The information below offers supplemental information to that post. Integrations and Extensibility Create a transformation view directly from a source dataset in Anaplan Data Orchestrator On the Source data page, a…
-
Retrieve Action and Source IDs
Hi, We are working on pushing data from SAP Data Sphere to Anaplan. We are establishing a connection from SAP Integration Platform to a model in Anaplan. When setting up the process, we have been asked to provide the Action ID and Source ID. Does anyone know how to get those IDs? thanks
-
Formula for Quantity Multiplied by Price
Hi, I'm playing around with some dataset I've found. The data only has values up to the month of June. Is there a function for getting the unit price based on the quantity that I will input for each month multiplied by the price of each product in every location? So that I could fill all the months with no values. I also…
-
8.5.2 Volume Import
I cant get the import to work, I think its because the dates are a different format and not sure if I should change the dates in the report or if I am mapping incorrectly and if so what do I use
-
Last 52 weeks Calculation
I have a requirement to show the last 52 weeks value. I want to create another line item which has to sum last 52 weeks total hours e.g.: 03/08/2025 should show the last 52 weeks data this should be dynamic and 52 weeks should change based on the week. Thanks in Advance.
-
I want to sum actual data by account and Time.
https://us.v-cdn.net/6037036/uploads/LKPRFTYBDVFT/i-want-to-sum-actual-data-by-account-and-time.xlsx As shown in the image, actual data is on the left and detailed data is on the right. The detail data is created to be in the hierarchy below the Department Code that we want to total. I want to sum from left to right by…
-
Cloudworks API: Change Schedule
I'm working on a script that would update integration schedule. In future my target is to have a script that would move all my integrations + integration flows +/- 1 hour on DST changes. For updating integration shedule I have sent PUT request to endpoint…
-
How to create a new import action
I have my csv file and upload in the option "Import Data Sources" and when i click next, is supposed to be appear new windows in this windows map the columns of the new file to the current modules in Anaplan, but when i click Next the system automatically closed that windows and i cannot map the columns, is this the way to…
-
How to SUM the last three months
In the line item "last 3 months sum", I'm trying to sum the last three months. I tried using timesum but wasn't getting the right numbers. Any help appreciated, thanks!
-
3.4.3 Activity: Create Country Summary Module
Hi All, I am stuck in this exercise almost 2 hour, not able to proceed further. Can anyone please help? I have added line item "Country Made in" SYS08 SKU details module. Now i know that the formula in Safety stock flag count would be 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country…
-
Resync PROD - DEV Enviroments
Hello, I needed to do a rollback on the PROD model to an ID from the History, so it implied to get the PROD from DEPLOYED to STANDARD mode. I knew before that this will happen, but it was kind of urgent to solve the issue that we had so this was the only way. Now I am asking you, what is the best option to resync the…
-
Do we have workaround for management reporting context selectors filter/show-hide?
Hi all, Do we have any neat workaround for either filtering/using show-hide on the context selectors in the management report type of page? There's a list with parent members, where I want to hide the parent members from the page. Thanks for the help in advance!!
-
Enable cards from multiple models within the new UX app
Enable cards from multiple models within the new UX app. Currently you can add multiple models to a page, but when you add cards sourced from different models you have to toggle to that model at the selector. After creating the cards, you have to toggle to this modal at the top otherwise the data is killed as per the…
-
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