Importing and Exporting Data

List Subset Definition based on formula
Is it possible to add functionality to make list subsets based on formula? Currently we have to either manually select list items to be included in subset or need an import action to update based on subset logic written somewhere else. Can we have option to add formula directly on list subset definition? This will help a…
Make a Line item Sign Change
Hi, I would like to know if it is possible to make a line item that I'm drawing data into from a flat file to make the numbers coming in negative. I have a Flat File where the numbers are negative on the Flat File, but need them to be positive in Anaplan (Vice Versa). How would I go about this without completely changing…
File download issue in running export with python API
Hi Everyone, I have been trying to run an export action and a process containing the export action using python API for Anaplan. The output shows python API running the export perfectly but no file gets downloaded. Can anyone suggest the reason for the same and if any workaround is available for this issue ? I need the…
Bulk Data Change Details in History Log
As a model builder and administrator, it would be a huge improvement if the history log could provide details into Bulk Data Changes. Our company utilizes user imports, and it is very difficult to track down changes when everything is grouped into one line of history. One option is to run history on individual cells of…
Add custom Text Prompt or Dialog Box to Actions
In the new UX, I would love to have the ability to add custom text to the dialog box for imports and other actions, or add a confirmation prompt. For example, "warning: running this submit process will make all entries final and prevent further editing".
Azure Connector informatica
I am trying to bring data from Azure data lake to Anaplan using informatica. But I am getting this error when I create an Azure data lake V2 connection and test it. Has anyone faced similar issue in informatica? Thanks
Have a timestamp on when an action or process was last ran
It would be great to have Anaplan built in functionality to tell a user when an action or process was last ran. This would be extremely helpful in identifing forecast locking, data loads, etc.
Level 1 Model Building
In 10.2.2. we import non employee expense data but the mapping is not working and there are no ideas in the training. Any solutions would be greatly appreciated. Thanks Neil
Level1 exam import the SKU volume data
I imported the csv file but the mapping was not correct and all data was showed on the Jan. Although the time scale is monthly, the data isn't imported per month. Could you tell me how to fix it please?
Ability to export values as formatted for .CSV
As a user, I need to be able to export data in the format I have set instead of a standardised format when exporting as .CSV. For example, I want to be able to export * Large numbers - The option to export "1,000,000,000,000" rather than "1.0E12" * Small numbers - The option to export "0.00001" rather than "1.0E-5" My data…
'Last run' column in Settings>Actions>Imports grid
Description of the enhancement required: Imports and Import data source tabs were added with the recent Anaplan release. We would like to be able to view the date the last import is run in say another column. An example of the enhancement: Column field next to the import action that shows the date. How would it…
Question: Action Timestamp Obtainable in a Line Item?
Community, Does anyone know if the Action Timestamp can be shown on a page or dashboard, most likely through a line item? Or, is it just on the action tab? Can the action timestamp be retrieved with the new Transaction APIs?
Anaplan Level 2 Sprint 2 Lesson 2.3.9 Import Process 9
Hi I tried this process and got error messages. Now I find I have accidentally deleted the Process 9 from the Actions page. I can't see the process 9 in my Supply Chain model. Could someone help me with this please. I have provided the screen shots of my previous work with error messages. I am not sure what went wrong.…
SAP BW
How can we use Informatica to establish a connection from Anaplan to SAP BW server? Are there any links or tutorials for the same?
Leason 4.8.2 , Import data in E2 Employee
Importing and Exporting Data Hi team, Did the mapping as per my understanding making some error here, I am unable figure out the error getting numbers under the Sales and not the names of employees in sales team. Please guide me. @noelle_murphy I also tried the steps from…
Modelbuilding 1 question 7.2.3 importing employees
Somehow I can't get the employees imported, in SYS08 Can anyone explain how to do it, I do not know what to use as mapping. I tried this: But it returns failures on start date, leave date and other columns Then I tried manual mapping, which partly worked but still it won't fill all the columns: Does anybody have an idea…
Search Functionality for Import Data Source Selection
When setting up an import into a list or module, it would be useful to be able to search for a module/list/saved view when connecting to an Anaplan model on the "Select Source" section. I have a model with hundreds of modules and having to scroll through these modules every time I set up an import action can get tedious.…
Ability to use Line Number as the List Member when Importing from Excel/Google Sheets
There are times when we are importing data that Anaplan recognizes a row of data as a duplicate, but the duplicated data has meaning to our end users. Anaplan is able to tell us in the error message which line of data the duplicate was on. Is it possible to create an option to use the row number as the list member to avoid…
Import Data from Microsoft Azure into Anaplan using Informatica/Hyper Connect
How can we use Informatica Hyperconnect to import data from Microsoft Azure to Anaplan. Is there any direct solution or links to this?
Include non-time based line items in export of time-based modules
Hi, I have a module with the following dimensions: time, items and sites. And I have the following line items: Demand and code item at site (which is independent of time). I want to make the following export (where the line item "Demand" is filled in under each time period and the line item "Code Item at Site" is included…
Mapping Datahub and Spoken Model
Hello, I have two questions regarding Datahub and Spoken Models interaction: 1. How Spoken model can find the link to Datahub after an ALM if we have a dev and production version of Datahub? For exemple, we have 4 models: Spoken Model DEV, Spoken Model Prod, Datahub Model DEV and Datahub Model Prod. The inter model actions…
NUX: Import File Selection Type as CSV by Default in Instruction
Hi While importing from NUX, by default it asks the file type to be CSV, but the file I am using may .txt file or other. Although it has no impact on data/action, it may confuse user while running the action. Is there any fix for this? Rahul
Decimal Places for a Number Formatted Line Item
What is the maximum number of decimal places for a number formatted line item? Is there a way to check which cell for a given line item has the most decimal places? Need to know for an export into a datalake / warehouse for storage
Warning when attempting to change a saved view used by an action
No small amount of problems have been caused in our model by someone unknowingly altering a saved view that is used by an import action. It seems reasonable to me to tell the builder who is about to delete, or overwrite a saved view that is used by an action so they can make a decision to proceed or not. Ideally, it would…
Option to select Column Headers starting column(optional)
Hi All, I am seeing this error for a long time, so I thought of sharing this here, there might be a solution which I don't know. if there is a solution pls share it. Let's assume I have an import template as follow Column 1 - Display Name of the List Items Column 2 - Unique Code Column 3 to end - TIME(JAN 21, FEB 21,...)…
Mapping issues
Hi, I'm having trouble mapping this excel sheet. Attached is a snap shot of what I'm trying to map and also the excel sheet I'm trying to map. Please advice. Thank you
Pulling data from Source systems into Anaplan
Hi Team, I am searching for some information to connect Anaplan with different source systems. Is there any white-paper as such to know which will be the best way to connect different source systems to Anaplan for planning purposes? Also, if I may ask about IQVIA, Integrichain, SAP and other ERP sources? Does getting the…
Trying to load from file to module data
Hi Community, I'am developed following dashboard to our end user. My problem is that if I want to load local accounts from a file - all local account will goes ignored state. The module contains a numbered list. My primary key in the module is combination of company+local account number. My question is that how can I…
Help With Level 1 Model Builder Section 7.2.3
Hi there, I was doing really well on Model Builder Level 1, but I have become stuck at Section 7.2.3. I have downloaded and saved the data file "Employees.csv" I went to module SYS08 Employee Details Went to Data -> Import and picked the saved CSV file Please can you assist with the Source Columns I should use? I picked…
Increase Size of the Action Icon for Additional Insight Cards with Actions
When working in a worksheet the user is able to add various cards (text, field etc.) to the additional insights pane and even add a process/action to these various cards. However, the Action icon in the top right of the card is extremely small compared to most large blue processes Anaplan offers in the UX. Can we increase…

Importing and Exporting Data

Discussion List