Importing and Exporting Data

More than one Numbered list import
Hi All, Please help to make me understand if I import the one numbered list in other numbered list using "CODE" in this case I can not see the parent of my current numbered list, so what should I do to see the data with parent hierarchy in more than one numbered list items. Regards, Vikas Jain
Is a source model mapping update needed after model name change?
Hey Everyone, I tested this, but want to be 100% sure before making the update. Can someone confirm that the Source Model mapping does not need to be updated if a model name is edited. I see that the existing Source Model's name does not change, but the imports appear to still be running correctly even though the name is…
Numbered List Import in Other Numbered List
**** All, Please guide me to upload numbered list as a list in other numbered list. I am trying to import using code like as given below but unable to import and getting error. Regards, Vikas Jain
Anaplan Connect - Export Process Script
Hi team, I have a Anaplan Connect script to export a process of 1 action (just for test purposes) but I cannot get it to work. Currently receiving the attached error. My script is below Thanks @echo off set AnaplanUser="email:PW" set WorkspaceId="8a81b09e6181d3600161b51408040171" set…
Import from a Staging Module to a numbered list
I am struggling with the following: I have a staging module, dimensioned by Users, where individual users can input some data (CostCode, Currency, Cost Type, Forecast Reference), and once completed, I want to run a process to create a new item in a numbered list (that holds the full set of approved transactions) and then…
How to create two or more import actions into the same module
Lets say i have a source file need to be imported into module. Few of the line items need to be cleared before import for all rows and few others need not. How can we create two import actions by keeping the same target module and same source file. One work around is splitting the module, but am i missing some other way?…
Data break down based on hierarchy
Hi, I'm wondering if there's a way of breaking data down from a top-level? The data file that I get is an import that comes in at level 2 in my hierarchy. I need to then take this data and show it applying some rules in a module uses my lowest level of data (l4). Thank You Hina 🙂
Module to Module Import
Hi , I have a module ,by versions ,Dimension is a number list . Line items - 1. line item 1> Data Type > List 2. line item 2 > Datatype > subset of list 3. line item 3 > Data Type > Subset of list 4. Other number formatted line item I want to import Budget data into forecast . Action is successful but "line item 2 and line…
Anaplan Integration with Amazon S3 using Informatica Cloud
Hello Team, We are currently trying to Integrate Anaplan with S3, Here Anaplan is the Source and we need to place files into the S3 Bucket. The metadata tables have been created in the relevant S3 bucket. The requirement is to have the CSV files containing the data from Anaplan and a Manifest file to be placed into the S3…
ALM Cell value
If a cell value is accidentally changed in Production. How can we revert back to the old cell value?
Model to Model data import from Module and ALM
Hi Experts Building a functionality to deploy to production which requires an automated Model - to - Model module data import through custom scheduling. We use ALM. Both modules, i.e, the source module in one model and the destination module in the other model are being built in DEV. Upon deployment to production, what…
Data Import into a Module using a numbered list
Hi, I would like to understand how an import action works for a mapping on a numbered list. I have an import action set up between 2 modules in 2 different models. Both the modules use the same numbered list. Since the mapping for the numbered list is on name or code the system ends up mapping on the name(Unique number Id)…
File to Module Import Doubling Number
Hey Anaplan Community, I am having difficulty achieving the desired result with a file import to a list and then module. I wanted to see what workarounds have been used. Below is a simplified example of what the file structure looks like. File: Style Manufacturing Pieces 12345 2 12345 2 12346 3 12346 3 The information is…
Your help is needed! Excel and PowerPoint add-ins: best practices
Hi all, I am reaching out to the Community to get your input about best practices for the Excel and PowerPoint add-ins. Please share your tips and tricks to make the use of the add-ins as efficient as possible! The suggested themes are: * Governance of the add-in: upgrade process, version control, COE management of the…
Comparing two modules
Hi - Because of a unique use case, we had to create two modules with similar information except a couple of columns. I want to compare if the data is correct in the new model. Can you please suggest on how I can do this ? Sunl
ALM and History changes
I accidentally make an error and realize it instantly. So alter it back to the previous one. My history gets saved. Now I archive the model and later change it to standard one. Will Tenant Admin still be able to pull the history?
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
Level II Sprint III Model
Please suggest a Link from where I can download the FP&A Model.
History information seeking
Hi Friends, Any lights on how is ID values generated? It is sequential but why it starts with 200? I hope it's not year.
Anaplan Excel Add-In 3.3 (Read/Write Query)
Hi all, I understand the ability to create a read/write connection with Anaplan was reintroduced in v3.3 of the Excel add-in. Where does this feature reside? I am using v3.3.44.0 and below is a screenshot of my toolbar; I have full access and workspace admin permissions, I also have write access enabled on the version and…
Limitations Of List Members Of General LIst.
How many list members can we insert in a list at a time.
File Missing in Level 2 Sprint 3
Hi, Is there a .csv file for the Shipping Methods and Time taken for delivery? If not then it is not mentioned how should I populate it? Regards,
Add Filters for Data Import
I have Module A form where I want to import Data to Module B. I can't touch Module A, so I can't use Export function from Module A. As shown in the pictures, I want a filter Import of a particular country. I have worked on creating saved views and exporting but not sure whether same can be for Import as well. Any inputs…
Add a new Data Hub
What are best practices when is needed to create a new Data Hub due to workspace space limitation to 130GB? I have already built the Data Hub which contains historic data and data validation processes. I still need to load further years. The only option I have, without deleting the data already loaded is to create a new…
Safety stock import filling missing
I find the safety stock import .csv file is not uploaded in the Sprint. The image I uploaded is an old one shared in the community. Can someone please share the file or assist how can I download it?
How to import data without manual mapping for Numbered list?
Hi, I want to upload data into a module that has a numbered list as a dimension, as a result of this I have to manually map list elements manually to excel file rows Any technique for automatic data mapping of numbered list elements to excel rows? PFA Screenshots of my mappings for more clarifications:- 1. Source or Excel…
Issue with value addition
Hi Community, Can someone help me understand, why am I not able to fill in any values for Volume Line Items even manually.
SFDC Integration
What are the available ways to integrate SFDC with anaplan, How i can enable data flowing between these two systems?
Informatica doesn't find Anaplan Model as source/target model
Hi all, I'm trying to connect Salesforce and Anaplan via Informatica. I've setting up Salesforce and Anaplan add-in in informatica and 'test loging' works for both. When I am trying to create a new synchronisation task for an update, Informatica recognizes Salesforce. However for Anaplan, it seems that Informatica can't…
Selective push of line items through ALM
Hello fellow Anaplaners, I was wondering if it would be possible to selectively push line items/modules while synching models through ALM? The idea is - I would like to setup a master model and then migrate only the required functionalities/calculations to two different target models. With this setup, I will have to design…

Importing and Exporting Data

Discussion List