Importing and Exporting Data

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…
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.
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
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…
Anaplan Power BI Connector - One Tenant?
Hi Anaplanners. I'm really enjoying the new Power BI connector but I'm having trouble accessing all the tenants I have access to. For some reason only one shows up. Does anyone know why this might be? @MagaliP I know connectors is out of the extension universe but maybe you know someone I can work with? I'm using the Power…
Importing File No Error but Zero Created Cells
Hello Anaplan Community! I had an issue a few days ago where I imported a data file and everything looked good on importing, no errors were generated but no cells were actually created. When I checked the flat list, there was nothing imported into the list. The excel file was in CSV format and everything was properly…
Data Integration - cheat sheet / decision tree
Dear Anaplanners, I went through the various materials available on the topic of Data integration and completed the related courses. Nevertheless, with minimum practical experience in the field of data integration, I still feel a bit lost. What I am looking for is some kind of summary of plus and cons of the individual…
Publish Export Actions to UX without creating a Process button
At present we can publish all other actions to UX except for Export Actions, without creating a process button. It would be nice to publish the export action without having to create a process button. We could create process button only for those which needs to be grouped together. When we have siloed export process of one…
Support of cyrillics and possible other national symbols in Anaplan Connect
Not quite critical, but It would be nice if Anaplan connect scripts could support names of the tables/fields written in local languages for example using cyrillic symbols. Currently such names are being corrupted into ??? characters and cannot be found by the database. This makes us to create additional views and thus…
Level 1 model building Part 10: OTH01 Non employee expense module
Hi Team, I have done as instructed in the training and imported the data from a csv file to the module. All data gets imported but there is no mapping for the "Total" column in Source to target mapping, which seems to throw result as zero. PFA pictures for more clarity. Do I need to use a formula in total column or I am…
L1MB Part 8: Data Import for REV02
Hi, I have a successful data import (Volume Inputs.csv data) for REV02 Volume Inputs Module but I don't see any data inputs in my module (see screenshots). Can anyone guide me on what I did wrong? Thanks!
8.5.2 question volume input
Hi guys my view for Rev02 is different to the one in 8.5.2 how do i fix it please? is it supposed to look like this? Learning content My Content
Export de données
Bonjour, Savez vous s'il est possible d'associer une action d'export à une vue ? Exemple : j'ai créé une action d'export des résultats le mois dernier, donc avec comme sélection "Sep 20". En relançant mon export ce mois-ci, j'ai à nouveau "Sep 20" alors que j'aurais souhaité avoir "Oct 20". Pourriez vous m'aider s'il vous…
Importing into system module
Hi Team, I am trying to Import data into SYS08 Employee Details as part of my Level 1 model builder training program, but while importing i am confused as in what to fill in the time dimension. 1) Since they are flat modules so time dimension should not come, so is that my mistake? do i need to remove time dimension from…
Level 1 - Lesson 7.2.1 and Lesson 7.2.3
Hi I am stuck trying to import data from the Product csv file and the Employee csv file. I think I am doing the mapping wrong. I tried all different combinations but failed. I have attached the screenshots of the messages I have been getting. I would appreciate some help. I can't see any imported data in the modules.…
Level 1 Model Building
I'm having problems on section 7 importing the file for SYS006. I believe my issue is with the mapping of the Time. I'm also having issues with SYS08 on seeing the data after importing the data. It is showing all 111 records did update with no errors. Any help would be greatly appreciated! Thanks! Terri
Import Saved view into list
Hi All - I am new to Anaplan and sure missing something obvious in implementing this use case. Could you please point me what I am doing wrong Use case: Create a button in dashboard for admins to add new Regions. As soon as a new region is added it should be saved in a list Here is what I did 1. Created a module (INP01…
Name an action on set up
I would like the ability to, when setting up an action initially, give that action a name that would be used in the Actions section of the model settings library and indicate if it is recurring or single use. Then by running that action it would either be kept with the name given - recurring - or be cleared from the…
Incremental data export to interface (informatica)
Hi All - I am looking for design suggestions to below the following use case. Please guide me . Thanks 1. We have a module for employee - role mapping (1:M) 2. Planners have an option to change employee role (add / delete) 3. There are other downstream systems looking for modified employee -role mapping data. Hence, the…
Level 2 - 3.3.3.2 - Dimension problem for Import data from Data Hub model to S&C model
Hi all, I am working on this task from Level 2: I have the following DAT04 module in the Data Hub model which was successfully imported from csv file called Weekly Safety Stock.csv (attached here): The same module in the S&C model is this: And I can't import the data from DAT04 from the Data Hub model to this one. It looks…
Anaplan Data Export using Cloud ETL - Snaplogic
As per the Business requirement, need to export the data from Anaplan (Not Manual). To define this, we used Snaplogic cloud tool to extract the data and do data manipulation by using Anaplan Read Snap. We can configure this Anaplan read snap in two ways 1. Basic Auth 2. Certificate + Keys based on above information, we can…
Anaplan to Qlikview Connection
Hello Everyone, Is there any API connector available for Qlikview? I want to import data directly to Qlikview from Anaplan Modules. Thanks, Sandeep
Excel extract in attached format
Hi All I want to take extract from new UX grid in attached excel format. This template has a special requirement of showing cells name which appears in drop down option highlighted in yellow in attached screenshot at top left corner. So when we select a value from drop down it refers to a particular cell in the sheet. Do…
Anaplan stops during large imports and processes
Recently I came across and issue where Anaplan users won't be able to work if another user is importing a big file or running a process. it was reported by users that during those time Anaplan stops responding and the dialog box appears which says some user is making changes. Does anyone faced same challenge and what can…
Not able to get correct hierarchy : Level 2 Sprint 1 G3 Location
Not able to get correct hierarchy : Level 2 Sprint 1 G3 Location need help Attaching screenshot for reference
4.6.6 Activity: Import Data into P1 Product Family List Unable to import data from product families
I am trying to upload the product family data into my model in lesson 4, and each time I try I get a notification saying "Multiple files inside an upload package are not currently supported." I was wondering if anyone knew how to troubleshoot this problem.

Importing and Exporting Data

Discussion List