Data Integration

File Import Issue due to Control Panel Local Language Setting
Some users in Europe are facing issues importing offline excel file into Anaplan. Currently we have a workaround for this issue. If user changes his Format setting in Region and Language to “English”, then the upload is successful to Anaplan. Users have to change their local language setting every time they need to upload…
User Automation
Hi, I want to export file from users through automation and import it in the staging list. I am not getting updated exported file when i am running the process. May I know how it can be done. Thanks Pankhuri
Cloudworks Integration run vs Schedule
Now using the cloudworks integrations and have come across an annoying situation. Once I set a schedule for an integration the option to run it now disappears. Only way I can find to run it now is to cancel the schedule (deactivating not sufficient) and then rebuild the schedule after I have run it and made any changes.…
Integration between AWS S3 and Anaplan using Anaplan Connect
Hello, I have a scenario where I need to integrate AWS S3 and Anaplan as for Imports and Exports. There is no integration tool so I have to use Anaplan Connect. If it's a system, I can store downloaded Anaplan Connect folder but S3 being a cloud system, I have trouble placing Anaplan connect folder to make the connection…
Distribution Group for Anaplan Integration?
Hi All, While attempting to open a service account for data integration purposes we received some pushback from our directory services team. Specifically because we requested that they open a mailbox for the service account to receive the initial password email. The software engineer on directory services recommended that…
Paste more than 10,000 cells
The limit of only being able to paste 10,000 cells is too small. Ideally it would be 100,000 to cater for larger data sets
Models topology- visual version
The idea is to implement a visual model's topology map. The initial idea is to build it like the module map available in the model that shows all module dependencies, but for models. Currently there is a possibility to find information about ALM models that are synced with another on the revision list and on the source…
Latest Article: Importing with Varied Dimensions
Please read out my latest article on Imports featured under best practices. https://community.anaplan.com/t5/Best-Practices/Importing-With-Varied-Dimensions/ta-p/89698 Misbah
Refresh Function in Excel Add-in should provide option to submit changes
Description: If a user changes data in a read/write view of data in Excel via the Anaplan Excel Add-in and then subsequently clicks on the "refresh" button, the Anaplan interface does not inform the user of any changes that have been made to the data before the view is refreshed. This results in any changes being cleared…
Level 1 Model builder training
Level 1 import Module data activity 7.2.3 the file i downloaded has date format 20190212, and receiving an error invalid date. the line item is formatted to Date , is there any additional step i am missing
Excel add-in, Date time settings
Excel Add-In error: Refresh failed due to unexpected error. Found out that when the Excel template is created with Regional settings [ ex. decimal symbol as Dot / . ] is different from your system settings [ ex. Decimal symbol Comma / , ] then the refresh fails and shows up unexpected error. This is solved as soon as the…
Gather 4 Clues to Find the Mystery Roadmap Item
The end of the year is fast approaching, and in the UK this usually means lots of quizzes (now done virtually, as opposed to at the pub). In June, I did a quiz about the Extensions, but many things have changed since then—so here is a new one for you to polish your knowledge about those products, as well as to discover an…
Batch printing, exporting, emailing of NUX dashboards and worksheets
Description: As an Anaplan user, I would like to be able to print, export, or email Dashboards and/or Worksheets in the New UX based on a selection of list items relevant to the the Board/Worksheet. This process should be able to be scheduled (e.g. daily, weekly, monthy at a set time) or run on-demand by the user. The user…
Need Clarification on Informatica Power center integration with Anaplan
Hello Team, Can any one help on below scenario I am trying to integrate Anaplan with powercenter using REST API in HTTP transformation.As HTTP Transformation doesn't have PUT method to upload data in Anaplan action.I am trying to use POST method available in HTTP transformation to call PUT method using function…
Level 2 - Sprint 2 - 2.3.8.1
Hi I have just created a module as per instructions. I am still not clear about assigning CATEGORY. I have set up a Data Tag as DEMAND MODULE and a functional area as DEMAND. I am not quite sure whether this is what I am supposed to do. As upi can see in the screenshot the DEMAND functional area is showing up in the…
Disclosure Management Tools
Colleagues, hi! I was wondering if you can share your experience with different Disclosure Management tools that you've used so far in your organizations for the purpose of IFRS / US GAAP full pack preparation. I've heard from my colleagues that there is expected to be delivered a new type of page but, personally, I doubt…
Filter issues
Hi Team, I have observed one issue popped up with filters in a dashboard. i am able to apply and view the data in Dev However, when i move the chagne to qa , the filters are disappearing and the data is not displayed. we have items in L4 level too. Could any one suggest what is the exact issue? Thanks in advance.
Import Into user settings
Hi, I have one question related to import to user settings. I have created one dashboard for managing user access for end users, i have created one process to import changes into user settings. While testing i figured out i am not able to access process as i don't have workspace admin access. Is it compulsory to have…
Download Data file: Countries.csv
Anyone having a problem importing this above date file? I click on the download file but is not showing. Please advise, need to complete 4.6.4 Activity: Import Data Thanks. BA
Docusign mapping
Hi , I am trying to integrate docusign integration . I am struggling to map line items in template . I have a below module ,email is email format I want to send a template with line items (first name,last name ,a,b) to "email ids" (3rd line item) .I managed to send the template to email ids but not able to pick the other…
Level 2 - Sprint 2 - 2.3.9.1 Import DAT03 Historic Volumes module
Hi I have got this error message however I tried to do it. I am not sure where I am going wrong. I followed the Anaplan community replies thread but am unable to follow. Obviously this is why I am still getting the error message. Some help will be greatly appreciated. I have attached screen shots of the DATA HUB Model…
Model 1 - Importing Data Error
I'm stuck because I keep getting the same error. I've downloaded and saved the spreadsheet several ways, but nothings working. Please help - I'm Stuck!!!
Integration with Anaplan usin Informatica powercenter
Hi all, I am working on a Anaplan project. We have to integrate our source system with Anaplan using an ETL tool. My client has Informatica Powercenter. I know from Anaplan community that we can connect Infomatica cloud with Anaplan as Informatica Cloud has Anaplan connector 2.0 built in. I assume that since Informatica…
Export multiple modules into unique file
As a Model Builder I want to create a Process to trigger multiple Export actions at once, each export linked to a different module. However, the Process generates as many files (csv, Excel, txt,...) as the number of Export Actions within the Process. It would be better if the Process could generate a single file (CSV,…
Run export from source model to target model
At the moment in order to transfer data between models manually it is required to open the target model and pull/import the data from there. Having the additional functionality of running an export from the source model to the target (pushing the data instead of pulling it) would enhance the user experience in some…
Actions not present in new UX
Hi I am replicating my company's model into the new UX and several of the actions/processes aren't moving over When i go to 'add action' and type in the name it doesn't appear. I'm confused as to why it's doing this Any help would be appreciated Thanks
Excel Add Ins
Our Extensions provide a powerful way to connect your Anaplan environment to MS Office and so share Anaplan data across your wider business community. Details of the latest version information around our Excel Add In can be found here;…
Anaplan CloudWorks
Simple, agile data integrations - CloudWorks is now available to all customers. See the release notes and information here. This gives intuitive data integration capability to the hands of the Anaplan users - know where your data comes from, where it goes to, and control the timing and frequency of the interface. If you…
Master Anaplanner Maintenance - mentoring a model builder
I have a question regarding the Opportunity to mentor a model builder through the L2 training. 1. Do they have to complete all the way through L2 by the end of the year? I have a couple of customer resources who are interested but they are not 100% certain that they will be able to complete by 12/31 because of their…
Publishing of the dropdown option
Hi, I have two different hierarchy of lists. Both have n number of hierarchy. List one has display name as Priya and the other list is referred as Priya | Anaplan, Priya | Java. The display name for second list is the combination of first list and course. Here, Priya | Anaplan, Priya | Java have same Priya. As first list…

Data Integration

Discussion List