Data Integration

Getting an error when trying to run an Import Action using Python3
Hi, I’m new to Anaplan and am trying to automate the process of refreshing data from a file that has been previously uploaded and imported to a module. I’m referring to the Apiary and this github repo https://github.com/cdhippen/Anaplan-Python3-Scripts/blob/master/Action%20scripts/action.py I’ve created a certificate file…
KeyStore Wizard for Anaplan Connect 1.4
Anaplan Connect 1.4 certificate authentication has changed from previous versions. New certs are issued by your company instead of Anaplan and to provide increased security, all certs must now be secured in a Java KeyStore. Because the KeyStore setup process requires a fair amount of setup this tool was created to simplify…
PDF documents
Hi Is it possible to define a line-item with reference to a PDF document? Thanks!
User access. Request could not be processed.
Hi all. Can anyone help solve problem with access into my model for new user? Each time when he's trying to enter, he receives message. Please find attached. Most intresting, that for others new users with the same Model role, this error not shown. Thx in advance.
File delimiter while importing data through anaplan connect
Hi, We are trying to import a file which has ; as delimiter through Anaplan connect batch files. But each time, Anaplan connect changes the delimiter to “ and the import is failing. Can we use ; as a delimiter in Anaplan Connect import files or only , and tab are supported? If we change the delimiter to , then the import…
Anaplan Connect 1.4 Import Issue
Am migrating our Anaplan Connect batch files from 1.3.3.5 to 1.4 and all is going well except that when it comes to running an import routine it fails because the first column of data in the upload file is titled "crazy character"name rather than just name. Is this a glitch or something else? Works fine with the original…
Customise dimensions on exports to Tabular Single Column format
Description I would like to abiltiy to customise which dimensions are exported in Tabular Single Column format. Currently it exports all dimensions but I would like to ability to change this depending on my requirements. I am aware of the ability to fully customise the export using the Tabular Multiple Column but I would…
Multiple JDBC queries in one configuration file
For a customer I use directly SQL scripts that are used in Anaplan connect (1.3.3.3). These SQL scripts connect directly to the ERP system. Now with the change of Anaplan connect 1.4, you must use a JDBC propertie file which can only holds one query. At this point of time I have 170 SQL scripts that looks to 6 different…
Mutual Authetication for Anaplan V2 connector for informatica i-paas
As of today, Anaplan v2 connector in informatica i-paas only use client authetication, it does not offer server athetication. While today's security demand is for Mutual authetciation. such an enhancement should be made to support Mutual authentication using CA certificates.
Don't change tab colour when refreshing view in Excel Add-in
Description: Excel Add-In: When refreshing report views, rather than changing the tab color upon refresh, please leave original tab color. Benefit/impact: We use tab color within an Excel workbook to differentiate financial reports for management. We also use it for organization of data.
Export only current page selection
Description: As a model builder, I want to give users the ability to efficiently export their dashboard grids. Currently, when you save an export definition on the "Current Page", this current page does not change when the export action is published to a dashboard based on that dashboard's page selectors. Example of the…
Updating Organization List - best practice
Hi I have a module that works out accruals & prepayments by contracts and when each contract gets added it is mapped to an organization parent. The issue I have is that the organization list constantly changes each year and therefore needs to be remapped. I know if i delete and import a new organization list, i will lose…
Can one control the order of a Module Export to Singular Columns?
Hi there, I need to get a very specific order to my Export to Tabular Singlular Columns. Right now I cannot seem to control the order of columns that comes out. Is this possible to do? Thanks in advance for your help.
Import of data into the module with Subsidiary Views (use of subsets list on line item)
Hi, anaplaners! Can you help me figure out the import of data into the module with frequent use of the list subsets? The module is P&L report, where each article is a separate Line Item. For each article, it is planned to assign its own subset of the list "Cost Centers" to optimize the place in the module. Also, subsets on…
Option to remove column headers in CSV export
Description of the enhancement required: When using a grid lay-out for the export to CSV, Anaplan will also give the headers of the line items in the module. This isn't very convenient for us because SAP (where we upload the export) doesn't recognize these headers. Therefore it would be very handy to have the option to…
Anaplan Connect 1.4 Import Issue
Am migrating our Anaplan Connect batch files from 1.3.3.5 to 1.4 and all is going well except that when it comes to running an import routine it fails because the first column of data in the upload file is titled "crazy character"name rather than just name. Is this a glitch or something else? Works fine with the original…
OEG Best Practice: Imports and exports and their effects on model performance
Overview Imports are blocking operations. To maintain a consistent view of the data, the model is locked during the import, and concurrent imports run by end users will need to run one after the other and will block the model for everyone else. Exports are blocking for data entry while the export data is retrieved, and…
Data Integration
Data Integration can be a large and complex topic. These lessons will help you get on the road to understanding your integration options. Note: These courses are also part of the Level 3 Model Builder Training available on the Learning Center (learning.anaplan.com). They are provided here as informational only. If you need…
Replicate column headers on dashboard PDF export
Description of the enhancement required: Replicated the column header in a dashboard PDF export, when the grid is split on multiple pages. An example of the enhancement: When you try to export a dashboard in a PDF, the column header (the month for example) are not replicated on the second page and the following. I can't…
Need to trigger informatica job from Anaplan dashboard
Hi team, I need to confirm if Anaplan provides any functionality so that we can trigger the jobs in informatica cloud from Anaplan dashboard. There is a requirement in which I have to click the button from dashboard and it will trigger my informatica job to load the data from my source system into Anaplan Model. Could…
Ability to copy export label settings from one export to another
The ability to copy label settings from one export action to another would be very helpful. If there are several similar export actions with different filters that need the same list properties, this would be useful, as the person creating the action would no longer have to select each property one by one.
Planning for Efficient Imports
Take time to determine the most efficient way of pulling your data in. With multiple views, it is common to think about each view separately, but when it comes to importing data, a holistic view is key. For instance, if you would like to see a current roll-up of sellers to teams and a historical view (i.e. – which seller…
March 10, 2018 Release Discussion
Do you have feedback on the the March 10, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
Importing Excel data to a module by using hierarchical list
Hello Anaplan community, I would like to import data from Excel source to a module using a hierarchical list. In my data Excel source, I do not have the column Parent, which will helps me to import data with the specific list. Let's imagine I have an hierchical list that contains 3 subset lists : A, B and C. In my data…
Option to select a file when importing into users
As per email from Anaplan Support: Currently, for an action uploading data into a Users list, the file is not able to be selected at the start of the action. This file would need to be changed manually in the actions menu by going to Import Data Sources and choose new source. Then pick the file with the same exact name as…
Dynamic Subtotal in the Excel Addin
Hi gang, Very interested to have a dynamic subtotal in the Excel Addin please. So lets say I select several items in a product hierarchy or just two out of my 3 channels. Here I would like the API to refresh the subtotal of these items instead of pulling in the explicit rows/columns selected. There would need to be a…
ERROR: "API invocation failed: Illegal argument"
Good morning, i receive following error when trying to edit the import data source: "API invocation failed: Illegal argument" In the same time even if source is pointed to production and users have access to the workspace- system gives error "You do not have access to the source workspace" Any thoughts?
Mapping Line Items to List Items with huge data
I am unable to import data from my source module to target module because data in source module is under list item whereas in the target module it is under hierarchical line items. The source module has 79 lakh cells under each line item which needs to be mapped into 600 source module list items, it needs to find the…
REST api to Execute Import Action Error
I have a java application where I'm trying to execute an import action using the REST API and am getting the returned status of 415 (unsupported media type) from the post. I'm following the syntax defined in the online help:…
Excel Add In v3 - Install failed with "Install Visual C++ 2013 Redistributable"
I've tried installing the add in several times with the same error - "Product: Anaplan Excel Add-in (Single User) -- Please download and install Visual C++ 2013 Redistributable option "vcredist_x86.exe" to proceed." I've downloaded and installed the C++ package, both x64 and x86 versions (PC is installed with Windows 10…

Data Integration

Discussion List