-
How to do use dropdown list within the PROFILE function
Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different…
-
Specify mapping options in the rest call
Hello all, I would like to ask whether it is currently now an option or in future plans to specify mapping options when making an rest api call. For example, we could append to the basic rest api call to trigger an import action: /workspaces/{workspaceID}/models/{modelID}/imports/{importID}/ things like:…
-
IMPORT ERROR (MODEL TO MODEL)
Hi all, Anyone encountered this error? We cannot import from one model to another because this error occurs every time. Kindly see below:
-
Data Import Error - “Key for this row maps to more than one list member”
Dear Anaplanners - we have a couple of import processes that are presenting a number of Fails, with the Error_1_ message “Key for this row maps to more than one list member”. Is this an error message I need to be concerned about - as both of the lists that we are importing against we are aware are replicated to support two…
-
Error in importing CA Certificate
Hi All, We are trying to achieve CA Certificate authentication. While we followed the instructions provided in the link below https://community.anaplan.com/t5/Knowledge/A-Guide-to-CA-Certificates-in-Anaplan-Integrations/ta-p/39305#toc-hId-1363730354 , we got an import success message. But still, we don't find any file…
-
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
-
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
-
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.
-
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…