-
master data list synchronization between models
Master data lists needs often be synchronized between the Data Hub and spoke models. At the moment we do this as follows (for incremental loads): In the spoke model: 1. Set the property 'in use' of all list items on FALSE 2. Load in the data from Data Hub to your spoke model (incl. the TRUE flag for 'in use' property). 3.…
-
"Show history" for list items
Currently one is able to export history in two ways: * As an admin: via setting "History" tab * Via a module. Selecting a cell or a range, one can get history for only the selected data. I propose two other ways of interracting the history logs: * Via General Lists tab: For example selecting a List and pressing "Show…
-
A way to identify import target
When a process contains several import with different input files (IDS) with targets that have long names it's impossible to distingush which file file stand for what. The screenshot below displays a situation when you can see two identical rows making it very confusing for an end user: Admin in this case may guess the…
-
Develop error when adding to a subset parent
When creating elements in a list that has a subset as parent, we can get an error because some element have the wrong parent. It would be very useful to have a more detailed error, with for example the rejected lines.
-
Data Mapping for Import failing
Dear Community, I need a help. I am trying to import import the Unit Cost and Sales Price. My file image 002 depicts desired output. Image 03 is the .csv file to be imported. But I am unsuccessful. I need help badly. Kindly guide me. I have shared screenshots for reference.
-
Import mapping should update if a line item is renamed
On a model to model, module to module import if the name of any of the below changes the import will still import into that line item as it was set up: -the target model -the source model -the target module -the source module -the target line item If: -the source line item is renamed then the import will not import that…
-
Actions
The action created for importing a .csv or text file does not save the mapping used. I can edit or view the mapping only if a module or list is imported from another module or list. Sometimes while importing a file there are possibilities the file has wrong header names and hence they are not mapped. To view the mapping…
-
How can I return the current date in line item?
How can I return the current date in a line item i.e. automatically get Anaplan to show the current date in date format so that it updates each day? Tweakbox Tweakbox Tweakbox Many thanks, iosman
-
Exporting table from DB into file with all data from table including zero data rows/columns
Hi, I have this table in a dashboard and when I export this table into an excel file, it only shows the rows that have a number > 0. See pics attached. How can i export it so that it exports the whole table, including everything that has 0? Thanks! Amanda
-
Automatic unique codes for nonumbered lists
A unique identifier is required for items in a non-numbered list. There shouldn't be an option to edit it even by administrators (analogue of #-code in numbered lists) An example of the enhancement: Add another system property called for example (system code) and make it noneditable but accessible through formulas and…
-
Introduction to Model Building Couse Guide
Hi all In the training course 102, extra line items should be created, but i cant find the guide or requirements for this. Where can I see what is include in "Sales Performance", "Sales Region Roll Up", "Company profit"...etc? thanks in advance. Tsuyoshi
-
Updation of master data and its reflection in spoke model
I performed an incremental load / full load of the master data(lists) from my Data Hub to a Spoke Model. Now, in my data hub, I renamed a list item in one of my lists and I want to update the same in my spoke model in some way without having to manually change the same in the spoke model. Is there any way to handle this…
-
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…
-
Remove "Display Name" duplication for numbered lists during export
When exporting the data from a numbered list field "Display name" is duplicated by a property that is selected as a displayed name. One of them should be removed as it adds additional clutter and confuses the customer. This would help to tidy and organize lists/number lists a lot better. Currently it's confusing for end…
-
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…
-
Import Error
Hi, Please see attachment for details on issue. Regards,
-
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:…
-
Process UI with Many Actions
When clicking a button to run a process that has several actions (20+), there should be a vertical scroll bar for the list of actions so that the UI box does not go off of the screen and a user does not have to scroll to see the Run button.
-
Add to Top of List
When automating list additions, it only allows you to add to the bottom of the list. Would be nice to be able to add to the top as well.
-
Mapping on Codes
Allow for mapping on codes in a list that is not numbered.
-
Dynamic Data Sources
Have the source model and source object name dynamically update in Import Data Sources as changes are made in the source.
-
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…