-
how to load data into sub-products in line items.
Hi All, i am facing a small issue while loading actual data into line items. we have two products category. Products L1 Examples : TR,TW,UC.,,, Sub Products L2 TR_M, TR_Q, TR_HY, TW_M, UC_M .,,,,, Data file contains both products and sub-products can any one help me solve this. i am loading data via list to module. getting…
-
Numbered List import issue while using 'Combination of Properties' with "Month" as unique identifier
Use Case and Workaround: I am trying to import data into numbered list using "Combination of Properties" option. The catch is, my only unique identifier is "Month". I have records for a GL Account by Cost Center by Product and by Location. And will have same combination coming in as Trial Balance records but for different…
-
Saved View in Import
Hi, I just want to clarify something. Please see attachment. Regards,
-
Code for Numbered list
When I want to create member(s) in a Numbered list, I can create it by inserting in the list (without having to mention a code) or through 'Create' action without having to specify a code at the time of creation. Why does an import action into a numbered list needs a code or combination of property for creating list…
-
Saving changes to selections on a Dashboard
On a dashboard, you may want to hide or show additional rows or columns. If you make any changes to your selections, and close the dashboard, your changes will be lost. In order to save changes to selections, you can go into Page Selector Options, uncheck the 'Show module name' button and click 'OK'. Then go back in to…
-
Import Error
Hi, Please see attachment for details on issue. Regards,
-
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