Importing and Exporting Data

Data01 P&L Actual and Budget
I had a question about importing data into the Data01 P&L Actual and Budget module. Whenever I imported data into this module, for some reason, only half the data gets imported. I never see the budget section under this module after importing data, only actual and forecast. Can someone please tell me how to import the data…
How to use batch file process ~ statistic forecast
In statistic model, there are some instructions and power point file. -Daily Batch Process for Demand Forecasting In this document, I can see there are some Batch Process or import actions. But there is no Actions in the Statistic forecast model. How can I run the Batch Process?
Anaplan Connect import error 12476
Hi, I am currently having issues with my script using Anaplan connect and I hope someone could help me with this. The error I receive is: “ERROR 12476 |-- Imports not found: Imports not found for Model-ID=8954E749858F4CEEB35EBD5BFB54595B (Feign: status 401 reading AnaplanAPI#getImports(String,String,int);…
Sprint 1 : Import flat list for country
Hello, The csv file contains country name, code and parent, but needs to be imported as a flat list. A) There is no way we can leave the fields blank while importing as it is throwing errors B) Can i make changes in the source file itself to just get the countries? We do not want the parental hierarchy c) I have just…
Use CloudWorks to solve CurrentDate/CurrentTimestamp in Anaplan WITHOUT using third-party tools
As Solution Architect / Model builder, I would like to be able to create a "connection" in CloudWorks Anaplan using a webservice managed by Anaplan which automatically updates in the backend a file that contains the periodically updated CurrentTimestamp in UTC (something like "2021-02-01T14:10:45"). I will know this will…
refactor the action info tab/API to allow for flows monitoring
For large usage of Anaplan (multiple data hubs and models), it is important to monitor the flows between models. Anaplan is the ideal tool for that but currently many of the necessary info is not readily available. The first and foremost thing to do is to set the API so that the imports endpoind of a model actually gives…
Allow importing items with the same name into different levels of a hierarchy
When importing items into a child list. If there is an item in that hierarchy which already has that name it will be ignored in the import. However if you create the list items manually, you can give items the same name at different levels of the hierarchy. It would be helpful to be able to flag certain items in list…
Restrict Characters in Open Text Line Items
It would be great if text formatted line items that are user inputs could be restricted to only allow certain characters. When users are allowed to input an escape character or newline, it can create problems for exports.
api v2 - POSTMAN examples
I am sorry for not posting these POSTMAN examples sooner. You can download the attached file and import them into your Postman. There are over 30 examples of different ways to hit the API. and this is for those users who are not using cURL. These range from Exports, Imports, uploading data, and reviewing dump files. I hope…
7.2.1 Lesson
I am seeing this error message and can't find the source of the issue. Any help would be appreciated. Thank you.
importing duplicate detail-data into Module.....
I want to import duplicate detail-data into Module..... When I imported, same departmentcode data which is second same data was rejected..... dimension（departmentcode） is Fixed and unchangeable, How can I do this?
Import values is not showing
The Data should like Pic-1 but after import I am getting as Pic-2. Though I followed all imports correctly, still data didn't show up. I have shows Imports for reference. Thanks Friends.
INV01 SPRINT 3 ISSUE
HI Team, I have few issues with the formula, its right or wrong? i have noticed 3 issues in my model 1. For Beginning inventory my formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory here in week 2 of beginning inventory,…
INVO1 SHIPPING METHOD FORMULA
HI I got stuck in the shipping methods where am trying to using all sort of formula but shipping methods showing different error my formula: 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code, lookup: 'SYS08 SKU Details'.Supplied By] error : Data type mismatch: format other than LIST or…
Importing HR Data issue via Script using Process in Anaplan.
Dear Expert , I have to import Hr Data via Anaplan connect Script by using the Process which has been created in Anaplan with Import actions. But while importing its getting failed error as shown below . when i check Process and tried to Execute directly via process i could able to see we need to pass the Period while…
Allow multiple line item updates with the transactional API
The current write back to Anaplan supports a single line item, its intersection and its value. If trying to update multiple line items at the same intersection they whole block of json needs to be repeated for each line item. My recommendation would be to have the ability to have multiple key:value pairs per intersection…
P3 SKU no items
Hi team, am attempting level 2 sprint 2 exam and suddenly when i opened my module its showing an error and asking for work space admin access . any one please help me
Lesson 4.8.2
Hello, I am getting stuck on this same issue. Please see screen shot attached. I keep getting an error message. Thank you very much.
Ability to select a specific Page for entire Workbook when many Excel Add-in Data Pulls are Used
It would be great if we could set an overall workbook time period that would allow us to set the time period we or any "Page" selection for workbooks with multiple Anaplan Excel Add-in pulls. We would also still need the ability to change individual worksheet/tabs data pulls. For example, we may have a workbook where 90%…
Log with Period Anaplan Connect
I want to ask to log (Output) Anaplan connect when there is an issue as shown below?
User based delete action
Hi I want to give a functionality to the user where they can select a Boolean (say basis state) and delete the data in a transaction list that are mapped to that state ( in a line item in the system module). see table: StateCheck to deleteA BYC D Since the user has selected the boolean for B, only those transactions are to…
Import getting ignored for non workspace admin users
Hi All, I have created a simple flush action that wipes out a boolean selection. See the table. User checks a boolean in User Check and then the last action in their process clears out the user check using the flush line item. User CheckFLUSHaY b c d The list dimension has a Selective Access and a DCA so that if one user…
1.3.3.2 Import Data into Country Flat List
the instruction says "Remember this is a flat list, there should not be a parent assigned", but while doing so i am getting an error. Moreover, can anyone verify whether the grid view after the import is correct ?
Import SQL data in Anaplan
Hello Team, I am totally new to Anaplan, requirement is we have to dump SQL table data to Anaplan. In this case, I need to do Import action set AnaplanUser="myemailId" set WorkspaceId="myworkspaceid" set ModelId="mymodelid" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set…
2.3.9.1 Import data into DAT03 Historic Volumes module
Struggling with finding a solution to the error below. Also I attached my import actions and imports from data sources. I hope someone can guide me in the right direction!
Delete from list: but first check if any values in versions
Hi, I am looking to create an action that uses the 'Delete using Selection' action functionality. However I only want the user to be able to delete if there is no data against the list item in any version. Is there a specific way of doing this in Anaplan? eg I have a list of GL codes. At some point some of these GLs will…
Reduce time scale in imports
Is there any process by which I can reduce the irrelevant months in imports while uploading the file. I cant use time range here. Can I do this with the help of any filter.
Load data from One model/module to another via SQL or in any other automatical way
Dear all Having various Models and Modules, is there any automatical way to copy at lowest level of Country (~100 country codes) and Product lines (~300 items) data from one module to another module? Imagine that we are doing P&L Forecast for the future Quarters, and we want our Q4 to be equal to our Budget, is there any…
Numbered List in Data Hub to General List in Spoke Model
Dear Members, I am trying to import from from a Numbered List in Data Hub to a General List in Spoke Model. In the Import Mapping settings pop up, it does not map any members automatically and the only option available to do is manually. Has anyone faced this issue? Is there a way to make this mapping automated? Thank you.
Help needed with Rest API file upload (using R if possible)
Hello everyone, I am trying to upload a file onto anaplan from R and haven't been successful for quite a bit of time. I will list down the steps I have taken and it would be greatly appreciated if anyone can help 1. Created a file in anaplan and set the option to "Admins Only". The file name is driver_coeff_template.csv 2.…

Importing and Exporting Data

Discussion List