Importing and Exporting Data

Importing and Exporting Data 1.4.3
Hi May I know how do I get rid of the "time"?
Will the Order list action works for End users?
Hi, Just want some clarity on the order list action in Anaplan. If I include order list action in any of the process which is being used by the end users will that action works for end users? I heard that the order list action only works for the admin. Can somebody clarify on the same Attached screenshot for reference.
Excel Add-In - Labels
Hi, When we export data from Anaplan we have the ability to add 'Labels' to the export. These cannot be added to the view as it would be too complex, but are pulled down for the Export, which is really useful. If we connect using the Excel Add-In can this be replicated. We connect to the view but i cannot see the option to…
1.3.4.2 Update SYS06 Country Details Module
Hi, I am unable to understand what's wrong in my selection. Please support
3.3.5.1 Create Inventory Ordering Module
Hi, may i know how to i import TRA01 to DAT02? Anything part which i may have miss out? not sure why my data is 0
2.3.9 Activity: Historic Volumes to Baseline Forecast
I am having trouble with 2.3.9 Activity: Historic Volumes to Baseline Forecast and 2.3.9.1 Import data into DAT03 Historic Volumes module. For the first part, I'm unsure what needed to be done, if anything. Then when I tried too run process 9, this is the error message I received. Can anyone help me with what I am doing…
Import a time range
As a model builder, I would like to be able to Import settings into Time Ranges. This would enable me to make Time Ranges more sustainable by driving their settings from an Admin Screen with actions.
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, Can someone help me out with this issue of running 9 Import Data Hub:
Import Shipping Expenses into OTH01 Module
I don't understand why we added the code line item to INV05 module. I deleted that line item and I was able to complete the import process without a problem (I changed the time format to MMM YY). However, I am getting errors in the presence of the code line item. I got the error "Invalid date or timescale identifier". When…
API call to determine if a model is currently busy
As a data integration owner, I want to be able to check if a model is locked/busy running a process before I initiate a new process, so that I can avoid running excessive processes and have smoother orchestration between my calls. I'll know this is successful when there is an API call when I can submit a model guid and get…
Anaplan Connect Export to remote server
Hello, I'm trying to run a script to export a file from Anaplan to a remote server. Here is the line: set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "myFile.csv" -execute -get "\\myRemoteServer\myFile.csv" But when i run it, it instead tries to find a repository called…
Special characters import problem with Java Spring Batch
Hello, I have a problem when importing data to Anaplan. All the connexions work well, from my database to Anaplan. But when trying to import data with special characters (like "é"), they will be messed up. My database is in UTF-8 and the Anaplan model is too. Do you guys have any idea to where this could come from ? Thanks…
circular reference issue
hi, I am facing the below circular reference issue. what can i do to calculate "carried interest"?
L2 Conclusion OTH01 import Shipping cost
I am not having any problem during the import process. The import was successful. The problem I am facing is after the import the data that are imported was not imported. I haven't received any errors or failures during the import. I am attaching the screenshots. I am stuck here. I don't know what is missing. Someone…
Refactor the action "Imports" tab
The action import tab should include: - all the info that is in the first tab the source ID ( especially the last execution date) - source object should be exploded into workspace/model/module/view fields - the data source ID should be available here as well - an export button, just like on the first tab - the ability the…
Regarding History Tracking in Anaplan
Hi, Since last few days, we have been encountering some unusual behavior in Anaplan. One particular line item got cleared from the production model. In another case , an import copied the data from all the line items mapped except one in particular, when we checked , all the mappings seemed fine. Even running the same…
How to add Functions to existing Import and Export buttons
Hello, I am asking for help to add a Time, Version and Department functions to an existing import and export button in a dashboard. Any help would be helpful. TY
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…
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…

Importing and Exporting Data

Discussion List