Data Integration

Import error log enhancement in new UX
Suggest to enhance the current import error report in the new UX. The new overview only contains very limited information about any errors which occurred during import and it is not possible to get a preview of the errors as you can in the classic UX. At the same time, the ability to export errors is limited to 50,000 rows…
Impact of saved views in Connected Planning
As companies are growing, their use of the workspace is also growing resulting in multiple models. From an user standpoint, it is complicated to audit every saved view, as you can only see those that are being used in the model where they are being imported. As such, could we have a new tab in imports not only to see the…
Applying filtering on Tabular Single Column Exports
Being an Anaplan builder/user, I would like to be able use set on the view filters for export option "Tabular Single Column". Currently, if you prepare a view with set filters, if you run "Tabular Single Column" export, Anaplan will ignore filters and include all items from all dimensions in the extract. It has two major…
Make available for a Import Data source these system columns: Current Timestamp, Current User, RowID
As a Model builder, when I create an import action and I choose an Import Data Source ( File, Saved View, etc…) I would like that the Import Data Source to have available these additional system columns: Current Timestamp, Current User, RowID that can be mapped to target elements. Current Timestamp: should be populated at…
custom source connector plugins
As an integration admin, i need to be able to create custom source connector that can be scripted (using typically python, java) to get access to different types of sources data formats without the need to go through a csv or txt file upload each time. This would allow to get data sets from reading apis endpoints,…
Hyphen formatted numbers issue when exporting to excel.
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue When setting a numbered line item to hyphen format. When exporting as xls or xlsx, the hyphen formatted cell will only ever display a hyphen, even when edited to be non zero cell values.…
Custom page separation for dashboard PDF exports
Description of the enhancement required: Allow for page separation when exporting dashboards to pdf so that two published items may be printed on separate pages, back-to-back. An example of the enhancement: When selecting options for a PDF export on a dashboard, users would have the option to choose where the page…
SAP S/4 HANA & SAP PO to Anaplan integration best practices
Hi all, Looking to see if any other members of the community have integrated SAP S/4 HANA to Anaplan. If you did, were you able to achieve the integration with Anaplan Connect or the API through the SAP Process Orchestration middleware? Or did you *have* to write some custom wrapper program using either Anaplan Connect or…
Set the fields in a certain order that will not change for exports and have alias headers
For downstream systems, the headers must have specific names that are not related to how the Planners use Anaplan. Also, some of the downstream systems are very specific about the order of the fields in the export. When Anaplan has to adapt to business changes, the export to the downstream systems has to remain constant or…
Does file ID change if I update the import source for an action?
Hi all, We are testing bulk API's data import, on which I had 2 queries. Suppose I create an action in Anaplan for a file and then data in loaded using bulk API's, but later I went to manage import data sources and updated the import source of that action with a new file. Will this change the file ID of the file which is…
ANAPLAN CONNECT - Password update request
Hi, We have 20 scripts for ANAPLAN connect, and they each contain a user logon and password. set AnaplanUser="username:password" There are 2 questions. 1) Can the password be hidden in the script, as anyone can edit a script and see it? 2) When ANAPLAN insists on a password change, all the scripts stop running, this can…
Can we send file to Azure blob using Service principle
Hi Team, We are sending the exported file from anaplan to Azure blob by using SAS Token. Can we do the same with Service Principle.
Share your experiences: Preparing Data for Anaplan
The Anaplan User Experience Research team is looking to speak with users who are involved in the data preparation process: determining what data is required, getting data correctly formatted, ingesting data to Anaplan, etc. We invite you to join us for a 60-minute, remote research interview during which you will be asked…
Anaplan SAP Integration
Hi Community, we want to integrate SAP and Anaplan, but client has asked not to use any files for integration, so is it possible to load the data from SAP to Anaplan with API in json format? and how to map the fields. Please suggest
Anaplan data integration
Hi Team, We have integrated SAP with Anaplan and data flows are scheduled from SAP to Anaplan data hub. However we keep getting memory warnings for workspace as i am sure this is to do with workspace memory. From an architecture standpoint how does Anaplan store data in datahub ? when we are sending 2-3 MB of data from SAP…
Integrations Specialists: Help us test a new method of connecting third-party systems with Anaplan
The Anaplan User Experience Research team is looking to speak with Integrations Specialists to provide feedback on an innovative new method of connecting third-party systems with Anaplan. We invite you to join us for a 60-minute, remote research interview during which you will be asked to weigh in on this key innovation…
'Used in Dashboards' and 'Used in Action/Import' for SAVED VIEWS
When performing model clean-up's OR revising actions / New UX dashboards, it would REALLY helpful to have a view within the model settings area to review the full list of SAVED views along with the following key information; * 'Used in Dashboards' * 'Used in Actions/Processes' * 'Used in New UX Dashboards'
Filters on import to list actions
As a model builder, i need to be able to filter the list items created based on a criteria. This is required as we currently operate models that determines a calculation scope of contracts and the needs to import the corresponding cashflows to calculate profitability. Currently we need to import all cashflows from our…
Anaplan Connection - Invalid Credential
Hello team, We are getting an error frequently, almost daily baysis, related to "invalid credentials" between Anaplan connection and Power BI Desktop. Every time that team (two developers analyst) needs to work with the data, we need to reset the password and we are worried about this for the future. Do you know if this…
Share your Experiences of Data Preparation Processes in Anaplan
The Anaplan User Experience Research team is looking to speak with users who are involved in the data preparation process: determining what data is required, getting data correctly formatted, ingesting data to Anaplan, etc. We invite you to join us for a 60-minute, remote research interview during which you will be asked…
Kindly help with steps to configure S/MIME certificate
Kindly help with steps to configure S/MIME certificate
Export line item codes
Description of the enhancement: To be able to export the line item codes instead of only the line item name. Description of business use: I have a financial statement report module where I have accounts as line items. This is because some of the accounts are calculated. We have a need to export this module with account…
Text Formatted Line item character Limit
Hi Team, Just wanted to know do we have any Limitation of character for a text formatted line item value entered. I am aware that Max of 60 Character can be entered for a line item name , but for value to be entered.is there any Limitation and will it effect my model size aswell. Thanks Madhu
CA Certificates for Service ID (Password less Connectivity)
Do we have a list of CA Certificates that are mostly used to implement password less integration with Anaplan and if anyone has an estimate of pricing & validity of those certificates? Our client is looking for the feasible options while choosing the Certificate Provider - So a consolidated list will actually help the ask.…
Data Related Training Classes
* Anaplan Connect (301) * Anaplan Data Integration Basics (303) * Creating a JAVA keystore for use with Anaplan Connect Overview This set of classes address how data is used and managed within an Anaplan model: Anaplan Connect (301) Anaplan Connect enables the Anaplan administrator to automate Anaplan imports of data and…
Anaplan API 2.0 Python Library Certificate Error
Hi, We are trying to change from basic authentication to using a certificate. I am using the Anaplan API 2.0 Python Library. When running AnaplanConnection function I am getting the following error that I traced to the anaplan_auth.py. TypeError: from_buffer() cannot return the address of a unicode object I have tried…
CloudWorks
Hi, I have just started using CloudWorks, it's a great Anaplan in-built tool for integrations and processes but does anyone have any idea how can we run subsequent process in it. for ex. I have a process A and process B in my model and I want to run in a manner that as soon as process A is complete, Process B should start…
SKU.csv file on level 1 exam
In the first part of the level 1 certification exam it tells you to create a new list using the SKU.csv file they give you. The SKU.csv file you download ends up being multiple files in one folder. When I try to import the one of the attached files (SKU) into my new list (P3 SKU) nothing happens on my screen. Then on the…
How to calculate Anaplan model size?
Hi Guys I am using below calculation to find model size 1000000000 cells = 9.3 GB 1 cell = 9.3/1000000000 Total cells exported from module export = 6206436639 which gives me 57.71986074 GB's problem is Anaplan shows model size as 39.29 Gb's ?. I have used this calculation on 8 models and all of these comes close to model…
Integrations Specialists: Help us test a new method of connecting third-party systems with Anaplan
The Anaplan User Experience Research team is looking to speak with Integrations Specialists to provide feedback on an innovative new method of connecting third-party systems with Anaplan. We invite you to join us for a 60-minute, remote research interview during which you will be asked to weigh in on this key innovation…

Data Integration

Discussion List