Importing and Exporting Data

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…
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…
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,…
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…
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…
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?
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?
import a column with alphanumeric into number formatted property
Hi , can you assist me in following , so i am loading a file with a column into a number formatted list property , in the csv file along with numbers some entries have text only while some entries have text along with number(as shown) , when i load this file in model , so all text lines are ignored , but somehow anaplan is…
Import from one version to another version using import
I need to import data from one version to another version - Forecast to calc version (Manual Version). This module has 4 pages - Total hierarchy, year, wave, version Total hierarchy - Total > 1st level > 2 nd level > program Version is fixed version - always to calc version Program - i want to map single program each time…
Extracting data from Anaplan with Qlik Sense
So you finally did it – you joined the Anaplan Community. So many possibilities just opened up in front of you when it comes to connected planning and finance, but what about analyzing and visualizing your data? Well, no need to worry about that because Qlik has that part covered. In today's article, we'll be talking…
MB Level 1 Lesson 11.3.4 Getting the Wrong Output
I am having an issue where only 1 cell does not match how my model is supposed to look like. It seems like "Utilities" (and subsequent line items that use utilities as part of its formula) is the only line item that is generating incorrect data. The first picture is of MY module, the second picture is what the module is…
Help with Lesson 8.5.3- Import Data into Volume Inputs Module
Please help. I've attached screenshots and don't know why I keep getting the time error message. Thanks.
Anaplan Connector for PowerBI
Hi, I have a query on Anaplan Connector for PowerBI. We are able to use the Anaplan Connector for PowerBI with Workspace Admin user logins. But when we try using this with a normal user login, connector does not fetch any models from the workspace. Did anyone face this issue earlier? Thanks in advance for suggestions 🙂…
A primer on Anaplan integration using Azure Logic Apps
Introduction With the release of Anaplan Cloudworks, this flow may be better addressed via a blob storage connection in Cloudworks, or with a combination of a Cloudworks flow and a post request to the Cloudworks API. My colleague @christophe_keom published a guide covering this topic. In my case, I wanted my flows to run…
Updated Anaplan Java Client source code is now accessible via GitHub
As a true connected planning platform committed to integrating disparate sources of data from various tools, we’re excited to announce that the source code for Anaplan JAVA client has been updated on Anaplan's public GitHub repo! (https://github.com/anaplaninc/anaplan-java-client). This code is derived from Anaplan Connect…
Import data in to the module
When I import data in to a module, is it inserted into the underlying lists that are used as dimensions while creating the module? Do the lists and modules have own storage? Any documentation would be very helpful.
10.2.4 Activity: Import Data into Employee Drivers Module
Hello All I need help, i am having problem with mapping to the right dimension line item in 10.2.4 Activity: Import Data into Employee Drivers Module. Please tell me were i am making the mistake. After mapping to the line items in my dimension the table is not populating rather it is been ignored

Importing and Exporting Data

Discussion List