Importing and Exporting Data

Snapshot Current System time function
Currently there is no current date/time function in Anaplan. After talking with developer from engineering group, we understand that one of the challenges to implement this is that Anaplan is "moment of time" system, if you have a formula reference Current time, then it would be only true for that moment, what happen if…
Duplicate entries - Module to module import
Hi, While carrying out a module to module import, if we do not import zeroes first in the target module, the values tend to sometimes double up if we execute the action twice (even after selecting the "Clear target prior to import" option while creating the action) but sometimes they reflect correctly even after executing…
Level2 Sprint3 Import DAT04 Distribution Center Parameters from Datahub
As I had issue loading data from Datahub, I wanted to do a copy paste so as to go on (not a prefect process i acknoledge) but when I want to paste data in the DAT04 distribution center parameters module (in the Suppplychain) I got an error message. It seems the module is on read only. I checked the parameter and as I am on…
Help "Add app.anaplan.com to your allow-list"
Hello Community! In the PDF Anaplan_Connect_User_Guide_v3.0.0.pdf , I'm trying to follow the step "Prerequisites, Firewall and Proxy Access", but I don't have a clue how to do it. May I have your help? Thanks in advance 1_ Add api.anaplan.com to your ‘allow-list’. 2_ Add auth.anaplan.com in your firewall and any proxies…
Level 2 Sprint 1 - 1.5.6.2 Import Data into Historic Volumes Module
Hi Anaplan Masters, I am unable to understand what is wrong in my selection. I tried with other mappings also knowingly that are not correct . attached is the mapping which i consider that is correct but unfortunately I am wrong bcz it shows the error after import. Request you to please help me for this. Regards Abhishek…
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.

Importing and Exporting Data

Discussion List