Data Integration

An action to export Dashboard as PDF
I exported a dashboard in PDF format using the Export option. It will be really helpful if this an action that can be published to the dashboard. So that business users will not have to go through all settings and all.
Efficient way of exporting large number values from Anaplan
I have a line item which contains number values, usually 13 to 15 digits long. While exporting these number values data is converted into scientific format. For example in Anaplan grid, we can see number as 1,522,731,938,281.0 . Whereas, in the export the same number gets converted into 1.522731938281E12.(Scientific…
New List creation
Hi Friends, I have an existing module with Order ID. I want to create new List as follows.
Understanding the APIs of Anaplan particulary using the Upload API from http client
I am looking to integrate Oracle SOA with Anaplan, specifically my requirement is to feed data from a Oracle SOA BPEL to Anaplan. I have gone through the Anaplan API documentation and looking to use Upload and Import APIs.Approach I am planning to follow is write the content from Oracle SOA to a file and then upload that…
transform data's timescale
if Module A is in weekly time scale, Module B is in yearly time scale. What formula should I use to pull a line item from Module B to module A? Thank you.
If I don't mark a list as Production List, what will happen? Since I don't modify my list often.
As I read, if I mark a list as Production List. I can make changes to it, even in Deployed mode. What type of changes? Properties, Subsets, Code?
Importing data Module-to Module
I’m trying to put Lookup and SUM function but every time it says ‘The formula is invalid’ and it doesn’t exactly tell what is the problem. I want to import data in Module F from Module A and Module B. I tried to use below formula for importing Module A data to Module F as they both have same dimension so i thought it would…
How do edit an action mapping
If I try to click edit on the mapping of an action, it just says the following error, but i am unable to change the mapping. Manage Import Data SourcesThe uploaded file is no longer available; please upload the file again - another question. If i create a new action and rename it the same as my previous action, does…
Using Mulesoft for integration
Hi all, Question if anybody uses Mulesoft for integration with Anaplan. Is it possible to trigger Mulesoft action, that basically starts import ore export in Anaplan with https:// link? The reason is to have ability to start loading porcess directly from Anaplan dashboard
Excel Add-in: Ability to detect if columns have become unlinked via named ranges
As an end user It would be useful to be notified when a column becomes unlinked from Anaplan and is no longer being updated. Currently this can be done by searching what is contained in the named range “AnaplanColHeader“. Note: LI1 has become unlinked and will not update on refresh. This could be done via a pop up that…
Formulas Text
I want to write Sweet for all taste. Please tell me, how can I do it?
Help Post ---- Import Parent Level data
Dear Friends, I am in urgent need, to find the Parent level total in a different module. But I am unable to do so. SUM, LOOKUP didn't work mentioning issues. Kindly help me, I am in really dire need.
Hierachy Import
I have lists with 6 levels of hierarchy. I want to pull data for level 3 from the highlighted module. Is it possible not by using parent function but by simple import to pull the data. What I was thinking, I pull the data for L1 and then use parent and item function. In that case, friends suggest me, what will be the…
ALM synchronization
Does ALM synchronize Dev Data with Production Data and vice-versa? Even though they are in different environment? Please respond friends, as I am new to this.
Create non-numbered composite hierarchy with List Import where parents and children have same names
Hi Anaplanners, I am struggling with creating a non-numbered list composite hierarchy through List Import. As described in the attached file, a list I am trying to create include a child whose parent has the same name. I could create such a list manually but it failed when I try to create this list via List import from the…
Production List
Please tell me friends, if I mark a list as a Production List, then will it be visible to end-user? And how can the end-user update that list? By clicking insert as we do from development? Or we have to create action button for this?
Fix Import Dialogue on Ultra Wide Resolutions
Please can the import dialogue be fixed on ultra wide resolutions? Everytime I import, I have to resize my window so that I can see all of the dialogue options, screenshot attached. Typically the Run Import and OK buttons are missing. Thanks!
Selective Import
In Anaplan we have. Now we want to maintain monthly data appending. This works fine. Next I find the old actual data for some records was incorrectly entered. I update it in the Hub but it doesn't get reflected in automatic process, as it takes the old values. I don't want to select the other option as my old data might…
Retrieve information from subsidiary view to use in a Boolean
Hi, I need to retrieve information from a subsidiary view and use in logic in another Boolean formatted line item. I want to see which account is unassigned during a given point in time. I already had a subsidiary this by month. I needed to see it with a yearly time scale as well so I created the view below with time scale…
Anaplan error 404 when importing to Anaplan
Hello, I have error when importing data to Anaplan using new CA certificate and version 1.4.1. This command working in Anaplan connect 1.3.3.3 java -d64 -Xmx48m -Dhttps.proxyHost=XXX -Dhttps.proxyPort=8080 -jar "XXX\anaplan-connect-1-3-3-3.jar" -c "XXX\xxx.cer" -workspace "XXX" -model "XXX" -file "XXX.txt" -put "XXX.txt"…
Series of Action (Process)
Hi Friends, I want to know, I have 6 Modules. Mod1 data flows to Mod2----> Finally Mod6. Now can I create any Action to automate the full process?
Anaplan connector 1.4.3 not giving output
Hi Guys, We are upgrading the anaplan connector to v1.4.3. We are using a .net application to consume the connector and import data. We are having 80+ lists to be imported everyday and the .net program used to pick one by one and import the data to anaplan. Based on the output, we are considering the data is load…
Very urgent ---- Formula assistance needed
Module 1: I have a Transaction List and the Employees responsible for the Sales. Module 2: These are 3 types of Cars of different cities Commission percentage. Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.…
'Upload File Not Available' Errors / Default File Setting for Deployed Models
We have occasionally experienced failures in import actions (on deployed models) called via Anaplan Connect with the error ‘Upload file no longer available’. Our understanding is the default file should to be specified as ‘admin’ instead of ‘private’. This setting can’t be changed via API call, so we updated the mappings…
rename the filename of a file before export
Hi Community, I have a module in which I created 2 saved views in order to have 2 different export actions (1 for region A and 1 for region B) . I saved the export definition and used Export name: forecast_A for the first export and forecast_B for the second export. In the actions overview, I see those 2 different export…
Filtering Import
This is my Original Module. Now I want to create a New Module which will have only Orange Data. But I can't use Lookup, as I have restrictions of Formula Linking. Only thing I can do is Import. Is there any way to do it? Need your support.
Data Pulling into Target Module
Hi Friends, I can't populate directly from list but need to populate the values from Module 1. I was trying with LookUp but it throwing error mentioning 'List does not have a built-in top level'. Please help. I am learning on my own and none to ask assistance.
Dashboard for beginners
Hi Friends, I want to learn how to create a filter list item in a Dashboard. Such that if that list item is selected, automatically the associated modules displays only that values. Any link will be helpful.
Month Formula
Hi Friends, I have a list of Fruits and the month that is sold. Now someone has entered the month in TEXT format 1,2,3,..., 11,12. I want it to be Jan, Feb, Mar,...,Nov, Dec. Writing IF-ELSE is a tedious one. I was trying it in that way. Can you please highlight some easy way.
What is a Source Module?
Hi Friends, Please tell me, when do we need to build a Source Module?

Data Integration

Discussion List