-
How to resolve the import error - New property combination found but name or code already exists?
Hi all, I'm trying to use an import action where I have a unique key in the source (Source is a module in another Anaplan model) This unique key is a concatenation of 6 parameters. I'm getting an error - New property combination found but name or code already exists I've checked the source & there are no duplicates. I've…
-
Volumes for DATA02 SKU
Hi team, I have mapped the data SKU.csv as per below screenshot. And under DATA02 sku line items mapped volumes However, only Jan 2019 and Jan 2020 data is visible in the sheet attached jpg, Please guide me with steps to rectify so that volumes are visible under each month.
-
Transactional APIs - Part 3: SQL Query Anaplan data using Transactional API via Data Virtualization
Here’s a sample transcript of conversations I routinely have with our customers who are new to Anaplan platform: * Customer: I have a need to query Anaplan ‘table’ and integrate Anaplan data to my database. Is this possible? * Anaplan: Certainly, using Anaplan Transactional APIs, you can query a saved view and output the…
-
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…
-
Line Item Name change
Hi All, I have created a mechanism by which Line Item name can be changed using a Process/Import. It works perfectly fine in Standard mode. But, in deployed mode it shows an error " Deployed mode is enabled and you cannot change the structural data of this model. Change to standard mode if a structural change is required."…
-
3 Improvements for Comments in the New UX
Hi, I'm missing 3 basic capabilities on the current comments' fucntionality to be able to use it for my clients: 1- Comments are not flagged to end user 2- Not recorded in full context (in all dimensions I'm looking at) 3-No option to publish or export from Anaplan This custom fucntionality I built allows me to overcome…
-
Set text encoding format for anaplan connect script upload
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
-
2.3.8.2 Import into DEM01 Module
Hello, I'm attempting to import Volume Growth Rates.csv. When mapping the time (column headers) on the file, I select Periods, but there is no Y-M or M-Y option. I assume something is messed up that I'm unaware of. Any feedback would be appreciated. Sean O
-
Changing source file name
Hello Community! I´ve been working with Anaplan for several years now and whenever I´ve needed to change the import file for an import action I´ve just created the action again using the new file. This usually isn´t a problem so I haven´t given it a second thought but what if you had 15 actions that are included in several…
-
Stuck in L2 sprint 1 exam
Here's an analysis of the provided image, which shows a question from an Anaplan Level 2 Model Building - Sprint 1 Exam: Question: When importing into a list, you get an Invalid Parent error. Assuming the file has correctly identified the parent, which of the following could be a valid reason for that error? Select all…
-
500 Internal Server Error occurs with requests made with API V2.
To export data from the View, a request is made with an API call to download all pages. The View has a lot of data, so the number of pages will be about 100~3000. I am using Azure pipeline to download one page at a time, but when I finished downloading about 120 pages in 50 minutes, I got a 500 HTTP Internal Server Error.…
-
Anaplan - SAP Connection
Hi Community, As a new trainee and part of my professional thesis, I’m working on establishing a connection between Anaplan and SAP to automate data loading from SAP into Anaplan. I currently have a free SAP Business Accelerator Hub account, but I’m struggling to find the correct Base URL or API endpoint to use for this…
-
Regex Formula
It would be very helpful to include a regex style formula in Anaplan so we can pre-process text fields ahead of an integration, or even help to cleanse messy inbound text. Currently if we want to remove special characters, or parse strings into cleaner formats we have to specify one by one the characters we wish to remove…
-
level3 sprint1 4.6.5 Sale Planning Model: DAT02 module
Hi, I am now struck in below excercise 4.6.5. As As per the ask i have done the below steps -Created a DAT05 module in datahub with Historic sales revenue for 2019 -In Sales model i have created DAT01 for Historic revenue and imported it from Datahub model -Created DAT02 PY revenue to CY. And used the below formula for…
-
Action to copy data from one version to another version only for a specific module
Ideally, I would like to setup an action that can copy data from one version to another only for a specific module. For every new version I create, I import new data into certain modules and then I manually copy data over for a specific module. I am wondering if I can just setup an action to select an origin version,…
-
Anaplan-Informatica Cloud Integration
Hello, I'm hoping someone has had this error and was able to resolve this. Would like your help on it. I currently have a Dev and Prod model setup and I'm using a simple import to a date-formatted line item action to refresh the current date. I was able to set it up on my Dev model and it works perfectly. But when I…
-
Allow user to choose time format on exports
When exporting, different scenarios will give you a different format for time. This would be an option within the Export dialog, similar to how you select the date format when importing a file. Specifically, exporting with two dimensions on columns will give you the date format MMM YY. This can cause issues in other…
-
Creating more flexible export definitions in Anaplan
Anaplan exports, unlike imports, have no link to a saved view. However, there are ways to create Export actions that have more flexibility for future maintenance. After creating your view layout (using the view optimization best practices outlined in the Anaplan Polaris – View Optimization for Imports and Exports article)…
-
Assistance Needed for Exporting Line Item Codes in Polaris Models
I am reaching out to seek your assistance with a specific requirement we have encountered in our Anaplan implementation. We need to export line item codes instead of just the line item names from a Polaris model to integrate with an external system. However, we are facing challenges due to the current limitations and…
-
Anaplan Polaris – View Optimization for Imports and Exports
This article is part of a series on Polaris best practices. Click here for more Community content or visit Anapedia for detailed technical guidance. This article explores how to optimize saved module views within the modeling experience, with particular attention to data import and export processes. We’ll revisit essential…
-
L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
-
Selective access for lists from dashboards.
I am trying to enable the user to give selective access on a list via dashboard. I published the list to the dashboard and can clearly see the "Read" and "Write" columns on the dashboards, however if I save the dashboard and close and reopen it , the columns of "Read" and "Write" are not visible. Can somebody explain what…
-
Part 8: Import data into REV02 Volume Inputs modulePage
Hello Group, I got lost in trying to import Volume+inputs.csv into my Rev02 Module. In the attached screenshot what should map into "REV02 Volume Inputs Line Items (Volume)". Thank you very much in advance. Jayan
-
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
-
Automate/Improve Resetting Next Item Index for Lists
Problem: There is no automated or pre-emptive way to reset the “Next item index” on a list without first clearing the list. Issues Caused: When using a data hub with a large data set that is refreshed daily, we regularly exhaust the item index. This causes the import process to fail and results in refreshing of all…
-
Generating Failure Dump Step - on Successful Imports
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
-
Headers in export files
When Exporting files from Anaplan I would like the possibility to remove the list name from the header when adding properties properties in the export file. Today I can only choose Include or exclude Row Label headers. I would like to have the possibility to exclude the name of the list in the header. From above export I…
-
L1 SYS08 Employee Details module - Import and Mapping Issue
Can anybody please write down the steps for the particular SYS08 - import and correct mapping As after several attempts and struggling to get it right . Appreciate your support guys.
-
Any way to find out which user joined the Anaplan workspace and at what data and time?
I have a requirement to sort based on when users joined the Anaplan workspace.
-
Make Integration admin role available for visitors & partners
It's currently not possible to assign an integration admin role to visitors and respectively also not to Anaplan Partners. This makes it a challenge when helping customers with Cloudworks or when just setting up a scheduled model-to-model import. It requires always someone at the customer capable to set-up the connections.…