Importing and Exporting Data

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…
Banner export practices are leaving orphan Budget Items in Anaplan
Ok, so this is a weird one for sure. The implementation team suggested that we exclude zero balances when exporting Budget data from FGBOPAL to keep the Anaplan model size as small as possible. We recently found that there are times that a value will get imported into Anaplan creating a balance for a Budget Account. If…
Power BI connector - Invalid Credential
Hello, I followed the process "Anaplan connector Power BI Desktop" in order to see an export file in power BI. It worked the first time, but every time i reopened the file in order to see the updated export in power bi, i can't connect to Power BI because of "Invalid Credential", and i can't connect to Anaplan either. Is…
Level 2 Sprint 3 - issue import shipping, DC from Data Hub
Hi, I need some help, please. I am digging a hole, chasing my tail, hitting my head against the wall, and drinking too much coffee…to no avail. Level 2 Sprint 3, lesson 3.3.5 Activity: Create Inventory Ordering – shipping method data SYS07 Distribution Center Details and SYS06 Locations Details have no data. It has their…
how to update flat file daily.
Hi, I would like to know how I would update my model daily with my Flat Files that I have. i have created the actions and placed them on a Dashboard, but need to know how I would update theses files daily and run the actions? Thank you
Let end user add multiple items to a list
Hello, The organizational list of my business in Anaplan need to be updated every week, because there is a lot of new client. One end-user need to have the possibility to add several items in the same time in this list. I created a form to let this user add item to the list but the user can only add one item , and this…
Import Mappings: "FY" added to line item name
Hi community, I have a source module with a year time scale. When I try to do an import from this module, Anaplan adds "FY21" before every line item. Why is this and how can I get rid of it? The "FY21" comes from the current month setting which means that when the year changes, this mapping breaks. I find this extremely…
Current page filters and sorts are applied to all pages of multi-page exports
This item has been identified as an outstanding known issue. Issue Setting a current page filter or sort and then exporting this data to file, will apply the current page filter/sort to all pages of the data. Workaround Remove all filters/sorts, export the data, and apply the filters/sorts in Excel --- Internal Reference:…
Can We Import /Export Files from Windows with SSO Credentials ?
Dear Experts , Could you please Assist me with my query , Actually i have received SSO for Anaplan System Access . Can I import/Export the Files from Windows? or do i Need Basic or CA authentication as a prerequisites. Also i am not having Model Builder / Workspace Administrator role. I would really appreciate for your…
Action Button to Trigger Outbound Requests (GET, POST etc.)
It would be great to have a button on new ux available that could be configured to send an outbound request to an external endpoint (GET, POST etc.), for now even an empty request could be helpful, but bonus points for allowing a configurable payload within Anaplan. This would allow us to seamlessly execute external parts…

Importing and Exporting Data

Discussion List