Importing and Exporting Data

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…
Workflow triggers Import/Export
Having CloudWorks schedule imports between models is useful, but users still need to wait. Our users are participating in a workflow, data is ready to move from the source model when a workflow step is completed. Can we trigger imports or exports, or model-to-model imports from workflow?
Export - Data Source
Hi Community, I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of…
Export defined in a model should be connected to a view
Hello Team, Currently, when we create exports and save them in actions - they are disconnected from real module views. Example: if you create a new export definition, based on a current view (with a filter or smth else) it is not possible to revisit and amend this view after some time and see what view is feeding an export…
Native scheduling action in Anaplan (w/o API. Connect or 3rd party integration tool)
Could Anaplan action iteself allowing for scheduling? (i.e. a common use case would be you have an action that brings data from Data Hub to Spoke models and data in Spoke models need to be refreshed everyday) - It would be super helpful to have this function built-in at the time the action/import is set up in Anaplan,…
Import from SQL Receiving Error - "Anaplan API: Cell text cannot contain tab character"
We are attempting to switch our source from excel files to a SQL server and are receiving this error when running the scripts for Anaplan Connect. The job is successful for the initial two tables but we're experiencing this error on the final table. The formatting and configuration is similar for all tables so unsure why…
What is the difference between Modules and views. can multiple views creation possible in a module?
3.) What is the difference between Modules and views. is it possible to create multiple views for one module.
Anaplan Cloudworks - Azure Blob Storage Integration
Hi All, I am trying integration via Cloudworks to import csv files from Azure Blob Storage. As per Anaplan Documentations, its just mentioned Azure Blob storage. Is it the ADLS2 Gen 2 Blob storage or normal azure blob storage which is required for Cloudworks integration. Thanks
CSV Upload - Help
Hi, I have a CSV file with Time Period, however, this fails to upload into Anaplan. How do I fix this? Thanks
Load monthly data into weekly time setting model
Dear Anaplanners I have a dump question whereby I cannot get it over yet. I have a model whose time setting is designed as weekly (for later stage replenishment planning) While the demand forecast is still by month, so I have an import module to load monthly history sales dimensioned as below: My source csv file looks like…
DEM01 Volume Growth Rates - Import issues
Hi, I am having some issues re- uploading the data to module DEM01 Volume growth rates. The current view that I have is the following and is not picking up the growth rates by product category. However when i do the import, it shows as it has been successful. See below my selection and successful screenshot message Any…
2.3.8.2 Import into DEM01 Module
only october month is loaded during importation targert still on week eventhought i changed it for month time mapping
When do your integrations require workspace administrator privileges?
Generally, you don’t need to have Workspace Administrator (WSA) privileges to run integrations; however, there are still some specific instances when they are required. This guide will provide an overview of when your integration user requires WSA privileges. Anaplan user types involved in integrations First off, let us…
Export Anaplan Data with Non-WSA User
A customer’s Anaplan COE needed to share planning data with an internal department. The solution below leveraged a non-WSA (Workspace Administer) user account with Model specific access and an Anaplan Connect script to deliver the required data. 1. Create a non-WSA user ‘service account’ as an Internal user, although this…
Within Excel Add-In having an ability to customise elements on the fly
I'd love to this feature become available is an ability to create individual dimensionality intersections, similar to that of TM1 or Jedox. This is where the various element intersection points can be typed into the excel sheet and so long as that sheet is connected to Anaplan, will pull the data into Excel. This is also…
When exporting a NUX dashboard to PDF, Links should remain clickable from the PDF file
If I have a New UX dashboard which includes links created with the MAKELINK function, when I export the dashboard to PDF the link looks clickable from the PDF file but in fact it is not. I would like the links to remain clickable in the exported PDF version of the dashboard.
Errors while running process.
Hi, I'm getting below error while running for all process in the model which were running correctly till last week, each process involves imports from multiple models(1 -5), what can be reason for this error? what is workaround? error -> Error Message : "localMessageText": "Import connector: Failed to retrieve data from…
custom function script
Allow users to create custom function via a scripting language like Java. The idea to me is have the capability to become as flexible as needed with scripting. The use case i have in mind is being able to create a hashing algorythm to use as a code. This can be a work around to the 60 limit character limit.
[Updated] Level 2 Sprint 2 DAT03 Historic Volume
Hello Experts, On DAT03 Historic Volumes my volume line item don't match with the values for FY20 but does match with Offset volumes for Fy20. I used the following formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0. also in DEM03 demand forecast pulls only FY20 data not FY21,…
Can not see download errors unless downsize browzer
Hi, I have a question about downroad error when run import. If there are many import error, we cannot see downroad error button. I can see this button when I downsize the browzer. Does Anaplan plan to modify this problem?

Importing and Exporting Data

Discussion List