Importing and Exporting Data

ALM 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 didn't delete anything. I need to transfer the changes to the Prod model now, and I want the data in Prod to be re-allocated…
Best Practice suggestions to reduce published import action buttons ??
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 imported by month, and forecast data needs to be imported once. We are planning to provide data Import to these head users…
Anaplan Connect 1.4.2
Hi, Please check the attachment for details. Regards,
Option to ignore duplicates during import action
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 way we are processing the data, this error is unavoidable. Our automation saves all the error logs and due to these…
Dynamic Cell Access - Import
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 Imported data from another Model with the same time dimension the data was uploaded into the Read access periods & the write…
importing the same day's data
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 value became 0 as I wished. In Anaplan, the value was 0 because it was conducted (-7+7=0)?? If so, even if I have the same…
Model 'Time' settings import / export via API as a JSON object
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 update the model calendar via the API would go hand-in-hand. This would allow for automation of moving the 'Current Period'…
Import Issue
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 data hub model to the other model, it is changing the data even when the mapping has no issue. Can someone please help with…
Level 2 - Missing actions
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 that came with the model), but I don't. See screenshots below. I am essentially missing two import (highlighted in yellow in…
about date format
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 function and Date function, but the value wasn't filled with cell. What should I do or is there good way to import date?? Best…
import data into module
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,
Export from Dashboard based on Current View (in synch rows)
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
Level 1 Model Building: Geography Hierarchy
Hello! there are no files in Level 1 Model Building: Geography Hierarchy...only discription can you add them? Thanks
Creating Combination list from Module with 6 Dimension
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 combinations to be created in the staging list. Limitations: Each line item in the existing module is taking ~10-12 GB space…
Export Inquiry
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 the export definition txt file and it is not the same. Appreciate the assistance Regards,
importing data about time
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)
Anaplan Connect 1.4.2 JDBC export: Could not connect to the database
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 for JDBC imports, so I know that's solid. Additionally, I am using integrated security, and I do have sqljdbc_auth.dll in the…
Informatica Cloud: using Hosted Agent with Anaplan connector
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 lives in the cloud The feedback I got from Anaplan was that the Informatica Anaplan connector is only compatible with the…
Insert item to dimension via Excel Add in
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 items. The objective of using the Excel Add in would be to enable the user to manage their expense as well as adding new ones.…
importing duplicate data into list
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----employee1、employee3
FIND MULTIPLE DELIMITERS
I am trying to take a 3 part Unique ID with delimiters and separate it at the delimiters. I can achieve this for the first 2, but not the last part. ex: 123-0542-236541 LEFT(NAME(ITEM(LIST)), Delimiter in Item Name - 1) = 123 RIGHT(NAME(ITEM(LIST)), Delimiter in Item Name) = 0542 Delimiter in Item Name = FIND("-", Item…
Import file with several sheets
Hi, I have a module where I have a number of line items and two lists as dimension. One as rows and one as page selector. I want to build a function to export all data from that module, edit it in excel and then import the same file again, and hence get the values updated in Anaplan. Now to the issue: When the file is…
Import to list with default value
Hi, I have an excel file that needs to be imported into Anaplan and update a list. However, I want all the new list-items to be part of a subset, which I want to set at the same time as I import the list. I do not however have any column in my import file to use for setting the subset (that is, a column that says TRUE to…
Add Search Field
Add a search field when setting up an import source from another Anaplan model. Currently, we have to scroll to look for the desired list, module, or saved view.
File Import Error: No Value Loader exists for this type: NONE
Hi Everyone, I am facing a issue which is: My source is: .csv file Target is: Module (Importing into 8 line items) Line Items: Format Lift% Number Volume Status List formatted Activity Type List formatted Activity Cost Number Display Type Text Display Cost Number $/unit Number Select Scenario Boolean The file format &…
Automatic Mapping - Not Working
The names are not getting mapped automatically, is there an order issue or is there anything else?
Hierarchical structures from a customer provided list
we all understand the traditional way of building a hierarchy normally following a top down approach. We sit with a challenge requiring that the hierarchy needed to build up from the bottom up using a lowest level reference code. As per the attached picture. Each lowest level will have a specific code identifying where it…
Importing boolean from Informatica for List subset
I am trying to populate a subset using an import triggered through Informatica. Here is how the import is set up in Anaplan ("SS PortCo in Hierarchy" is the list subset): Screenshot 1 Now from Informatica standpoint, every record captured by the query needs to be added to the subset so I am using a hard coded expression…
How to convert Date to 445 calendar week
Hi All, The requirement from the client is that they will upload the sales history for an SKU by date into Anaplan. Hence there will be 3 columns SKU, Date, Quantity. The model calendar is set as 445 calendar and the end of fiscal year is last Sunday. The problem is I want to convert this flat upload so that I can…
Hierarchy change
Hi All, Wanted to ask for a best solution of this question if possible. I have a process hierarchy which consists of 3 levels, and I need to extend it by adding 2 more levels between levels 1 and 2 (so whatever is on Level 3 now should go to level 5, and whatever is on Level 2 will be transferred to Level 4). What is the…

Importing and Exporting Data

Discussion List