-
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…
-
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…
-
Fetching export ID directly while Integrating Anaplan with MuleSoft
Hi All, I was trying to integrate Anaplan with MuleSoft and followed all the steps provided as per the Integration guideline. but we have an issue while trying to find the export ID(to be provided in mule soft) for a particular export action created in the Model. Instead of querying the mentioned model id, the API is…
-
Counting Multiple Countries Per Region
I have a module that needs to tell me whether a customer is present in more than one country in each region. For example, Customer A is only present in United States under AM region. This means that it is not an inter-region customer in AM. But in EU region, it is present in United Kingdom and Italy, so it is an…
-
Anaplan Connect Batch Script Error: "Anaplan API: HTTP status 424: Failed Dependency"
Hi, we are currently on anaplan-connect-1-3-3-5 and have previously successfully using the same batch script to upload files. This error just popped up today and not sure what went wrong.
-
API Documentation
I was checking for anaplan rest api but the link which is provided at anaplan website takes me to a page where nothing is available! https://anaplanbulkapi20.docs.apiary.io/# This is the link where it is redirecting is there any other possible way to check the api documentation??
-
Deleting Missing Transaction Data
I have Transaction data import set up in Data Hub. The data has no ID so I use a numbered list to create a list (Transactions #) of unique ID:s by combining a few properties. I then load all of the properties into a details module with the Transactions #- list as a dimension. Data is loaded every night and it consists of…
-
End-user file import from a dashboard
Hi all, understand that is a new function release by Anaplan this year https://community.anaplan.com/anapedia/data-integration/import/end-user-file-import-from-a-dashboard. However I don't seem to get it working when i create a process button. The issue I faced is that the process did not prompt me to select the file for…
-
Import Anaplan Connect
Hi, i had problem about import data to anaplan connect, i have file excel and modules using time periode, when im import using anaplan connect the data automatically enters without (mapping)selecting time (ex jan/feb/mar). My question is, how to (mapping)select time on anaplan connect ?
-
Anaplan Connect direct to SQL Server
In a batch file for Anaplan Connect can you specify the export location to be a table in sql database rather than just an export to ascii or excel?
-
Data Import unsuccessfull
Hi Experts, I have 3 models, 1.Data Hub, 2.Dev, 3.Test model. I am changing my list item name in list(numbered list) in my data hub model and running the import action("ABC list from data hub) from Dev model to see the changed list item name is updated or not? and it is getting success, I am able to see the changes. Now, I…
-
Error in Importing
Hi, Can you please help in addressing the below issue ? While running an import from a List in a model to a List in another model am getting the error (it's identical List in both the models) Too many cells for RANK calculation: actual=10161774 maximum=10000000 Any guidance / help will be great thank you venky
-
Getting Connected with Anaplan Connect
How Connected Anaplan with other Database ?
-
Time Mapping Upload
Hi, I am attempting to upload a CSV file to a Module and the Time dimension (Months) is in the column headers but Anaplan will not recognise the Months no matter how I enter them (e.g. 01/01/19, Jan-19, 2019-01) & it is requiring me to manually map them Below are 2 screenshots of what I am referring to. The 1st being my…
-
Loading data unsuccessful
Hello Experts, I have 3 models 1.Data Hub, 2.Dev & 3.Test, I have a normal list(not numbered list) in all the 3 models and I too have created the actions in respective models. my query is here below in step by step order. Step1: I have changed the list item name in the list from "ABC" to "XYZ" and ran the action in dev…
-
Invalida Date - Import from one model to another
Hi, Please see the details of my inquiry in the attachment Regards,
-
List of existing import/action errors
Good afternoon, For training purposes,I am looking for a list stating the main errors (and if possible the explanation & solution of those errors) that could occur in Anaplan when loading a file. Anyone has any idea where I could find that ? Thanks in advance, Sarah
-
Exporting internal link to Views
Hi, I want to understand if an export can be linked to a saved view so I did the following test: * Create a view and save it * Create an export just after based on that view * Delete that view * Run the export The export still works. I understand this means that an export is not linked to a visible named view, but to some…
-
Is Anaplan Async or Sync? Export task status
I am connecting to Anaplan API from AWS using Python. I am able to connect, run export etc. https://private-anon-9863bbf5c2-anaplan.apiary-mock.com/1/3/workspaces/workspaceID/models/modelID/processes/processId/tasks/taskId. I am getting the status of task as IN PROGRESS but expeting COMPLETE. I need some help putting how…
-
Anaplan Integration with Data Lake
Hi Team, I am looking on implementing a possible solution of Anaplan sending data to a Data lake and In bound from a different set of a data lake. This will give me more flexibility to send my plan figures to enterprise systems. Do we have any proved architecture on this or will Informatica connect will be able to help us…
-
Issue in mapping creation in dell Boomi tool using Anaplan action
Hello Team Can anyone help me to understand the Dell Boomi integration with Anaplan. I am trying to integrate Oracle Databse to Anaplan using Dell Boomi. When i try to create Mappings in Dell boomi from Database to anaplan by using MAP . I am able to retrive columns from Databse but when i try to select anaplan action in…
-
Ana-plan Connect to SQL Server
Hi Team, Am trying to create a connection between Anaplan to SQL server to import the as list from MS Sql table to Anaplan. Please find the below script i am using. @echo off set AnaplanUser= roshin.rasheed@xxxx.com:password set WorkspaceId= 123434343 set ModelID= sdsfsdsdsdsds set Operation= -file "Source System from…
