Data Integration

Importing from a module into Users
I am trying to import from a module into users. There is one field in the module for a particular user that we are trying to bring in multiple values in the list selected. We are using the "text" format to enter the two different values in that list because we can't select multiple values in a list when it is in the "list"…
Issue: Combine 2 columns
Hello all, I am fairly new to Anaplan and I would need help with one task. I have 2 columns and I would need to create additional 3rd column, where the first 2 are combined. The combination should work as follows: look for a string in one column, if you find the string, assign the string, if its blank assign the value from…
Time settings change
Dear Friends, If I update time settings (Month & Year) in Dev and then using ALM sync with Test & Prod. Will it get updated in Test & Prod?
How Can I Automatically Identify and Delete Childless Hierarchy Items?
Hello, I have a constantly shifting hierarchy in place which consists of 8 levels, level 1 (top) through level 8 (bottom). Within this hierarchy it's necessary to delete members of L7 when they have no L8 members which roll up to them. This scenario plays out regularly as L8 members are often realigned to roll up under…
Import in a list. Fileds mapping - need empty mapping selector in a drop down
Hello I've noticed one thing which is not native for many beginner anaplanners. While we set-up import to the numbered list and we should not have any mapping in the name field (as we choose to use a code as a default way to identify items). But quite often it is pre-populated and in a drop-down there is no option for a…
Vidéo - Les différentes méthodes d'intégration de vos données dans Anaplan
Bonjour, Anaplan en tant que plateforme permet de rassembler vos données issues de sources hétérogènes. Cette vidéo est une introduction (non exhaustive), des méthodes possibles pour intégrer vos données dans Anaplan : * Intégration manuelle via un board, * Anaplan Connect, * Rest API, * ETL, * Cloudworks.…
Size of module and models using APIs
Hi All, I need a way to automate capturing the cell size of the modules and overall size of my models. Right now, for modules, I have to capture it one by one in the model itself, but that is not feasible as an administrator considering we have several models and thousands of modules. Is there a way, using APIs or…
Docusign not reading Anaplan fields
Hi , I am trying to integrate anaplan with Docusign for my client . Letter is sent but without data in tags . I am trying with only one tag ,doing mapping correctly . When I tried the same in my own company's workspace ,it worked well that to with free trial docusign account but same set up not working in clients workspace…
Ability to use the CREATE action in the NUX
Currently the ability to create items directly in a list (using the create function) is only in the classic UX. Can we migrate this over to the NUX?
Roster management over Time and Version
Hello, Our implementation includes personnel expense budgeting at the individual level, and to create the roster of employees we use a list. We have a need to compare budgets year over year, ie FY19 vs FY20, and to do this we need to have different members in the list for different years, as well as a current roster. One…
*Urgent* Add user in Production
Hi Community Friends, My Dev model is in Standard mode and Prod model is in Deployed mode. I have added an user in Dev but unable to add in similar way in Prod as it is Deployed. So do I need to follow ALM process for adding the user in Prod?
export action
Hi, We faced an issue with export job. Captured some error in file like " Error parsing key for this row; no values: 1 ". Could you please help me what this error meaning? and why this came? "Error parsing key for this row; no values: 1 " Thankyou
Anaplan clients import options - cost?
Hi, I'm wondering about the 3 more advanced import options that Anaplan have: Anaplan Connect, ETL Connectors and Rest API. I take it that Anaplan Connect comes along with any Anaplan license so would be no extra cost for an existing client? And what about ETL Connectors and the Rest API - disregarding what the client has…
All actions / imports / exports within a Process
Hi All, I am trying to build a data lineage from our source to Data hub model and the spoke models. In order to do so, I need the metadata information from i. the Processes , i.e. all the actions/imports/Exports that it runs ii. The models and modules that individual import processes are pointing to iii. The file names…
Data Import for DATA01 LEVEL 1
Here are my screenshots. I followed the instructions but my result looks like this, see first screenshot. What am I doing wrong? Please help outputreport says no failure version has forecastThe set up
How to extract user login details
Hi All, Can you please me , how to extract the user login details from Anaplan
Mass upload into Deployed Model
I'm in need to change the user-editable values en masse in a module in a model that's in Deployed mode. The module is dimensionalized by a production list, and the two lines in question are simply user-input quantities. I've created the import action in Dev and rolled that into Production so I can run the same action, and…
copy data from Budget to Forecast
Hello togehter, is there a function to copy whole Budget data to Forecast Scenario (including Global inputs and staff set up)? Thanks for your answer, Corinna
ALM suggestion with DEV-TEST-PROD Sync
I have made some changes in the model in Dev (it is in Standard Mode)... Created Rev Tag... My Prod model is Deployed mode with Rev Tag... So I will compare and sync Dev (Standard mode) with Prod (Deployed mode)... Now my Test Model is Archived due to space issue... So to sync, I have to Archive Dev now... And they sync…
Password policy for basic Authentication without Certificate with API 2.0
Hi All, We are trying API connector with basic authentication without certificate . And as the account we are using to connect to Anaplan through API, has been expired as its been 90 days and asking for password reset . So do we need to change the password every 90 days going forward ? Is there a way we can have this as…
Search option to find the module name while importing
Hello, It would be great to have 'Search option' section, so we can easily search for required module while importing. This helps to quickly search the required module from the list as it saves lot of time scrolling. Thank you.
Informatica connection issue to Anaplan API
Has anyone encountered any issues connecting to Anaplan through Informatica as of this morning around 1am PST (12/10/2020)? Our client is experiencing integration issues across their connections through Informatica, and these issues all began when Anaplan experienced a systemwide outage this morning.
Date coming with timestamp in Module
Hi, I have uploading data with date (example - 12/11/2020) but when i run my process and in module its showing with timestamp example 12/11/2020 00:00:00. Any Ideas why? Thanks, Santosh Biradar
How to integrate Machine Learning Model written in python with Anaplan modules
Hi Ana planners I was curious to know how can we use/integrate a ML model in python notebook/script/pickle file within Anaplan modules? Also if its not possible to integrate inside Anaplan modules then can some one suggest the structure of the process when the ML model is deployed in a cloud environment and the results…
Anaplan connect: error in upload
Hi, Currently we are working on automating the process uploads with Anaplan connect. An error occurs for data transfer between 2 models in Anaplan. If the process is ran via the scripts, I get the following error: Import into module failed: The column headers in the file you are attempting to import do not match the import…
Provide a way to determine usage of processes,actions,imports,exports runs
Provide a way to extract history of processes/actions/imports/exports runs to determine its usage and help with clean up efforts in the models.
Reset Continuous Serial Numbers using Rank formula from one Module to Another
Dear Experts, I basically want to Reset Serial Numbers in Ascending Order using Rank Formula from the last number (from one module) and start over with the next number (in another module), for example:- In the "ABC" Module, I used the Rank formula:- TEXT(RANK(1, ASCENDING, SEQUENTIAL, Country = Country ZBB.US)) which ended…
Copy Across data
Hi I have Costcenters list and user entering data for one cost center in a dashboard and user wants to copy same data to other cost center How to do give such option to user in dashboards? Thanks Tejaswini
Splitting of list elements from list into line items
Facing Issue Content Description We are facing a difficulty in splitting months from the list drop down in New Period(Quarter) into its corresponding M1, M2 …..M5 line items. STEP 1: We are selecting the length of the period from New Period(Quarter) line item say 3 months. STEP 2: After selecting the New Period(Quarter)…
Hints for a Successful Data Integration
Recently I took a webinar on Data Integration into Excel and found the hints there directly apply to Anaplan data integration. Nothing fancy...just my notes. Hope it can be used with you or your Clients. Hints for successful data integration into Anaplan: * Data format:* Text or csv * Insure all column headers are unique…

Data Integration

Discussion List