Data Integration

Script to Automate Current Date Import
I have a client that would like to automate the process of updating the current date in their Date Attribute module. Are their any scripts available to auto-generate the current date to load into their module? Ideally, we would install and use Anaplan Connect. Thanks, Tony
History Export Slow and large file
Hi, I wanted to check if anyone has experience on regularly exporting the history of the model. I have a model for which I am trying to export the 30 days history and it lasts a few minutes to download a 3.5Gb text file. It's a big file that's hard to manipulate. Is there a way to easily do that? Any best practice tools?…
Customized Mapping in Imports
Hi, I am unable to customize the mapping for imports in Anaplan, as an non-workspace admin. I was able to do that until 17-jan. Can you please guide if that's a change/bug in Anaplan Platform. PFA the screenshots for your referral.
Option of removing the space for Row label header from the export file if the header is not included
In the model currently we doing an export to APO. Our export file currently has a blank line which is generally there for the Row Label headers. APO is not able to pick up the data from the file as it it not able to distinguish between the header row and data row because of which now we have redesign the complete set of…
Anaplan Certification Types
Hello Friends, Can someone help me about what types of Anaplan Certifications are available? Are all of them chargeable? And what is the minimum cost for any Anaplan certification? Thank You. Regards, Sammy.
Allow history export summary only
When the model history is shown on the screen it is as a summary. When it is exported as a file it contains all the details. For some uses this is too much data and it would be good to have the option to export as a summary, just like the data shown in the dialog.
Export the 24 hour history summary without transactional detail?
I have a nightly batch that runs 14 processes. Most of them upload a file and run two import actions. Since this is the data hub, the only activity is this batch. The History page for the last 24 hrs shows a nice summary of what got done. During routine operations, users will rarely go into the data hub ... so there's not…
Anaplan Connect - Cannot enter password
Good afternoon, I am trying to upload a file using Anaplan connect. When running the batch, the windows prompts me with a password. However it seems that I'm not able to type anything for whatever key I press on the keypad. my script : @echo off rem This example loads a source text file and runs an Anaplan import into a…
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…

Data Integration

Discussion List