Importing and Exporting Data

Unable to find correct formula
Can anyone help me with this, please? I'm unable to get the correct formula for this.
INV01 Ordering Inventory Export
My export file seems to have everything okay except for the 3rd number onwards on the first row. And I used this formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
Renaming line items should be propagated to import definitions
Currently renaming a line item correctly updates all module formulaic references. However, it does not get propagated to import definitions and Anaplan silently "ignores" the change i.e. the target column stops getting populated without any error or warning. Ideally name changes should get reflected in all aspects of the…
Data import analysis
Would be very beneficial if Anaplan provided more details on the data imported. Besides the normal error log, it would be helpful if e.g. max/min values, outliers, exceptions, trends, most/least frequent items, dimension items count etc. could be displayed upon import to help the user do a quick sanity check of the data…
Rename List Items
Hello, I have a List with names only and no codes. The names in the source system are now increasing beyond 60 characters. I want to change the naming convention in order to accommodate the size limitation. I know I will need to add a code in order to change the existing names. However, if I rename List items, will all…
Exporting Saved View & Tabular Multiple Column
Before I go off to support and see if it's a "problem" just want to make sure that it's not me! Have a saved view that has filters on the page selectors and am then looking to export this view using the tabular multiple column option (there are three dimensions as rows already) but when the export is run I get every…
Allow Multiple Item Mappings on Imports
Sometimes when I import data into a line item or column, even though they match directly with the existing column, I still have to manually map the items. Sometimes I have a very large list of items which can span to over a hundred. When the auto-map does not work I have to manually map each one. How possible could it be…
Anaplan Cloudworks and Connections
Anaplan, Director of Product Management, Dib Banerjee, with Sean Culligan @sean_culligan and Kirill Barshevsky @kirill.barshevs share some insight into how Cloudworks can help you better integrate data into your Anaplan use case.
L1 SYS08 Employee Details module - Import and Mapping Issue
Can anybody please write down the steps for the particular SYS08 - import and correct mapping As after several attempts and struggling to get it right . Appreciate your support guys.
Level 2 Sprint 1: 1.3.12 - Can't see "Build Region" and others in "Build Geography Hierarchy"
Hello, I am on "1.3.12 Create a Process with Multiple Imports" of Level 2 Model Building: Sprint 1. I edited "1. Build Geography Hierarchy" process but can't find the below highlighted Imports: Instead, I can see the below imports where the action name seems to be the path from which I imported the saved views. Are they…
Import Error : Shipping Metric
I tried to run process 9 - Import data from Hub. The issue is similar although it's failing to import into the Shipping Metrics. No details of failure is provided. I checked for data mapping by trying to import just the shipping metric Not able to successfully import the shipping metric. Can someone point me what's the…
Level 1 Exam - SYS08 importing employee details and data in "Role" cannot seen....need solution
Unable to pull data from DEM02 module into DEM03 module
Dear Experienced Anaplanners, I am at Level 2 Sprint 2 trying to use formulae to add data to Demand modules. As per the lesson, I've created DEM01, DEM02 and DEM03 modules. DEM01 and DEM02 are Volume Growth Rate by Month and Volume Growth Rate by Week modules respectively. I have used formulae to pull data from DEM01 to…
Data Import error
The target mapping The Source mapping The dimensions are different in source and target. I am unsuccessful and having issues with successfully importing into the module. Any suggestions on where I'm going wrong?
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello, I can't seem to figure this error out. Any advice? Thanks!! -Michael
Building a Chat Bot - Part 1: using GCP
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Using Anaplan APIs on GCP * Authentication * Secret Manager * Create a Google Cloud Function * Examining the code * Best Practice: Information encryption * In summary What is covered in this article?…
Exporting multiple modules using API takes too much time
Hello Community, I'm trying to export multiple modules (7 modules) using the API. but it takes up to 4 hours to do that. The size of the biggest module is about 600Mo. My questions are the following : Is there way to do a full export of the Anaplan modules (like creating a dump) ? Is there some possibilities to accelerate…
2.3.9.1 Import data into DAT03 Historic Volumes module issue
When I click run I get this error message. I checked to ensure that everything was still there on the import history and its there. Model object "'DAT03 Historic Volumes'.Export" could not be located
Excel Add-In Options for Export of Data
While the Excel Add-In has seen significant improvements in both functionality and performance in recent months, it would be useful if a user could have the option to treat the data more of an "Export" and less as a "Pivot" - I am trying to essentially accomplish the below - but through functionality I would expect from…
Importing data via model connection
Hi I have a request fromme and a customer:: * When importing data via Anaplan model, can a find diologue box be available to search for models/data (instead of using ctrl F) and can a preview of the data eg view be imported; be provided to show the data source prior to confirming the import?
Be able to execute an action as admin
It would be useful to define some action to be executed with "admin priviledges". For example to clear, with an action, some DCA dependent line items that are no longer writable.
2.3.10 activity
I need help, I’ve been on this section for a couple of days and can’t seem to figure out why my data is not populating. My formulas are correct but I’m not understanding.
1.3.4.2 Update SYS06 Country Details Module
I am having a hard tie with importing the data into this module. I keep getting an error message. I am mapping column 1 country code>country flat, and column headers>sys06 country details line items. Please advise as to what I am doing wrong.
import shows failure but data is updated - import with subsidiary line items
Hi Anaplan community, As part of preparing my model for next year's use, I have created clearing modules with line items formatted as "No Data" to import into my original module to clear that from any user input. One module which I need to clear has line items with subsidiary views, using a subset of the list which I use…
Task scheduler issue in Anaplan Connect.
Hi Community, I would like to ask something about the Anaplan Connect. So in our client model, we created a Anaplan connect to update the current date on the model. This is used for period locking. The date will be used to lock certain period so admin can control the date range of when the users can only enter values to…
Level 2 Sprint 1 - (1.3..4.3)
Hey everyone, I am having trouble completing this activity 1.3..4.3 (L2 sprint 1) I am not able to import successfully, below are the screenshots attached
Level 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module Error
Hello there, I came across one error when I deal with activity 2.3.9.1 Import data into DAT03 Historic Volumes module at level 2 When running the Import it state that the process is completed but show one error, Which is pertaining to the 9.1 Import Historic Volumes. (Invalid line item identifier: Weekly Safety Stock)…
1.5.3 Activity: Create Saved View for Export - DAT01 Beginning Inventory
Hello, I am having trouble importing the beginning inventory in DAT01. While it's showing that everything was mapped correctly, All of the fields are not populating with the inventory amounts. I repopulated my "s location flat distribution centers?" tab and the information is still not loading. Please advise.
Cloudworks failures
I have a process to load lists and modules in my datahub which uses the cloudworks azure connection. Everything was working correctly up until 18th October, then yesterday the process failed via the schedule and failed on manual runs from the cloudworks integrations screen. The Job fails with Process Validation Failed…
2.3.10 Activity: Create Demand Forecast
As per the below activity information provided, do we need to write the formulas for all the line items in the module or need to write the formula for only Growth Rate % line item? Can anyone provide clarity on this activity for me?

Importing and Exporting Data

Discussion List