Data Integration

Number are being imported as thousand instead of decimals
Hi! My numbers are being imported as thousand instead of a decimal number. But in my blueprint, the number is set up to have a decimal delimiter as dot, and thousand delimiter as comma. and those are the values that should be entered. Does anyone know what is happening? thanks.
Export selected list members
I need to export only few list member details. Can someone suggest which will the possible way to do so?
Selective List Export
Can you please tell me is it possible to export particular two List Members and corresponding Line Items?
How to add filters to data export?
Hi Experts! We need to export only a small set of data from Anaplan modules (Ex: Export only ACTUAL data for 2017.05 for LINE ITEM 'REVENUE'). Please suggest if this is possible using standard functionality.
About the imported display method
Import to dashboard using anaplan connect. I want to display only items that have been imported and entered Is there a way to automatically display only items that have been imported and entered? Can you filter automatically? I'm worried about setting the line item formula or setting the filter. I would be happy if you…
Clearing/ updating old records while uploading data into Anaplan without knowing what to clear?
Hi All, I have an issue which needs to be addressed for a client. I do have a solution however would like to reach out to amazing community and get a different viewpoint on this if possible . Problem statement : we need to clear an item from a module however there is no simple way to identify the item to clear Below is a…
High Charts or D3 Charts in Anaplan Dashboards or Anaplan Pages?
High Charts or D3 Charts in Anaplan Dashboards? Is it possible to embed or incorporate a charting library like High Charts or D3 Charts in Anaplan Dashboards especially after the introduction of new User Interface which runs on top of the latest and greatest in HTML5? I am not sure about its validity or feasibility from an…
Optimiser
Hi Problem Statement: we are trying to minimise the fuel requirement to provide a given amount of energy. As all the input datas are in month wise for all the fuel except the demand in which month wise aggregated demand of all fuel has been taken. Error: We will be able to run the process sucessfully. But we are not…
Anaplan Excel Add-in
In our Org, we have not yet authorized the use of Anaplan Excel-AddIn so far, even though some users use it. In the past we had experienced some issues such as the model being locked during export of data by users while using the AddIn. Now that there is a new version of Excel AddIn, i am reaching out to folks to get some…
API customising for UPSERT ENDPOINT
It is required for the deployment of the UPSERT EndPoint as part of the Anaplan API to send only the new and changed entries from the SAP system to Anaplan instead of sending each time the full load file. We are currently trying to get Data from SAP via CPI( SAP Cloud Platform Integration) and we are facing this challange…
Anaplan Connect 1.4.3
Hi, Is there a way to configure the format of the dump file from tab delimited to comma separated values? In addition, is there any documentation that has a list of all the error messages that can occur within the application? I looked on the Anaplan Connect guide and whilst there is a small "troubleshoot" area, it seems…
Option to delete multiple saved view in one delete action
Hi Anaplan Team and community members, I think It would be great if we have a option to delete multiple saved view in a module in one action. Currently I am having a module with 321 saved view out of which I have to delete 167 views one by one which is consuming a lot of time. With a multiple select and delete option ,…
Automating Import from csv file
Hello experts, We are looking at scheduled import to Anaplan through custom integration and I have a question around that. Context: There will be a csv file provided on a server periodically and the import needs to be automated. 1. I read that it it is only once I manually import a file to Anaplan, that there can be an…
Is there a way to lock a period when doing imports?
I have done dynamic cell access to lock periods in a module. This is working fine when doing direct input to anaplan. But when using import function, even if access is only ready only data is still loaded in Anaplan.
Add all error types and description to Anaplan Connect User Guide
It would be a great addition to the Anaplan Connect User Guide to have all the different types of error that could be dumped whilst using the Anaplan Connect client to run actions/processes in Anaplan. It would be particularly useful for users not familiar with Anaplan (IT teams that manage the scheduling on behalf of the…
Model ID to display in Imports tab
It would be good to see model ID as a column in Actions->imports tab somewhere near Source Label & Source Object. I faced a specific issue when the model has a lot of imports, which were developed during a long period, and during this period, the source model was several times moved/renamed. Then it is nearly impossible to…
Continuously polling an operational model using Rest API
Hi Guys I have been requested by a client to continuously poll Anaplan Operational Model ( every 1 min) to EXPORT data from a module . Module is relatively small so about 20 rows and 2 cols . Right of the bat this doesn't sound like a great idea to me due to potential lock up of the model etc. therefore i wrote a Python…
Scripts and Java and MS Access
Hi, I have an overnight script that imports data from an MS Access query into a list, this worked fine with the old certs and the 1-3-3-3 environment. Now I have had to update my scripts and use 1.4.2 and there seems to be a problem with the url. Old script -jdbcurl "jdbc:odbc:EPOS" -jdbcquery "SELECT * FROM qry_EPOSLive"…
User Information
Hello, I am trying to create a model that pulls all the user information (Model roles, First Names etc) from each model in our system. This is really useful for Auditing purposes. Is there any way to import from the user lists in model settings to this model, or alternatively to create a dummy module in each model which…
Continuously polling and downloading data(every minute) from operational model
Hi All , I have a requirement to continually poll(every 1 min) and export data from an operational Anaplan model . I expressed my concerns about locking / slowing down model therefore to test it out i wrote a script which runs every min and downloads data from an operational model . Data to be downloaded is relatively…
Excel Add-In Licensing
Hi All, We would like end users to be able to use the Excel Add-In to access Anaplan modules, so they can build formatted reports using that data. Am I right in assuming that these users do not need to be Workspace Admins with a Model Builder license, as long as they are simply accessing the data in pre-built modules (i.e.…
Introduction to Data Integration
Audience: Model Builders, Data Integration Specialist Summary: Hungry to know more? Anaplan Advanced Topics are deeper dives into specific areas of Anaplan. Data is everywhere, and our customers are eager to know more about how they can get data from their databases and into their models. This process is called data…
Data depersonalization
My company does not want to upload personal data of employees to the cloud. However, there is a need for sales management. Obviously, identifying calculations / reports by identifiers rather than by employee names is not productive. It is necessary to be able to personalize through the identifiers the data received from…
Losing data from saved views & processes
Hi Team, I have a process that exports three saved views from 3 modules, however when I run it, it doesn’t capture all the data that’s in the module. I think some line items are missing. What is the best practice to either: * Ensure saved views are dynamic and update automatically for when new list items or line items get…
How to import multiple header rows into a module?
The import file is an export file from a module that I am working on. There are several header rows that I need to import into the module. How can I do this? Jan 19Jan 19Jan 19Jan 19Feb 19Feb 19Feb 19Feb 19Mar 19Mar 19Mar 19 ActualActualForecastForecastActualActualForecastForecastActualActualForecast…
Print or get source to target line item mapping through API
Hi Anaplan community, Based on clients needs, I wanted to figure out a way to print out the line items' source --> Target mapping through the Anaplan API. This is when a model builder is doing an import and gets to manually map data from the source file to the target line items but here we can quickly have an array or list…
Print or get source to target line item mapping through API
Hi Anaplan community, I wanted to ask whether there is a way to print out the line items' source --> Target mapping through the api. This is when a model builder is doing an import and gets to manually map data from the source file to the target line items. Much appreciated!
Excel Add in
We have a reports pack in excel which used the excel add in to link to various Anaplan modules. I recently created a copy of the model to run a scenario in but am not able to change my reports pack to link to this model rather than the usual live one. Does anyone have any experience of how to change which Anaplan model a…
Import from File vs Module
I’ve been running the Model Optimisation training in recent weeks and one of the benefits of Data Hubs we talk about is that Model to Models imports are faster than exporting to a file and re-importing from a file. The question is always “by how much?”, so these are the details of a test we did in April Performance test of…
CA Certificate Authentication and Forced Password Resets
Hi Experts. My client is concerned about the 90 day password reset for their system IDs. If they switch to using a CA (certificate authority) will they still need to reset the password for the system ID they associate the certificate to? I didn't see anything in the documentation about it so I thought I would ask here. The…

Data Integration

Discussion List