Recent Discussions

Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)

HI, I have a list as dimension in one of my modules, and I am trying to change that dimension to a subset of the same list. However, when I try to do that, I get the following error message; "To serve as an access driver, a Top Level Item must be present on any line item dimensions that don’t match those of the target…

Hello, I have the following problem. I am trying to associate Customer Part Number, which is a unique product code in the customer's store with the SKU that exists in my store. For example, the customer sells a set of furniture, a table and 4 chairs, as one code in his store, and in my store there will be two separate SKU…

Need 90 days trial access for model building and practice

Hi All, I have 3 modules, let's say A, B and SYS Filter A module has dimensions - Stagging list, custom versions. B module has dimensions - Stagging list, subset custom versions. SYS Filter Module has dimensions - Stagging list, custom versions and Subset Users. while applying same filter from Sys filter module, A Module…

For this I created 3 saved views 2 from module INV-02 I pivoted them and synced them with page , 1) I made first view using Region(row) , Safety stock line item(page), Time(column) 2)I made second view using Product family (row) Now I made 3rd view using INV-01 module 3) I made it using SKU(row) after that I applied SYS00…

Hi dear community, After a great journey of Anaplan learning which went really smooth, I'm on the last mile and it's taking too long for just two line items I can't find a solution for : Target : I'm using the TAR02 Account Review - Final Sales Targets No of Accounts : I'm using the SYS02 Account Details - Count I have the…

Hi All, I'm new to Anaplan and still learning it's way, would appreciate any ideas aligning with best practices. Here's my question: I have a list with combination of properties say products, location, customer, and for each such combination there's a sales person, now I have Sales transaction data with product, location…

Hi Hoping someone can help me solve this issue I am having. Probably doing something very silly! I want users to filter a list of managers which is a subset of the employee list. I wanted to do this through a list property driven by a line item in the model. I have done this before but I cannot seem to get the dependent…

Hello, could you please help with following situation. I have the flat list of positions for which Selective access is set (according to the access of the user, so that HRBP of the Facility 1 has access only to applicable positions). All the major calculations are made on this list of positions ir order to save space…

Hello, I have a module with dimension "Invoice Number", in this I have Start Period and End Period for the invoice (it can cover multiple months). In another module without dimensions I want to be able to show which Start Period and End Period a invoice have based on if a boolean is true in the first module. Does anyone…

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: I was trying to navigate from Dashboard 1 to Dashboard 2. Since my dashboard 2 is tied to two different models, navigation link did…

* Override Amount – Write: IF 'INV01 Inventory Ordering'.Override Suggested Order Amount = TRUE AND 'INV01 Inventory Ordering'.Submit Purchase Order Request = TRUE THEN TRUE ELSE FALSE ----Does this not look correct?

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…

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…

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…

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…

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…

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…

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 Community manager note: This post…

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…

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

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.

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 Account Code and Time. I am thinking that I need a System Module to use the Sum function, but I can't…

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…

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…

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!

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…

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:…

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…