Data Integration

Center of Excellence Map
Having an org chart with names and contact info built into each model accessible via drop down menu by "support" to see who owns the models and leads the Center of Excellence would both help users identify who they can contact internally on initiatives or for internal support and it would evangelize the vision of connected…
Data Export for Selected Line Items Only
Hi Everyone, I have a view that I want to export into a file via action. The view has 2 lists as column and 3 line items across. The module itself has 7 line items. However, the export always output all 7 line items. Is there a way to limit the export to the selected line items only? Regards, Andre
Allowing imports into more than 1 fixed month
It would be nice if we could select “Fixed Months” when doing an import and have the option of importing one file into multiple months rather than just one month at a time.
Issue importing dates as text
Hello, I'm trying to import a date into a text-formatted property from a source file. This works on my machine, however when another user uploads the same file, it seems to be creating a text field which includes 2 digits for the year vs. 4. So, when I run the import, the text-formatted field reads "12/31/2018", but when…
Lists - duplicate childs for each list members
Hi, I'm working on a financial forecast model where sales is presented through 18 markets (Countries) to the 5 Products. So for example: * Product 1 - Country 1 | - Country 18 * Product 2 - Country 1 | - Country 18 * etc. I have made several lists with: Total Company (L1) -> Products (L2) -> Markets (L3). Is it possible to…
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…

Data Integration

Discussion List