Importing and Exporting Data

[ACTIONS/IMPORTS] When importing use the file name for automatic mapping
Description: As a model builder, I want to be able to use the file name that the user uploads, so that it can pick up automatically a dimension. This can be done when the source system exports files that have dynamic naming based on the selection of dimensions. Example of Enhancement: I’ll know this is successful when I am…
Import Error
Hi All, I am facing an issue in the import action button set on a dashboard. The action button allows the users to upload the excel file in anaplan but after the upload is complete the details show that import process is successful and show nothing under the updated, ignored and failed sections and hence no data appears in…
Feature while Exporting
Currently when we export the data out of Anaplan we either create line items in the export module or we rely upon Properties of the dimension. Idea I am proposing is to give modellers third option which is to pick the line items from diff modules in the export window (Preferably System module) which share the common…
Level 2 sprint 3: Create DAT04 Distribution Center Parameters module & import data from Data Hub
Hi Team, I am confused as in, In the activity, we were told to import from the data hub model, which has half-yearly as line item along with weekly safety stock. Because of which I cant map it while importing. My importing was complete but with error and I can see the data in the supply chain model as well. Do I need to…
Level 2 Sprint 2 DEM Restricting export functionality
Hi Team, I have cleared level 2 sprint 2 exam, but with one wrong answer. In one of the activity, we need to restrict the export for the 3 module from DB. So I unchecked button DATA-EXPORT checkbox in menu options. But it seems it is an incorrect option. What should have been done then?
Re : Actions
Hi All,@VIGNESH.M @ @JaredDolich @rob_marshall Please let me know the solution for this issue. " For material 079A1803 the Product Hierarchy was changed end of may from PL 31 to 48. In H1 the Product line is correct 48, in M1 it is old 31 I can see the M1 is automatically updated 17 june. Please check why P03 is not…
Donwload Anaplan File from Cloud
Hi, I understand we can use Anaplan Connect to download file that has been uploaded. Can we also do this via Action that is published to a dashboard? I do not find Action that can download a file. Regards, Andre
Anaplan REST API with Cert Access: Connect to different Models
Hello All - I am building a process to connect to Anaplan via REST APIs. I have an integration account and utilizing CA Cert for authentication for API authentication. I have two workspaces, say WorkspaceA (with Model Model-A) and WorkspaceB (with Model-B). I have build a list in WorkspaceA/Model-A. My integration account…
Run Data Import
Hello I would like to seek for your advise. During data import i am supposed to see this area after i have imported my excel file But as i was doing it, this is the only steps being shown:
Importing Data Into List Issue
Hi Anaplaners, I'm encountering an issue when importing data into a normal list. Let's call the List "L1 Property" The list has a parent called "L0 Group" I'm loading data as shown in the table below into L1 Sub Group list. L0 Group: Ice Cream L1 Sub Group: Ice Cream Anaplan is not able to load the data through importing.…
Dump Files in Mulesoft Connector
Hi, The Anaplan Connector for Mulesoft only let you download the dump files in path, it push you to work with a local server, when in almost all the cases the customers use Cloud environment and the data goes through streaming to Anaplan. Would be nice if you can collect the dump file directly in the connector and sent it…
When the import process fails depending on the user
Hi,everyone. I have a question. When importing data from module to module, the data is not imported due to "ignored". In the case of WorkSpace Administrator, it does not become "ignored" and it ends normally. I assume it's because of permissions, but setting permissions seems to be fine. What are the other possible causes?…
Import a subset from one list to another
I have an import of an entire organization, which includes all levels (sales person, manager, regional manager and divisional manager). I would like to use the list that it imports in to and populate individual lists (one for each of Sales Person, Manager, Regional Manager and Divisional Manager). I have them all in…
Level 1 Course importing files
Hi, For the Level 1 Course I have a few questions about importing files. I was wondering if it would be possible to talk to one of the experts on zoom because I think that would be easier and faster. I have to submit it soon so I would really appreciate any help. Thank you so much.
daAnaplan V2 - Informatica IICS - Error
Team, I'm using the Anaplan V2 connector from Informatica IICS but it's giving me very generic error message. Note sure what is the issue here. Any suggestions, please let me know. Thanks, Santosh Biradar
EMP02 Module_ Level 1
Data was successfully imported, mapped and formulation was correct as well in EMP02 module W.r.t EMP03 and SYS08 however, the value for Dec 2020 is not the right answer. Now I am confused as in what exactly went wrong. Can somebody please guide? Thanks
Copying Actions
I have an action to import today's date into a field 'Today' in a time assumptions module, every night using connect script. Great, works perfectly, all is good. I have a separate action/process that runs ad-hoc, but when it does, I would like to import today's date into another field in the time assumptions module 'Update…
L2 Supply Chain Model - Errors while loading data from Data Hub Model
Dear Community, I'm facing show stopper while running the historic volumes import into Supply Chain Model from the Data Hub Model. I ensured the source model is mapped correctly in Supply Chain Model. Further also checked at the individual import step to see if the object is referred correctly. Still, I'm getting below…
Level 1 - Expense by Role
I need to set Employee drivers by Role, so i created a list and imported roles data into it. 1) what should be my parent hierarchy in this case - All roles? or All departments? since i had initially created Employee hierarchy with E1 departments - (All Departments being at the top level) then #E2 Employees with E1…
Correct mapping guide
Hi, I have created a new list called 'SKU' which needs to be added at the bottom of product hierarchy for SKU's. I have denoted the hierarchy and tried importing the data. Can someone please correct what's going wrong. Thanks STEP 1 STEP 2 STEP 3 ERROR HIERARCHY Thanks
Module to Module Import
Hello Everyone, I have a module named A. I have an action where the source object is a view of the module A and target object is the module A. I have done the following mapping in the action. All the Dimension have been correctly mapped for the import but when i come to the line items Mapping * I am mapping the "Sales Ops…
Import: Mapping Issue with Tab Separators
Hi all, When I tried to upload .csv file with Tab separator, I cannot see any mapping with setting (Please refer to the file called "Separtors=Tab.PNG") and import went to be failed. With Column separator, however, I could see what items were mapped (Refer to the the file "Separators=Column.png). The difference between…
How to create a Saved View using Actions
Hi Friends, I have a Module. And I want to create a Saved View (of filtering) by Action. Is it possible?
Import Error - More than one value for non-numeric cell
Hello everyone, I'm receiving the following error "More than one value for non-numeric cell" when importing data from our Data Hub model into our spoke model: The file that I'm importing into a module in our Data Hub contains a table (in CSV format): The "Id" values (which are unique identifiers tied to separate records)…
New UX clearing user entry
I have a display which allows user to enter values he/she is looking for. The page is based on module dimensioned by USERS. As the new UX requires user to clear the field one at a time and we have quite a few fields for filtering, I thought I create an action that will reset the fields from other dummy fields which are…
Error in Import - Expected 2-digit month number in date/period
Hi Guys, This might be simple but I do not get why it is having an error. So I have 2 identical modules. I have IC PNL and AIC PNL. They are both identical in terms of dimension and line items. So what I am trying to do is import IC PNL to AIC PNL that simple. Whatever numbers is in the IC PNL should be the same as the…
Tool for Choosing an Integration path
I have attached a decision tree for deciding on a Data Integration Method. I believe will be helpful to us with Clients to help them decide the best path based on resources and skill sets available in an organization. Please feel free to share!
Import same value from 2 dimension module into 4 dimension module
Hi, Have a small challenge - I'm trying to import line items from one module with 2 dimensions and into another with 4 dimensions. The 3rd dimension in the latter is set to ask on import but the 4th is irrelevant, i.e. the import should basically import the same line item values into the module for every item in the 4th…
ANAPLAN API : Get dump files from process with any action
Hello, I'have an issue, when i tried to retreive the dump file from a process with multiple actions, the API returns a 404 status code. The URL called : https://api.anaplan.com/2/0/workspaces/[WORKSPACE_ID]/models/[MODEL_ID]/processes/[PROCESS_ID]/dumps/[OBJECT_ID] Where the Object Id comes from the task result where…
Importing with Time Dim in Mapping
Hi, I have an Module with Tim Dim and list. It has a line item called Data which is an Input filed. I need to create action such that the data gets copied from one quarter to other. Example: I need to copy data which is Q1 to Q2. I tried to create a saved view and create an Import action from saved view to module, but it…

Importing and Exporting Data

Discussion List