Importing and Exporting Data

Power BI Enhancements/Limitations
The following will be primarily based on my recent experiences with the Power BI Connector and Anaplan. Positives: 1. The Authentication has much improved and the use of SSO relieves a lot of data concerns when creating Power BI Reports. 2. Able to run multiple exports into the same model Negatives: In my experience and…
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
Current Page Filter of Export Action
My customer has 18 projects to manage with Anaplan. I created an export action with "all pages" settings for my customers' backup purposes. One excel sheet, one project. Because it's difficult to save all past data in Anaplan, they need an export button to download all necessary data. Even though each 18 project needs to…
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
How to retrieve the mapping information of import action ?
Hello everyone, I have a task to check in all my import files, which columns are used (that is to say, mapped to a Linitem in Anaplan), which are not. To do so, I need have mapping information for the import actions (all at least which columns are mapped), any idea to do this? Many thanks !
Anaplan error - Error parsing key for this row; invalid data: , , ,
Hi All, When I am importing a file to a list I am getting an error as "Error parsing key for this row; invalid data: , , ," even though there is data in all the columns. Its a transaction data set that I am trying to import into a list with list properties using a combination of columns as unique identifiers. It shows…
Source Object Name refresh in Import Data Sources tab of Actions (Model Settings)
The Source Object Name in the Import Data Sources tab of the Actions section in Model Settings is a very helpful piece of information when tracing source module views used in Actions. Model builders normally export this information to an Excel output and filter on the source object name to check which actions are dependant…
Too many cells for ISFIRSTOCCURRENCE calculation
I Import a C11 list to 2 spoke models from Hub. I use the same DataHub and Same Hub Saved view to import into this list. However the import into list is sucessful for one of the spoke model but not the other. The saved view and the import definition is the same for both the spoke model. For one the process is completed…
Unlocking High-Efficiency Data Uploads in Anaplan: A Multithreading Approach
In cloud-based business planning, the ability to swiftly and effectively upload large datasets is an important aspect of maintaining up-to-date planning. This post introduces the concept of multithreading to enhance data upload speeds to Anaplan significantly. This approach, however, is specifically tailored for data…
Anaplan Connect Export stops writing after 30 minutes.
Hi, I have set up export connection to a SQL database. I have 1 connection that takes longer than 30 min to be completed. I have scheduled this one to run overnight. Each time this export is run, it seems that it's timing out exactly after 30 minutes but without a logged timeout error message. See error log (I scheduled…
Adding items to numbered list using Create
I want to achieve this but getting a little bit of a problem: * End User can add an item in a number list by clicking a button. * He can choose Product Family from the drop down (Page Selector). * And after that whatever he wrote in Product Name gets imported to the list under the Product Family Selected. I tried using…
Conditional Parameter
Hello, I hope everyone is doing well. I have a query regarding Anaplan. I have several system modules where I have created unique IDs, each with a different length. In the user experience (UX) part, it's the UX user who chooses the name of the file to import. Then, the ID becomes the File Name + ID. For example, if the ID…
S4 HANA to Anaplan - Mulesoft Connector Limitations
Hi, reaching out to see if anyone has run into issues when pulling data from S4 HANA / ERPs into a data hub using the Mulesoft connector. The volume of data is initiating a model save in the middle of the execution (per Anaplan support) and that locks up the model. During this lock up, any batches attempting to load during…
Tableau to Anaplan integration
Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh
Ability to import line item format into blue print view
The ability to import line items format while importing blueprints would be really helpful. Currently, I've set up an automated process to import newly created line items from one module into another module on a daily basis. However, I am still required to check the module frequently for new line items imported in order…
Conditional Import
I have two columns, Column A and Column B. Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make the data of Column B not editable using write access driver. However when I run the action to populate column B new list…
Exporting CSV from Anaplan, incorrect date displays in Excel
When exporting information into Excel by month it brings the dates through as text, ex “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for…
errorwithclearrequeststatuspoll exception?
Getting this while inputting in a value in a column.
Update code of a numbered list
Hello, I want to update the code of a numbered list. The user can input a name on the dashboard. Then I want to set up an import to, for example, import the code to the numbered list but it creates me a new item each time, since we cannot map by name in a numbered list. Any solutions to update code in a numbered list…
Model Map Export
I really appreciate the new Model Map feature. What is the best way to export my entire map to a printable format? My model is rather large and I can't get the view with details out in a usable format.
Fix ability to use zip files in Cloudworks and UX
While using import actions in UX and Cloudworks I discovered with the help of Anaplan support that zip files cannot be used except through the backend and old UX. We would like to have the possibility for Anaplan to use zip files in UX and Cloudworks as it is indicated in the Planuals best practices. This is required to…
Date Import not working
Hi All, Need some quick help I want to import a date from 1 module to another module using Import action, however I'm error as "Invalid date" Module 1 - 1 line item (date1) | date format> currentperiodstart() Module 2 - 1 line item (date 2) | date format Now, when I'm trying to import date from module 1 into module 2, I'm…
creating a new import
How do I create a new import? I have created the Import data source, but now I want to link it to an import. Thanks
Export via a Report from App by API or similar tools
Hello, As discussion with support team, I have an idea for the export functionality from Report in an App. Anaplan's native function can be utilized to export a different report (when we change a filter for example) in PDF. Dose there has the method as API to retrieve all the 3 reports from your servers? It is not related…
Export Action Error
Hi Team, Any update why an export action for might be giving error in export action? It says Export Successful and Export failed at the very same time with file not being downloaded. However, for others its working fine. Thanks in advance!
I am struggling with my mapping and import of E2 Employee List
Hello Model Builders! I need your help in Model Building. I have tried over 10 times to import data into E2 Employees# under Lesson 4.8.2. I have spoken to some colleagues on my team and the we were unable to resolve this issue. If anyone could assist please share a solution or trick to this. I noticed other colleagues had…
Clowdworks integration failed because of the server error
Your integration failed because of a server error. Check your integration setup and try again. Hi! I got this error when trying to schedule the import action from one model to another. I have full access role and WS admin role for both models. So what could be the problem? Thanks for your help in advance, Anastasia
Bulk Copy functionality available from Dashboards for non-model builders
As a Model Builder, I want to be able to create specific/dynamic Bulk copy processes so that end users can run them via dashboards. I'll know this is successful when I'm able to publish on dashboards specific bulk copy processes using the standards Anaplan out of the box functionality and without the need of creating…
Show process Id into actions window
it's would be useful to display process Id into actions window (in a dedicated column)
Transactional APIs - Part 2: Use Cases
Introduction Following use cases will be presented in this section: How to retrieve id for a given dimension/list & list member from its name or code How to retrieve allocated & consumed space for a Workspace & Model Workspace Sizing Use case Model Memory Usage Use case How to retrieve permitted number of Items & Index…

Importing and Exporting Data

Discussion List