Data Integration

Import monthly data to timeline
I have seasonality input per month (January, February, etc.), summing up to 100% in a full year. How can this be uploaded to the timeline?
Make upload templates as a flat file so we can have 1 upload template per model
It would be interesting to have the possibility to have upload templates as flat file in order to ease the management of upload templates. This would allow us to have to manage only 1 template, and a list of columns that are "uploadable" We would need to have as many columns as dimensions, 1 column for the line item and 1…
Date Stamp List Property for Imported Data
A similar concept around date stamps was suggested here: https://community.anaplan.com/t5/Idea-Exchange/Date-Stamp-for-manually-entered-reference-data/idi-p/38423 but I would love to see this for imports too. A problem I've come across is importing data from a CSV without a date column into an import list. There are…
Changing the date format while exporting data from a module
Hi all, We have a module where the time is like Jan-19, Dec-18 etc. But we want the export file from the module to have date like 201901 or 201812. Is it possible? We don't have the option of exporting the data out from the module and changing the format and loading into another module as these are biggest modules and we…
Improve performance of list property imports
Description of the enhancement required: To load data into Anaplan, we need to load data to a list in order to populate items. We also hold all properties of the list in modules as line items for performance reasons. To complete a data load, we need to run two different actions for every data object we bring into the…
Anaplan Connect 1.4 Documentation issues
I have found several errors in the Anaplan connect 1.4 PDF documentation ref: Anaplan Connect Guide - Version 1.4 - (Last updated December6, 2018) On page 52 (in Appendix E, numbered as 47) a jdbc.properties file example is shown. The jdbc.connect.url parameter is show as jdbc.connect.url= " jdbc:sqlserver://localhost” It…
How to map a line item into a dimension
Hello, I have a module with dimensions Employee and Time (Months). The module contains a list formatted line item "Shop Number" (the shop the employee works in), and number formatted line item "hours worked" (the number of hours that employee worked per month). I want to bring this data into a second module with dimensions…
Login As a User Feature
Hi all, We have several different models in the Anaplan tool created for our company. The models are built for several different business units and different countries. When you are a specific user from one unit or one country, you see the correct data. When you are a super user (not admin/anaplanner) and you have access…
Exporting data of selected line item from module
Hi team, I need to export the data of some selected line item(not all) from the module. As from general export it is exporting the whole data of all line items. Could you please suggest a way to export the data of selected line items from module. Thanks in advance. Regards, Mohammad Husain
Option to Omit Empty rows for imports
Description of Enhancement: I would like the ability to Omit Empty Rows when importing How this would help their business process: We have saved views used as IDS for imports between models. There are two fundamentally different approaches to set up them: 1. If we put all necessary dimension in rows and apply imports, it…
Excel Add-in v3 and Office 365
Will the Excel Add-in v3 or later ever support Excel 2016 in Office 365? If not, is there a fundamental reason for that? Regards Dave Easey
Best way to set current period (month/quarter/year)
Hi All, I've seen my question answered in bits & pieces, but hoping someone can give me a comprehensive walk through... My team is looking to build modules that will automatically assign current period reporting so that we can leverage the excel add-in with minimal human manipulation - really just looking to hit refresh…
Import Action Editor Visibility
It would be great if all features of an import action, including field mapping, were visible and could be edited in one place. Particularly challenging today if an import file is set to private, once it expires after 48 hours, it is impossible to view or edit the import mapping.
November 17, 2018 Release Discussion
Do you have feedback on the November 17, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
Number format being changed when importing between models
I am attempting to set up an import between modules in two models; the target module has a has a list of numbers as the 'applies to' while the souces has a list of business areas. To get around this I have created a line item in the source module to assign each entry a number reference. This number is formatted at zero…
Model Import Failure
HI All, I'm trying to import a model from one workspace to another but I'm getting the attached error. This error is happening only for specific models and not all models to which I have access to. Can you please let me know what is causing this issue. Thanks & Regards, Prateek
See error dumps for previously run imports
As a model builder or data integration user, I want to be able to see a history of all the recent imports into Anaplan as well as access the associated error dumps for each of those actions. Currently, when I run an import or import process via the UI and there are errors, the error dump shows on my screen and I can…
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.

Data Integration

Discussion List