Data Integration

Excel Add-in to highlight header mismatch if user changes it by mistake
Once we import a view in excel using excel add-in and let's say there are 4 rows in the view City-A City-B City-C City-D Keeping the order same, if the user renames City-A to City-ABC by mistake and then tries to push data to Anaplan then instead of showing no changes, Anaplan should show header mismatch. This can further…
Excel Add-in Data sync to generate Log in Anaplan History
Anaplan to generate detailed log of Excel add-in sync in history. A cell level change log as we see for any Anaplan cell in any of the modules.Ex: 1. Value of one cell in excel add-in got change from 1000 to 80. 2. We do refresh and sync data. 3. Anaplan generates a log in history for this line item value against that cell…
API
Hi Team, 1. What is API In Anaplan? 2. How to configure API and can you please explain step by step. Regards, Mahesh
Memorialize Actual Data in Historical Planned Versions
Hello, I am currently running into an issue with one of my models where historical plans are changing due to actual restatements. I have a model with 4 versions. Actual, Budget, Working, and Current Forecast. Working is where all of the planning is done, and then that version is copied from working to current…
Formula to display values from the page selector in a column
Hi, I need to be able to display the page selector value in a column. The purpose of the module is to assign multiple positions to an order. If it had been the other way around (assign an order to position) I could have used an "assign" action, but, now he task is to do it this way. I need the order column to display the…
Adding Un-editable Note in Export Action
There is need of adding a disclaimer/note in the first cell of file. How to add that cell in the exported file.? and also that disclaimer should not be editable in Anaplan model when another file is imported with different disclaimer.For Reference: I Have attached a Screenshot. Employee(Column B is the List), Comment and…
Reporting
This is the module I have. Now for the output is it possible to get the report of the module edited into the below view without editing the list name. I have no restrictions to create a new module or new list.
HELP! Anaplan not working
I'm having issues using Anaplan through excel. I log into Anaplan through excel and I then click on New to open a new pivot table. At this point, a message appears just below which says "This worksheet does not have a connection to Anaplan." A second window opens but the window is grey and nothing seems to happen. Has…
Dashboard Export All Hierarchies
I want to export as PDF a dashboard for each Hierarchy within my Org without having to do it one at a time
Saved View Categorization and Priority Sorting, Including both Auto and Manual Options
Saved Views are a critical feature for most Anaplan models. The key issue I have with using and managing Saved Views is that, they can vary drastically in terms of importance. Below are two examples of Saved Views: * A Saved View could represent a key, filtered definition within a module that dictates how your entire…
Show Created/Updated Items in Imports
Would be extremely useful for testing and user feedback to show which items were created/updated in the import dialogue. If the import was successful, Anaplan only displays the number of created/updated items. A preview of the created/updated items would add clarity. If thousands of items were created/updated then Anaplan…
Anaplan v3 Connector for Mulesoft - Doest the connector refresh token for subsequent API calls
Hi All, I know that Anaplan V2 Connector for Mulesoft does the token refresh for every subsequent API, but has this behaviour been inherited in Anaplan v3 connector, because we are seeing Anaplan throwing error for subsequent calls made for import via the v3 connector. Regards, Praveen R
Anaplan Connect Error 1.4.3
Hello, We've been receiving the below error on one of our export scripts. This happens about once or twice a month and there seems to be no rhyme or reason for the failure Has anyone seen one of these errors before?
Format of output
Hi Friends, I am having the data in this format. I tried it in excel but I am getting the output in the below format. Even making States as List Formatted Line Item didn't work. By any chance can we get the output in the format of Pic 1
Funtional Area
Hi, Is it possible to have a sub-functional area to be shown in the Content Panel? Example: Function A Sub-Function A.1 Sub-Function A.2 Function B
Importing issue
Hi Members, Please help me in this import error. The original file: The original module: I am trying to fill the Role Column. Importing error.
How to find overall total
I can see subtotal but not overall total. Please assist me in this.
Anaplan Connect Workspace to Workspace
Hi Anaplaner, Can I use anaplan connect to import data from workspace to another workspace ?
Bulk Copy - Scheduling
We all know how useful Bulk Copy is - When the data across the model needs to be moved from one version to another or from one list item to another list item Bulk Copy plays the pivotal role. WS admin has to perform this task manually all the time as per the need. Can we have an action created when WS Admin runs the Bulk…
API export with a filtering parameter?
I have an API process that pulls data from a module that includes the Users dimension. There may be multiple users in the system concurrently and I need to keep their data separated. I need to filter the export from this module for a specific user -- the one who clicked on a link URL on an Anaplan dashboard to initiate a…
Update Target Object of Import Actions
Hi, It would be nice to have the ability to update the Target Object of and Import Action to a module or list with similar/identical definitions vs creating new actions from scratch. We have come across instances when building out a model we determine that an already created Import Action needs to have the source data…
Excel add-in German Localisation
As an end user I would like the Excel add-in to be localised for the Standard German language.
Error : Anaplan API: Could not connect to database! (SQL: No suitable driver found for
Hello, We are currently of migration from Anaplan Connect 1.3.3 to 1.4.3.When we launch our .bat, we get the following error message: Could you help us about this error message ? Regards,
Anaplan Connect Upload Error
Hi, This is the first time I am using Anaplan connect. While creating the script and looking at the documents, i drafted a script that allowed me to first upload, import thru an action followed by lastly a process. I have apparently uploaded the file successfully however I am met with problems with my action that imports…
Test Automation of Anaplan Application
Hi, We are trying to perform test automation on Anaplan. We tried using HP UFT and Wroksoft Certify tool. We tried to capture objects as it is done on a web application but We are not able to identify the objects. Can anyone please provide inputs on what platform Anaplan was developed (e.g.Java, Silverlight etc.). Thanks…
Excel Add-in 3.2 vs. 3.3 vs. 3.4
Dear everyone, I am part of the IT organization at my company, and I am responsible for the Anaplan environment from am IT perspective. We are currently using the Excel add-in v. 3.2, which meets our organization's requirement to control the data in Anaplan (read only, not write-back). My organization wants to keep the…
Imported data automatically multiply with 100
Dear everyone, My company is in the 1st stage of building Anaplan. Recently, we've managed to automate the process of data integration which is to import data from our server (Microsoft AX 2012) into Anaplan. To be simplified, we have 2 step. Firstly, a batch job will download data from server (pre-scheduled) to a local…
Data Import from excel
How do I import an excel data grid with no unique ID and no unique combination of property? Note: Customer is looking for keeping anaplan as system of records and wish to generate a unique ID within Anaplan, but key thing is it has to be a import/ not insert using dashboard. Thanks Arun
Update the Data in Current Module
In my current module which is dimensionalized by a numbered list I added additional 4 line items .. and I have a csv file based on which I want to update my current module. However, the dimension is a numbered list and display name has a logic to it. I have lot of other keys which can be unique to update the data, however,…
Set default file to everyone
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type selected. This would really assist in debugging and remapping import files.

Data Integration

Discussion List