Importing and Exporting Data

Unknown Error while Importing a Subset
Hi! There is a very simple import where the end-user checks a boolean for the items they want to keep in a subset and then runs an action that takes the boolean value to the list and updates the subset. Clean and straight. However, user is not getting a peculiar error. Can you help me understand the reason behind this…
L2 - Sprint 1 DAT03 Historic Volume import
Hi, I'm trying to import the above but keep getting the attached error message. Can I please get help in identifying the error. Regards, Nayani
Create new List Item from Module
Hi all, I have a hierarchical list of Customers where the bottom two levels are Customer and Branch. I've got a separate hierarchy for products which as its bottom level has SKU. Due to space considerations our Anaplan consultant created a level below Branch for SKU, where items are only created where there is data. We've…
Importing data from big query
We have a problem to build and import the data from GCP bigquery. It need to be automated. I will appreciate the approach and if possible some sample code (written in python etc) to get the data from bigquery into anaplan datahub
Labeling import prompt for end users
With the current import process, when users are prompted for files, it simply says 'Upload a file for input into [insert module name(s)]'. It would be helpful if we could associate which file is used for which action as the end user selects the file. Example: uploading 2 files into the same module, with different…
Import Data into P1 Product Family List
Hello! I am having issues importing data from the product+family csv file. When I run the import, the model says the import was successful. However, when I check the Tree View, no new data shows up under "All Products". I did not have any issues with importing all the geographical data so I'm not sure why the product…
Data Tags as a comment feature for developers
Hi team, As a Model Builder and BAU Support Team Specialist, I am interested in documenting enhancements in our models. Using only the Notes feature as a commenting tool, it is getting really hard to track them all after a couple of years of the model being rolled out. At some level of complexity of the model, it is…
Creating a version with import action - access settings
Hi, When manually adding versions, you have the option to select access setting. By default, it is Write. See photo below. However, if you try to create a new version via import action, you can't specify the access setting. The new version created, has by default No Access. I wanted to automate the version creation using…
Level 2 Sprint 1 Lesson 1.6.4.2
Hi I have now renamed the actions and processes as required by the lesson 1.6.4.2 I find I have an extra ACTION in PROCESS 1. It is ACTION 1.7 Initially the lesson while importing asked us to import only the Distribution centre and the Product Code. Subsequently there was a step to add a formula for import of CODE which I…
Automated version creation
Hi, I am trying to allow non-admins to create versions in a model using AN connect. The idea is for Anaplan connect to import a custom versions list into the native versions. The issue is that versions created in this way have access set to None by default. In contrast, when you add versions manually, your default access…
Broken saved view caused by renamed LI part of the saved view
Hello, I have recently stumbled upon the following case: I have a saved view part of an Import action. I've done optimization to the relevant module during which some of my Line items got renamed. A week later when the Import action needed to be executed, it failed due to unmapped items. It turned out that the renamed Line…
Set formatting when export to excel
When end user export data to Excel, both number and text are right-aligned. My end user want to set text is left-aligned and number is right-aligned. Is it possible to set export formatting of each line item when export to excel?
Simultaneous processing (multi-threading) of Anaplan actions
As a user and/or model builder, I want to be able to run actions simultaneously where possible to speed up the data processing and list maintenance actions. This function should also allow other actions to be run only after certain actions have finished running successfully. As an example, if I want to load trial balance…
Extracting Data From Anaplan With Qlik
Qlik has two data analytics tools—the older one, QlikView, and the modern one, Qlik Sense. They both share similar scripting and the same data files. Data extracted with QlikView can be used by Qlik Sense and vice versa. Many enterprises still rely on QlikView and the QlikView Publisher to handle data reloads while they…
add processId, actionId, fileId as columns in Settings (for API development)
This will speed up API development and runtime both. The API requires ID's as parameter, however Anaplan UI shows only the Name. When using API for sending data to Anaplan or triggering a process we now use the name for searching the id. Currently this requires additional looping in our API framework. If we know from the…
Inconsistency on importing data from module to module
Hi All, Does anyone encountered this scenario on importing from the same module. I'm trying to import the value of Aug 20 - Actual to Sep 20 - Budget using a saved view. Here's the result: Item B to F imported the Aug 20 value. But item A seems to add .04. I also tried to zero out Aug 20 then run the import again and…
Financial planning tool selection - Adaptive planning vs Anaplan
Looking for advice as to how to make an informed decision on choosing adaptive vs anaplan for financial planning. Data sets are not too huge and the cost and simplicity of the tools are important factors in the selection process.
Condition-Based Trigger for Email Reporting
The current MAILTO function requires clicking the cell in order for an email to be generated. It would be very helpful if this click action occurs automatically only if a certain logical condition is met. For example, if the sum of all sales from last week reaches a certain threshold or is below a certain threshold, the…
model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
Order Issue when importing to a numbered list from a HUB module
Dear Community, Background: I have an attribute module in the HUB to manage a list (non-numbered). Further, I've built a process to build (by importing) the list in the spoke model as a numbered list. A numbered list is required in the spoke model because it is the lowest level of a hierarchy with duplicated names. Issue:…
Alphabetically ordered list
Hello all, I have a list of employees without alphabetical order in my model. On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when displaying for example. Would it be possible to help me ? Regards,
Anaplan Connect Import source file
Hi Experts, I hope all is well and safe. Would like to seek your assistance with regards to Anaplan Connect script source file. Noticed that when I run the Anaplan Connect script it keeps on getting the old source file in the import process instead of the new source file declared in the script. Please see attached file as…
Cross-workspace data link
Hi, need some explanation as what is "cross-workspace data link" which is eligible at enterprise level edition ? Tried a few search, but nothing relevant showed up. * Could you please enlight me and what use cases you believe this has the most value for you ?
Level 1 Model Building Exam - Model Buliding Activity 4
Hi, I'm trying to download "Employee Details By Role.text" data but it down loads in to the internet explorer. I have attached the screen shots. Can I please request some help on this. Regards, Nayani
Easily Integrate Data From Google BigQuery With Anaplan Connect
Users can leverage Anaplan Connect for bi-directional integrations with Google BigQuery. This free connector makes integrations between Anaplan models and Google BigQuery via Java Database Connectivity (JDBC) drivers that leverage the power of BigQuery's standard SQL. Users can easily pull any data from BigQuery—such as…
Duplicate item in the import file
In User storry 2.2 we need to update the territory with the accounts name, but each account should be map to a Single territory. At 4.4 we should update Territory to accounts with the file. But the file have one duplicate and generate the followint Warning.
Timestamp - Current Time (Formula)
Hi there, I realise this is not something new or possibly already somethere out there ... but wanted to raise it (possibly again) to show how important that would be. There are instances that multiple users are using the system. Sometimes there is a case that those same users use exactly the same processes/actions. Given…
How to upgrade from 1.3 Anaplan API to 2.0
Hello community, Could you please tell me how to upgrade from API version 1.3 to 2.0? Thank you
Level 1 Exam - Model Building Activity 4 importing data file Employee Details by Role.txt
Hi The text file Employees Details by Role.txt is not importing the data properly. As the columns are not in proper order. screen shot attached. Would appreciate some help. Regards Thiru
Filter with time as page selector
Hi, I am trying to create an import with user input and have time as pageselector. When I created a filter to import data with the rows having user input and time as current page it actually filters first and bring the data for all time periods. Now if I bring time period to row and apply filter it bring multiple year data…

Importing and Exporting Data

Discussion List