Data Integration

Cloudwork Query
We have to integrate process in cloudwork with below condition. 1.User select source data and Target data in module have user dimension. 2.Based on user selection run process to load data for source to target for each user. 3.Integration job should run process as many time users have selected source and Target. How to…
JSON as Import File Format
With the JSON format being the pervasive format for API data interchange it would be excellent if Data Import actions could use this format of file as a data source.
Excel Add-in Cannot access view
Good afternoon, I have recently downloaded the Anaplan Excel Add-in. I would like to create a view based on my 'development model' (we are using ALM), in order to be able to test the add in. When trying to add a saved view of a module (any module) , the add in shows me the following error: New Connection - Cannot access…
Action error only for non administrator users
Good morning, everyone. I have an issue. When I import data from one module to another, anaplan returns an error for non workspace administrator users. The error is:"You are not authorised to update this entity". While the action works for workspace administrator users. Maybe it is because of selective access used in the…
Adding a new list of existing model
Hi All, I am adding a new list (dimension) to my existing model. I am able to pull in the actual data from the source system by the new list easily. However I am not sure whats the best way to go about integrating the new list for the forecast planning. Currently - in my forecast planning module, my current forecast data…
Help Inform the future of Anaplan's APIs
Please take this short (less than 5-minute) survey to help inform the future of Anaplan's APIs.
Issue when importing from one module to another
Hi, I have an issue when importing data from one module to another, and the scenario is the following: I have a source module with "Projects" as dimension, and a target module, also with "Projects" as dimensions. The source module is a "calculator", where you can enter values and factors, which then calculates the final…
Anaplan Connect - SFTP
Hello, Just a quick question, does Anaplan Connect support SFTP server or only FTP server? Thanks, Ana
Effective Line Items rename during Fiscal Year changes
Hello , For Every Fiscal year development, we used to copy the models and rename the line items in the modules / dashboards from FY21 to FY22 etc. Later it was discussed with the user and renamed CY, CY-1, CY-2 (CY = Current Year), but the users are getting confused with these CY terms. Have anyone tried a different format…
There has to be a better way. Any ideas?
Hello, While on a rebuilding project with a client, I am ready to delete some modules. Problem is the line items in those modules are used in Formulas and are connected to downstream modules. I know I can reference the specific references in the Blueprint view, and scrolling over to see the Referenced By column. However,…
Excel Add-in Multiple View
Is it possible to publish multiple modules to one workbook in excel using excel add-in? I have a client that needs a dashboard (containing views from multiple modules) to be exported to excel that needs a specific formatting for shareholder's reporting. As far as I can see there's only one connection to a module per tab.…
Import into List - duplicates in key
Hi I want to import a customer forecast into a module. The customer forecast is Key, Product, Location, Date, Qty My end module will have a key dimension which is the Product/Location and dimension time, with a value of qty. So part of the import process is to create the key List. If I import into the key list from the…
GUIDE: February 2021 Release | Time Stamp on Actions
Community, Just a quick heads up. Every time you run an action you will now see the timestamp on the action tab. Awesome! Here's an example of a manual action being run. I tested it on automated actions too and it works great. Thank you Anaplan - huge win!
Anaplan CloudWorks API and Azure Logic Apps
* Use case: event-based triggering * Building a Logic App * Technical flow * Special focus * Conclusion You’ve already had a flavor of using Logic Apps with Anaplan API in this article, thanks to my colleague Sean Culligan. In this post, we will do something slightly different by using Anaplan CloudWorks API with the…
Add API functionality to list the line items shown in a Saved View
I would like to see a new API call or an update to the existing view metadata call, that lists which line items are "shown" in a saved view. The only way to get this information now is to read the view and parse the header line. When using the API to build an integration, pulling the metadata of an object before pulling…
Anaplan Hyper Connect Error
Hello Team, When we use Hyper Connect for Anaplan integration, we are frequently getting following Error and unable to figure root cause for the same. [ERROR] Write Failed. Internal Error: Adapter Write Returned Exception: com.anaplan.adapter.anaplanv2.metadata.adapter.service.exception.AnaplanServiceException: IOException…
Import from a module to the same module
Hello, I'm coming to you because I have a problem with a customer that I have never encountered before. I am trying to import data from a saved view of a module to this same module. The saved view uses a filter that allows me to bring the data from an entity X to an entity Y that is selected at each import. The action…
How to import data in accordance to 3 different identifiers for a data set
Hi, I'm trying to load a data set into Anaplan that has three different identifiers for the data set. The three identifiers make sure the data set does not have duplicates. The three identifiers in the data set are contract_id, Process Entered Data, and date_applied. At first I created List for all theses identifiers and…
Display list items with non-zero values for sub-list creation
How would you go about creating a Module that looks in other Modules and finds every item in a list that has any non-zero values entered in a given 12 month period? The idea would be to create a table that shows, for a given group of lists, all combinations of those list items that have at least one non-zero value in the…
Time Range and Line item Period Allocation
HI All, I have a question since my mind has gone blank, I hope someone can help. In my current model, i have imported data for a series of journeys which start on a weekly basis for each transport number, within the journey there are a series of stops for loading and then discharging stock. Pages: Time Range Rows: Journey…
Wdata Server File
Hi All, Does anyone know how we locate the Anaplan Server file to create a wdata chain to Anaplan? Thanks!
Error when importing a list where parent name = child name
Hi, I'm facing the error "New property combination found but name or code already exists" when importing a list where the parent name is equal to the child name, but with different codes. I've attached an example using a hypothetical Region->Country-> Location sharing the same names within all levels and the error…
Activity 6 Level 1
Hello All! I can't seem to do this for the life of me. I'm not good at creating formulas at all, and have no idea where to start in this particular anaplan venture. But when I try the following, i receive this:
Exam Module 4 - Help
Its 4 hours into this exam....very frustrated. Why are my target items greyed out, and how come I don't have a "role" to map the role to??? I'm not a developer....this exam truly is frustrating
importing into numbered list
I really don't understand why my E2 Employee# numbered list is displaying the wrong code. My source file (excel) when i download from the lesson is also not downloading the right. i have the code in 1,5,8, but it should be in 001,005,008. please can someone help. this is affecting my result every time i reference to this…
SYS08 - Import EXAM Activity 4
What am I doing wrong Anaplanners? lol why is Department greyed out?
Upgrading to Excel 4.4 and/or PowerPoint 1.8 and migrating to SS SAML
Just a note to any of you using the Office extensions for Excel and PowerPoint. If you are using any versions earlier than Excel 4.4 or PowerPoint 1.8 you should have received an email from our Ops team detailing the process for upgrading. This is to allow migration of your platform to be able to use SS SAML going forward.…
Exam Activity Builder 5
HI ALL - what is wrong with my code??????? trying to change to EMP03 etc etc...i've enclosed a shot of my SYS08 file too
10.2.4 importing activity
These mappings don't seem to want to work for me, in turn all my import is ignored. Any suggestions?

Data Integration

Discussion List