Importing and Exporting Data

Export line item codes
Description of the enhancement: To be able to export the line item codes instead of only the line item name. Description of business use: I have a financial statement report module where I have accounts as line items. This is because some of the accounts are calculated. We have a need to export this module with account…
Anaplan API 2.0 Python Library Certificate Error
Hi, We are trying to change from basic authentication to using a certificate. I am using the Anaplan API 2.0 Python Library. When running AnaplanConnection function I am getting the following error that I traced to the anaplan_auth.py. TypeError: from_buffer() cannot return the address of a unicode object I have tried…
CloudWorks
Hi, I have just started using CloudWorks, it's a great Anaplan in-built tool for integrations and processes but does anyone have any idea how can we run subsequent process in it. for ex. I have a process A and process B in my model and I want to run in a manner that as soon as process A is complete, Process B should start…
SKU.csv file on level 1 exam
In the first part of the level 1 certification exam it tells you to create a new list using the SKU.csv file they give you. The SKU.csv file you download ends up being multiple files in one folder. When I try to import the one of the attached files (SKU) into my new list (P3 SKU) nothing happens on my screen. Then on the…
How to calculate Anaplan model size?
Hi Guys I am using below calculation to find model size 1000000000 cells = 9.3 GB 1 cell = 9.3/1000000000 Total cells exported from module export = 6206436639 which gives me 57.71986074 GB's problem is Anaplan shows model size as 39.29 Gb's ?. I have used this calculation on 8 models and all of these comes close to model…
Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?
Google Sheets Add-on: Send formula driven figures back to Anaplan
The idea would be to receive information from Anaplan, have the ability to update the information using editable inputs (e.g increase sales forecast by 10%) and then send the result (of Anaplan data * 10%) back to the Anaplan module.
Import Shipping Expenses into OTH01 Module
Hi everyone, I'm still struggling with the import into the FP&A model (Level 2 Conclusion) Here's the mapping I have had: And here is the error I have got: Here's how my INV05 Shipping Export module looks like in a Blueprint mode: Is there any chance someone could help me, please?
Clear all items reset to "Match items in source" when a dimensions mapped on "Fixed item in" or info
Recently I had and issue with a Model where the import setting “Which target items to clear prior to import?” was set to “All items” but not visible in the import screen because the Diemension was remaped to single item. Altough the Dimensions was mapped to a single item, it was still cleared all items but that setting was…
Community perspective: Flat-file Data Load - CSV Encoding Issues
Problem: In the same way we cannot load .txt files (usually tab-delimited) through a data load action originally created with a .csv (comma delimited file), trying to load .csv files with different encoding parameters can result in an issue too. This is the error message you will get in both cases (attempting to load a…
Export data to .csv file from a module with page selector and filter is not working
Hi, Exporting data to CSV file from a module with page selector and filter is exporting incorrect results: Sample Data as per my example below, Anaplan is applying the filter (amount<>0) to the first month March 23 only. Zero's are getting exported for the intersections data available in first month (filter is not applied…
Issue with download SUM Demo Model
Hi, I'm trying to import model 'SUM Demo' Model into my workspace but I can't find it. Can you please help me? Thanks, Ana
Size.csv missing - unbale to import the data
Hi, I'm not able to import the Size.csv file into workspace due to the fact that I can't find it into the training or into the Anaplan. Error message displayed: he uploaded file is no longer available; please upload the file again. Can you please let me know where I should find the files? Thank you, Ana Maria
エクセルのToday関数のように現在の日付を特定する方法
みなさん、こんにちは。Anaplanモデルビルダーのセナです。本日は、エクセルのToday関数のように現在の日付を特定する方法を紹介したいと思います。現状Anaplanでは、エクセルのToday関数のように現在の日付を特定するためのネイティブ関数はなく、Idea Exchange では多くのビルダーに要求されており、保証はできませんが、今後の新機能として追加されるのに期待です！追加されない間は、以下の方法で実施してみてはいかがでしょうか？今回は、わかりやすく表現したかったため、"Power Automate"を使用しました。実際には、API叩けたら、どんなプログラミング言語やツールを使用してもOK！ 1.Power Automate…
Import script as stopped working, but the manual import runs succesfully
I am importing data from Snowflake and successfully saving the csv file, this has worked for about 2 years They changed their column headers, I then downloaded the new format csv, and created a new import using this file, which works 100% However, when i add the new import to the script it crashes at the import stage…
Import failure: The dimensions in the target module do not match the import definition
Hi Anaplanners, I'm stuck with two imports which have the same settings, from saved views based on same module, and to the same target module. However, one works, but the other one always runs into a failure with message "The dimensions in the target module do not match the import definition." I have two saved views from…
Cloudworks Integration "There was an internal server error" for BigQuery Data Source option
Hi experts, I was trying to export Anaplan data to BigQuery via Cloudworks. I have established a connection but when I am trying to set up the integration, I keep encountering the issue of "There was an internal server error" under the Data Source option. Can anyone provide any advice on how to resolve this?
Clubbing multiple excel exports
Hello All, We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed. Report 1 -> Sheet1 of excel Report 2 -> Sheet2 of (of same excel)..and so…
Format while manually exporting data
When we manually export data from the anaplan model, several formats of the data can be exported. I want to know the difference between the two formats 1.Comma separated values(.csv) and Comma Separated values for Excel(.csv) 2.Excel(.xls) and Excel (.xls) not formatted 3.Excel Open XML(.xlsx) and Excel open XML(.xlsx) not…
Hi, I'm currently in 10.2.2 Activity: Import Data into Non Employee Expenses Module
In my first screenshot, you can see the source and target mapping for the data. In my second screenshot, I have correctly mapped the time corresponding to the format available. (See 1st screenshot in the column header for time to understand the format) In my third screenshot, there's an "import failed" window. I don't…
Export ignoring show/hide
Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers and GL accounts. I use tabular single column for my export as I want all dimensions to be columns and only a single line item…
Why several actions in process are not updated?
Hello, I have been importing data from a data hub daily for several months now. In the last days the last 2 actions of the process are ignored on the update. The actions are very simple. It is importing a date from the data hub. I can't understand the issue. All the other actions are working properly. When I am launching…
4.8.2 Activity: Import Data into E2 Employees# List
Hi Anaplan community, Had a bit of trouble importing employee details into the list. I followed all instructions given in the community regarding this and even tried deleting and importing the list multiple times but it still displays employee number instead of name. Hope someone can help. Thank you!
Update Current Period Action from Data Hub Not Working
I’m having trouble with Updating the Current Period action using an imported line item from the Data Hub. I created a systems module and added a Current Period, time formatted line item with no dimensions in the Data Hub and Spoke Model. I created the action to Update the Current Period in the Data Hub and it worked…
1.5.6.2 Import Data into Historic Volumes Module. Need some help
Hi, I am having some trouble trying to import data to the module: I ran the upload and it is successful. But then all the volumes data in my module is all the same, meanwhile in the import file each volumes are different. Any idea where I went wrong? Please help 😞 Thank you
Hello,
I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…
Ability to combine processes across models in CloudWorks
The use case is to orchestrate a data integration workflow in one CloudWorks schedule containing steps executing model-to-model imports from many processes residing in various models, e.g. update DataHuab lists and modules, then update planning model lists and modules, then update reporting model lists and update.
Sort Workspaces in Model>Model Import View
When setting up an import and selecting the "Connect to Anaplan Model" option, if you need to navigate to a different Workspace, you may be in for a bit of a maze. The workspaces are randomly sorted today, when nearly every other view (manage models from home page, new breadcrumb navigation in updated modeling experience)…
Exporting data to different tabs in excel
I'd looking for something that I think I've seen in other systems referred to as "explode" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each…
Wrong date when doing an import
Hi everyone, I am importing data into a module which gives me the employment date of a list of employees (among other info). The module doesn't use time as a dimension. The import goes perfectly well, it doesn't mention any error. But then some of the dates are wrong. So I tried to copy these directly from Excel (simple…

Importing and Exporting Data

Discussion List