Data Integration

Refactor the action "Imports" tab
The action import tab should include: - all the info that is in the first tab the source ID ( especially the last execution date) - source object should be exploded into workspace/model/module/view fields - the data source ID should be available here as well - an export button, just like on the first tab - the ability the…
Choose column separator in Exports
When we export modules containing text-formatted line items and we choose csv or txt format, the column separator is automatically forced on 'comma'. If the text within the line item contains any comma in its body, it will shift the following columns and damage the whole file. It would be great to be able to choose the…
Regarding History Tracking in Anaplan
Hi, Since last few days, we have been encountering some unusual behavior in Anaplan. One particular line item got cleared from the production model. In another case , an import copied the data from all the line items mapped except one in particular, when we checked , all the mappings seemed fine. Even running the same…
How to add Functions to existing Import and Export buttons
Hello, I am asking for help to add a Time, Version and Department functions to an existing import and export button in a dashboard. Any help would be helpful. TY
Snapshot Current System time function
Currently there is no current date/time function in Anaplan. After talking with developer from engineering group, we understand that one of the challenges to implement this is that Anaplan is "moment of time" system, if you have a formula reference Current time, then it would be only true for that moment, what happen if…
Duplicate entries - Module to module import
Hi, While carrying out a module to module import, if we do not import zeroes first in the target module, the values tend to sometimes double up if we execute the action twice (even after selecting the "Clear target prior to import" option while creating the action) but sometimes they reflect correctly even after executing…
Level2 Sprint3 Import DAT04 Distribution Center Parameters from Datahub
As I had issue loading data from Datahub, I wanted to do a copy paste so as to go on (not a prefect process i acknoledge) but when I want to paste data in the DAT04 distribution center parameters module (in the Suppplychain) I got an error message. It seems the module is on read only. I checked the parameter and as I am on…
Level 2 Sprint 1 - 1.5.6.2 Import Data into Historic Volumes Module
Hi Anaplan Masters, I am unable to understand what is wrong in my selection. I tried with other mappings also knowingly that are not correct . attached is the mapping which i consider that is correct but unfortunately I am wrong bcz it shows the error after import. Request you to please help me for this. Regards Abhishek…
No reference cell count
If Anaplan can provide the column for the total number of no reference cell count for each line item in module grid view, It will greatly help modelers to identify the line items which is having more sparse cells. Modelers can work on those line items to less the sparse cells. I believe it will help at the module level as…
Translation
This is an idea of how to improve the app
Cloudwork Query
We have to integrate process in cloudwork with below condition. 1.User select source data and Target data in module have user dimension. 2.Based on user selection run process to load data for source to target for each user. 3.Integration job should run process as many time users have selected source and Target. How to…
JSON as Import File Format
With the JSON format being the pervasive format for API data interchange it would be excellent if Data Import actions could use this format of file as a data source.
Excel Add-in Cannot access view
Good afternoon, I have recently downloaded the Anaplan Excel Add-in. I would like to create a view based on my 'development model' (we are using ALM), in order to be able to test the add in. When trying to add a saved view of a module (any module) , the add in shows me the following error: New Connection - Cannot access…
Action error only for non administrator users
Good morning, everyone. I have an issue. When I import data from one module to another, anaplan returns an error for non workspace administrator users. The error is:"You are not authorised to update this entity". While the action works for workspace administrator users. Maybe it is because of selective access used in the…
Adding a new list of existing model
Hi All, I am adding a new list (dimension) to my existing model. I am able to pull in the actual data from the source system by the new list easily. However I am not sure whats the best way to go about integrating the new list for the forecast planning. Currently - in my forecast planning module, my current forecast data…
Help Inform the future of Anaplan's APIs
Please take this short (less than 5-minute) survey to help inform the future of Anaplan's APIs.
Issue when importing from one module to another
Hi, I have an issue when importing data from one module to another, and the scenario is the following: I have a source module with "Projects" as dimension, and a target module, also with "Projects" as dimensions. The source module is a "calculator", where you can enter values and factors, which then calculates the final…
Anaplan Connect - SFTP
Hello, Just a quick question, does Anaplan Connect support SFTP server or only FTP server? Thanks, Ana
Effective Line Items rename during Fiscal Year changes
Hello , For Every Fiscal year development, we used to copy the models and rename the line items in the modules / dashboards from FY21 to FY22 etc. Later it was discussed with the user and renamed CY, CY-1, CY-2 (CY = Current Year), but the users are getting confused with these CY terms. Have anyone tried a different format…
There has to be a better way. Any ideas?
Hello, While on a rebuilding project with a client, I am ready to delete some modules. Problem is the line items in those modules are used in Formulas and are connected to downstream modules. I know I can reference the specific references in the Blueprint view, and scrolling over to see the Referenced By column. However,…
Excel Add-in Multiple View
Is it possible to publish multiple modules to one workbook in excel using excel add-in? I have a client that needs a dashboard (containing views from multiple modules) to be exported to excel that needs a specific formatting for shareholder's reporting. As far as I can see there's only one connection to a module per tab.…
Import into List - duplicates in key
Hi I want to import a customer forecast into a module. The customer forecast is Key, Product, Location, Date, Qty My end module will have a key dimension which is the Product/Location and dimension time, with a value of qty. So part of the import process is to create the key List. If I import into the key list from the…
GUIDE: February 2021 Release | Time Stamp on Actions
Community, Just a quick heads up. Every time you run an action you will now see the timestamp on the action tab. Awesome! Here's an example of a manual action being run. I tested it on automated actions too and it works great. Thank you Anaplan - huge win!
Anaplan CloudWorks API and Azure Logic Apps
* Use case: event-based triggering * Building a Logic App * Technical flow * Special focus * Conclusion You’ve already had a flavor of using Logic Apps with Anaplan API in this article, thanks to my colleague Sean Culligan. In this post, we will do something slightly different by using Anaplan CloudWorks API with the…
Add API functionality to list the line items shown in a Saved View
I would like to see a new API call or an update to the existing view metadata call, that lists which line items are "shown" in a saved view. The only way to get this information now is to read the view and parse the header line. When using the API to build an integration, pulling the metadata of an object before pulling…
Anaplan Hyper Connect Error
Hello Team, When we use Hyper Connect for Anaplan integration, we are frequently getting following Error and unable to figure root cause for the same. [ERROR] Write Failed. Internal Error: Adapter Write Returned Exception: com.anaplan.adapter.anaplanv2.metadata.adapter.service.exception.AnaplanServiceException: IOException…
Import from a module to the same module
Hello, I'm coming to you because I have a problem with a customer that I have never encountered before. I am trying to import data from a saved view of a module to this same module. The saved view uses a filter that allows me to bring the data from an entity X to an entity Y that is selected at each import. The action…
How to import data in accordance to 3 different identifiers for a data set
Hi, I'm trying to load a data set into Anaplan that has three different identifiers for the data set. The three identifiers make sure the data set does not have duplicates. The three identifiers in the data set are contract_id, Process Entered Data, and date_applied. At first I created List for all theses identifiers and…
Display list items with non-zero values for sub-list creation
How would you go about creating a Module that looks in other Modules and finds every item in a list that has any non-zero values entered in a given 12 month period? The idea would be to create a table that shows, for a given group of lists, all combinations of those list items that have at least one non-zero value in the…

Data Integration

Discussion List