Data Integration

Smart Sheet Add-In
Hi Anaplan, It would be great if Anaplan developed a Smart Sheet Add-In. This is a great alternative to presenting data in excel due to browser based flexibility and functionality of Smart Sheet. Thanks, Usman
Date Format conversion
I have a module in Anaplan whose one line item is date formatted. I imported a csv file which is having a date column with the format MM-DD-YYYY. The import results showed a failed report becasue it accepts date format as MM/DD/YYYY. Is there any way to map my csv file having the abovementioned format with the date…
Import of partial list
Hi All, Is there any way i can import a part of list into a model from a huge list from another model?
Can't upload the parent under partner list
Can't upload the parent under partner list
Get list of all models in workspace.
Is it possible to get list of models from workspace using Anaplan Connect? When I use Anaplan Connect, I have to use model ID. I want to download all models with model names and Ids. Customer will choose Anaplan model name in his app, I will download all models and I will get Id, I will send Id to Anaplan.
Ranking on data Loads
Hi, Please see attachment for details. Thanks in advance. Regards,
Parent Child Mapping Error
Hi, I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify those combinations in a staging module for error check in anaplan.
Option to insert action before or after
Currently when I create an actions from within the Actions tab I only have the option to add this at the Start or End of the list of actions. It would be very useful to be able to select an existing action and use the 'Before' or 'After' functionality that exists when creating module or lists. This would save a lot of time…
Importing a spreadsheet into a blueprint view: ability to map to column headers
An awesome function that's so close to being functional is importing a spreadsheet or another module/view into a blueprint view. Right now, unless I'm doing something wrong, I can only map things to Line Item, Code, and Parent. It would be awesome to be able to map everything that's in the Blueprint view column headers and…
Fully connected planning for contact centres
Contact centres regularly use expensive workforce management solutions that are inflexible and difficult to work with. These solutions focus on managing call handler schedules (ie what they're doing at each point in the day) against customer fulfilment (how quickly they're getting to support that customer). These solutions…
how to do variance in list items.
Hi All, how to get the values form one module to another module in list items using subtracting function. Please find the attached Screenshots list items formula given bellow: Base-Base Base- Simulation 1 Base-Simulation 2 we have using bellow formula IF ITEM(Snapshot Versions) = Snapshot Versions.Base THEN 'TW28: What If…
Read access and write access driver query.
Hi, I used read access driver and write access for a line item to get the dynamic cell access. (calculation formula is used to get the data for this line item) . 1)It is not working though I used DAC concept 2)Quaterly data is also not displaying for that line item though I changed summary items to ALL or ANY from None.
Make Existing List a Parent of another Existing List
I have two lists that already exist. The first list has items that are a concatenation of employee, role, and project. The second list is just the projects. There is a module that has the following items (in addition to others): * Text format: concatenation of employee, role, and project * List format: concatenation of…
size limit of data loads
Is there a limit on the size of data imports taken through the Anaplan Connect?
Reject Entire Import
For both lists and modules, it would be nice to have an option to reject an entire import if any errors are present. A similar feature already exists for lists that allows us to reject imports on the basis of duplicate line identifiers, but expanding this to reject the import if any errors exist would be extremely helpful.…
Line items with list dimension - Importing data and design of model
Hi, I am modeling our warehouse operations and it has a bunch of line items and "categories" as follows: Jan-19Jan-19Jan-19Feb-19Feb-19Feb-19Mar-19Mar-19Mar-19 I/O…
Separate Report Export per Region
Is it possible to setup an action where a report export to xls loops through all territories and saves a separate file?
REST API CORS block
Hi I can successfully connect to Anaplan using Postman. Can do all the necessary calls and get returned data. However, if I try to access the REST API via REACT, Angular or even regular webpage I am always blocked by CORS. Can anyone offer some advice on this?
Restricting Anaplan access to a particular network.
Is there any way to restrict users to access Anaplan outside any organisation network? or If i can restrict a user to export the data outside organisation network for the sake of data security?
Simulating Ad-Hoc Data Push With Anaplan Connect
Currently, Anaplan does not support data push, or ad-hoc integrations from within the platform. This can be achieved using a microservice, such as Flask, but can also be simulated using Anaplan Connect and a couple simple scripts and a simple module within your model. The first step is creating a small module in your model…
Changing date formats while importing into modules
I am building intermediate module. While importing data into Rep Setup module the Start Date and End Date are formatted as DD/MM/YYYY instead of MM/DD/YYYY. How to change this? I observed that in excel it is in MM/DD/YYYY format and there is no option to change format in Line Items formatting or while importing
Using Python results in Anaplan
Hi All, We are trying to build a model which would contain forecasting results flowing from Python. Please direct me to the best learning material from where I can work on this integration of Python / R with Anaplan Thanks and regards, Aishwarya
How to Create 'Export a Dashboard as PDF' and publish it to dashboard?
Hi, We have an option 'Export Dashboard as PDF' on the dashboard. Based on this option I am able to create a PDF. When I go the list of actions I do not see an action in the exports that is created for this. Basically I want to place that action on the dashboard. So that in one click I will be able to generate a PDF.…
How to create a Java Key Store (JKS)
Please note that Keytool is a java application and you will need to confirm that is installed on your machine. If not you will need to install a java version that has keytool, either jre or jdk. Once you have confirmed that a jdk is installed, please go to the search bar and type in – cmd. This will bring up the command…
Introduction to model building UX Dashboard Not Populating with Data
Hi, I'm working on the UX section of the introduction to modeling, and I cannot get the headcount module to populate with data when it's on the dashboard. Interestingly, there's data in the module itself and when I publish other modules to the dashboard they also show data. What could I be doing wrong? Thanks for your help…
Migrate Anaplan connect from 1.3.3.3 to Anaplan connect 1.4.
Hello, I would like to migrate to Anaplan connect using CA certificate. In version 1.3.3.3 there is one jar file only. I used command to execute jar file: java -jar "anaplan-connect-1-3-3-3.jar" -...commands In version 1.4. there are two files: when I execute file anaplan-connect-1.4.1.jar java -jar…
Anaplan API v2.0 - notes from setting it up
I have compiled this information as I have been working to connect to Anaplan via its API. I have chosen not to use Hyperconnect or Anaplan Connect. WHY you might ask? 1.) Hyperconnect: Our IT team will not support Hyper connect. 2.) Anaplan Connect: It is limited in scheduling and error outputs, and users have to know…
Updating an Anaplan Connect script
My data hub currently updates an Account Property module nightly with 5 attributes. I am looking to bring in two more that I can then send to my goal setting model. When I go to the Action to edit it, I get an error that the file no longer exists. I've made two columns in the Properties Module that match exactly to the…
Ability to restrict user accounts access to API
Our understanding is that anyone with a user account that has authorization to a particular action can execute that action via the API. This is concerning because we do not want users to run actions via the API, without consulting with the team in charge of Anaplan and defining together the integration strategy. Therefore,…
Anaplan API v2.0 - customer experience and documentation
Over the past couple of months i have been on a mission to update our Anaplan API version from 1.3 to 2.0. **PLEASE NOTE that i am a novice when using certificates and I read a lot online in different forums to understand more about CA certificates and the different formats they can take.** I worked internally with the…

Data Integration

Discussion List