
Importing and Exporting Data
Importing and Exporting Data
Discussion List
- Good afternoon, We would like to use the Anaplan Excel add in to enable user to modify data from a view and push it back to Anaplan via Excel. Apparently the last available version to download is the …
- Hi team, I am receiving the below error when trying to perform a simple upload using Anaplan Connect & One Drive. This action will perform if I change the directory of Anaplan Connect & the batch file…
- Hi Guys Does anyone know if we can export module / line items ids using anaplan rest api? Using rest api i can export workspace /model/files IDs etc however i cant seems to find any unique keys for mo…
- Description Currnently, the columns headers seen in model history are dynamic and change depending on what is in the history. We would like the column headers to be consistent and not change depending…
- Hi team, I'm trying to use Anaplan connect to run a Import process but my script is incorrect. I attempted to modify my working import script per the instructions in the Anaplan Connect guide (pg 27) …
- Hi, I have a saved view in one Module in Finance Model and it has about 20 fields, one of which is Unique called 'NPD Ref Code' I am importing this view into a list in NPD Model, using 'NPD ref Code' …
- Hi, I need to do a lookup in my line items so that I can import the data into a module. I have a flat hierarchy factory list. I have 2 line items Inbound Qty and Lot Numbers. I've split them so that I…
Importing forecast numbers with forecast version and time scaled into a module without forecast vers
Hi All, I am trying to import forecast numbers from one module having forecast versions(list) and Anaplan time into a module only with time-scale. The idea is to have a page selector(forecast) in the …- Being an Anaplan Admin, I would like to be able to copy-paste text values into User Selective Access columns.Currently, Anaplan only accepts either Selective Access List ID or copy-paste directly from…
- Today I appeared for an interview, they asked me:- What is an Architecture of Anaplan? I wasn't able to reply. Someone please help me with this question.
- Hi All, I have a Dev model where I made various changes in the hierarchy (production data), re-shuffling lower levels and adding a couple of new ones. The data itself, however, stayed the same as I di…
- We have two models across which we need to import data by versions (Actual and forecast) and product category, as different categories are managed by different heads. The actual data needs to be impor…
- Hi, Please check the attachment for details. Regards,
- We have import actions to lists where we have and expect duplicates. We receive the ‘Another row has been processed with this key’ error because we are loading list items that already exist. Given the…
- Hi Team, I created a module dimensionalised by Time with Dynamic Cell Access set to Read for all periods except for Sep19 to Jun20. The setup was working as expected when tested manually. When I Impor…
- Hi. I have a question about importing. I want to import excel data(below) but the days are same. So I want to import value into Anaplan( -7+7=0 ) After imported, import completed successfully and the …
- It would be an absolute game changer to have the ability to export model 'Time' settings as a JSON object via the API. Subsequently, the ability to import a modified version of that JSON object to upd…
- I have 3 models in my workspace. 1 is a data hub while the other two are production models. I imported data from data hub model to one of the models and it was right. But when I imported the same from…
- Hi, I am currently doing the Level 2 training am just about to get started with the second user story in sprint 1. There it says that I should have a number of actions in my model already (actions tha…
- Hi, I'm trying to import date data. I failed importing as date format, so changed to text then succeeded.(below "week date") Next I'm thinking that changes to date format. So I tried using Mid functio…
- HI, I'm trying to import data(below 1) into module(below 2). And mapping are(below 3 4). But result was below 5. Please let me know if there is solution. Best, Regards,
- I want to have a saved export assigned to a button on the dashboard so that users can easily export the same view that they are looking at
- Hello! there are no files in Level 1 Model Building: Geography Hierarchy...only discription can you add them? Thanks
- Background: We have a module with 6 dimensions including time, we have to make a staging list from this module at combination level to store the previous data. For this we need only non-zeros combinat…
- Hi, Hi, I would like to ask if Anaplan has an option to export data in this format? The client requirement is that we can export data in this format so they can load it to another system. I have tried…
- Hi. When I import data and map. I have to unify the time format(like below) or not?(there are Y-M-D and D-M-Y)
- I'm trying to use the new JDBC export in Anaplan Connect 1.4.2, but I get the error "Could not connect to the database. Retrying in x seconds." I'm using a connection string identical to what I use fo…
- Informatica connectors typically give you the choice between 2 types of runtime options: - one or more secured agent(s) that run(s) on a managed server - a hosted agent managed by Informatica that liv…
- Good afternoon all, Iv'e just downloaded the Excel Add in V3.2 . I have managed to create a tab based on the view on my module. The module has my numbered list 'expense' as dimension + several line it…
- Hi. I want to import duplicate data into list like below. When I imported, data which is second same data was rejected. How can I do this? projectA (parent)----employee1、employee2 (child) projectB----…