Data Integration

Production data column in import actions
What causes production data value in the Import Actions view to populate ? Also does it work only when model is in deployed mode ?
How to add a header name in module grid view
Hi Experts, I want to know how to add a header name in module grid view. As shown in the red circle in the picture. Or, I want to export this spreadsheet, so header name only in export is also welcomed. thanks in advance. Regards, Tsuyoshi
Importing Data into Parent Elements with breakback enabled
Hi I would like to know whether it would be possible to import data into a line item against parent elements of the list which has break-back enabled. I have tried doing the same but can't find any way to map Parent Elements. Attaching screenshots for reference.
Multiple Import Actions - Same Source & Target
Hi, I wish to create 2 import Actions where it is utilising the same Source Object & Target Object but there is only 1 action (which is the last upload) and hence I need to re-map etc when I wish to perform the latter Action The Source Object is a CSV file and which contains multiple columns. The Line-Item mapping on 1…
External reference of source Model while Importing model from One workspace to another workspace
Hi, I am importing a model from x workspace to y workspace. The import is successfully done. But the issue I am facing is that in the imported model of y workspace, I see that in Actions>>Import Data Source>>Source Model column there are references of source model (i.e. x workspace) for Module, List and Saved View source…
Informatica Power Center - Anaplan Integration
Hi All, I have a requirement to integrate Anaplan with Source system Database using Informatica Power Center. Power Center does not have an Anaplan Connector to establish a straightforward connection with Anaplan. There is an option to use the HTTP Transformation in Power Center to call the Anaplan Rest API. Can anyone…
Error when importing .csv data
Dear all, When importing price information (.csv file), it appears in Anaplan as a multiple of 1000. e.g: a unit price of 42.99 in my csv file is imported in anaplan as 4,299.00 As anyone ever experienced the same issue? Best
Consolidated Module (with list output type to combine)
Hi, I have 3 modules, all sharing the same dimensions (period, transaction# and employee list). The first 2 modules contains line item "metric" both with output type list (same list), I need to see all the data in all line items of module 1 and module 2 - it should be consolidated in module 3. In module 3, it has the same…
How to relate items to list
Hi experts I have problem in importing data. The picture is sample of failure. I want to relate specific employee under regions. How to do this in 1 step? thanks in advance. tsuyoshi
Error when importing to a module with new line items
Hi, We have some intermittent issues with import actions that give up the following error (in pic) The target module had a new line item introduced which was on a subset of the same list as the entire module. The module was based on Subset 1 (applies to). The new line item was based on Subset 2 (applies to). Subset 1 and…
End-user file import from a dashboard
Hi all, Just wanted to confirm if end users can use the data/import function via the little drop down arrow next to the module name on a dashboard? I am currently getting an error message and I am not sure what i need to "switch on" or assign for the end user to be able to run an import. I know that often an import button…
Connect to SQL server
Good day I have an SQL server as source of my data. What are my options to import this data to Anaplan? Thank you! Renier
Docusign Writeback comment feature
A feature to allow the employee to write a comment back to the manager or template sender. So it is about a write back feature to anaplan, but not of a mapped line item rather it is a comment.
Upload modules into new model new workspace
Hello Mates, I have exported (csv) my 10 modules from my model 1. This model 1 is in workspace 1. Now i want to copy/.upload all these 10 modules (with formula, format, summary..etc..) in different model which is in different workspace. But there is no import option available. Simply, i want to replicate my work in…
How to relate sub-region under regions
Hi Experts, I have problem in importing data again. Could you tell me how to map data Sub-Regions under Regions? For example NOAM > US North > Anderson, Janet Kindly see what is expected and what it is now in my screen. thanks in advance. Regards, Tsuyoshi <<What is expected>> <<This is my screen now>>
What are the settings for Exporting a Dashboard as PDF?
There is a dashboard which I want to export as PDF. But the exported PDF is very different from what I see on the dashboard. Please help me with this Dashboard ViewExported PDF View
Format of export data (ISO-8859-1 or UTF-8)
Hi Product team, What is the format of data when exported as .CSV or .TXT? Is it ISO-8859-1 or UTF-8. What I have seen is if the module is English only it outputs as ISO-8859-1 and if the module is Chinese, output is UTF-8. Can we have some clarity on this please? Thanks in advance. -Regimon Sebastian
Smart Sheet Add-In
Hi Anaplan, It would be great if Anaplan developed a Smart Sheet Add-In. This is a great alternative to presenting data in excel due to browser based flexibility and functionality of Smart Sheet. Thanks, Usman
Date Format conversion
I have a module in Anaplan whose one line item is date formatted. I imported a csv file which is having a date column with the format MM-DD-YYYY. The import results showed a failed report becasue it accepts date format as MM/DD/YYYY. Is there any way to map my csv file having the abovementioned format with the date…
Import of partial list
Hi All, Is there any way i can import a part of list into a model from a huge list from another model?
Can't upload the parent under partner list
Can't upload the parent under partner list
Get list of all models in workspace.
Is it possible to get list of models from workspace using Anaplan Connect? When I use Anaplan Connect, I have to use model ID. I want to download all models with model names and Ids. Customer will choose Anaplan model name in his app, I will download all models and I will get Id, I will send Id to Anaplan.
Ranking on data Loads
Hi, Please see attachment for details. Thanks in advance. Regards,
Parent Child Mapping Error
Hi, I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify those combinations in a staging module for error check in anaplan.
Option to insert action before or after
Currently when I create an actions from within the Actions tab I only have the option to add this at the Start or End of the list of actions. It would be very useful to be able to select an existing action and use the 'Before' or 'After' functionality that exists when creating module or lists. This would save a lot of time…
Importing a spreadsheet into a blueprint view: ability to map to column headers
An awesome function that's so close to being functional is importing a spreadsheet or another module/view into a blueprint view. Right now, unless I'm doing something wrong, I can only map things to Line Item, Code, and Parent. It would be awesome to be able to map everything that's in the Blueprint view column headers and…
Fully connected planning for contact centres
Contact centres regularly use expensive workforce management solutions that are inflexible and difficult to work with. These solutions focus on managing call handler schedules (ie what they're doing at each point in the day) against customer fulfilment (how quickly they're getting to support that customer). These solutions…
how to do variance in list items.
Hi All, how to get the values form one module to another module in list items using subtracting function. Please find the attached Screenshots list items formula given bellow: Base-Base Base- Simulation 1 Base-Simulation 2 we have using bellow formula IF ITEM(Snapshot Versions) = Snapshot Versions.Base THEN 'TW28: What If…
Read access and write access driver query.
Hi, I used read access driver and write access for a line item to get the dynamic cell access. (calculation formula is used to get the data for this line item) . 1)It is not working though I used DAC concept 2)Quaterly data is also not displaying for that line item though I changed summary items to ALL or ANY from None.
Make Existing List a Parent of another Existing List
I have two lists that already exist. The first list has items that are a concatenation of employee, role, and project. The second list is just the projects. There is a module that has the following items (in addition to others): * Text format: concatenation of employee, role, and project * List format: concatenation of…

Data Integration

Discussion List