Data Integration

Trouble importing System module to Numbered List
Hi, I'm trying to import a system module containing flat list dimensions (store, product) containing line items that combines store and product code into a combined numbered list that up until now only have stores in it. When running the import I get below failure messages although import was completed: * Another row has…
Ability to reorder multiple list items or reorder a list by its code numerically or alphabetically
Some of the master data lists within our model is based on numerical codes. New list items get added to the list at the bottom and we would have to manually reorder it to the top using the 'Move...' functionality. Using this, we are only able to reorder one list item at a time, which can take a significant amount of time…
Calculation
Thanks community friends for your kind help. I am stuck in a step. Need your suggestions. I don't want the percentage to add up but remain the same (ie 5%).
Calculation help
Dear Members, I need only these parent values. Which will be the easiest way to do it?
Deployed Mode - Bulk update of Source model name (M-M Import actions)
Hi Team, Current Scenario: In the Deployed Mode, for the Production Data checked Import Actions (Model to Model), we have to manually update the Source Model name one by one. Suggested Change: Select Multiple rows of Import Actions and update the Source Model name at one go for the selected ones. Thanks Sathya
Excel Add-Ins with password protected spreadsheets
Hi, does anyone know if there are any workarounds when using the Excel Add-In, if you want to password protect your spreadsheet? We have an end user who wants to do this, but is getting error messages when the spreadsheet is password protected (fine when he takes the password protection out). Thanks, Andrew.
Efficient way for handling large parent child hierarchies
Hi, I am looking for an efficient way to handle undetermined parent-child hierarchies coming from an ERP system. This is the challenge: I have about 35 local cost center hierarchies from different ERP systems, all with different number of levels, and extracted with parent-child-IDs. How can I bring this efficiently to…
REST API
Hello All, I need to discuss regarding RESTful API for accessing oracle database tables. API was created using Oracle Rest Data Services (rest data enable at SQL developer). I am getting error : 401 unauthorized while doing query through post man as below: GET http://localhost:8080/ords/autodemo2/metadata-catalog/ However…
Data Import
Hey when importing data for SYS08 employ i nfo I am unsure as to by employees are being linked to departments any help?
Dashboard filtering selection
Kindly let me know, is it possible to restrict view access by filtering.
Level 1 Model Building : Question on DATA01 Module
This question concerns part 11 of the Level 1 Model Building in Activity "Create a profit and loss model". I have a big import problem for the P&L+Actuals+&+Budget.csv because beyond the Actual,UK,Utilities line, nothing goes beyond that in the import (i.e. 2/3 of the data is missing in the import). I checked the validity…
SYS06 Data Import
Hey I am trying to complete level one module data importing for product details and am encountering problems. I think it might be size but I don't know where to match. Can someone help? Here are some screenshots.
Information for Line Item Referenced By Actions
It will be helpful to have information for any line items that are used or mapped in actions either in list or line items mapping tabs. This will prevent deleting them accidentally when performing a model cleanup
Anaplan colnnect: action not found
Hi, We use Anaplan Connect 1.4.2 to automaticly do some imports (SQL/Anaplan) and lauch some actions (imports between two Anaplan modules) every night. We have no problem with SQL/Anaplan imports, but this process doesn't work for actions between 2 modules. This message appears when the system tries to do an action:…
Totals remove.
Hi Friends, Is it possible to remove the totals. I didn't select any top-level. I want to look it as below.
Review Import
Referring to someone else model on how the import was done to confirm the mapping - is it possible when you pick up a random model to review how the import was done?
What is this error? Error during uploading a file
Hi experts, I'm encountering an error while uplaoding a TSV file for import source data. The error window says "invalid END header (Bad central directory offset )" Could someone give solution to this?
Export Action Dialogue NUX
Please can the full export action dialogue be added to the NUX when exporting from worksheets? Currently, users only have the option to edit the export file format (e.g. .xlsx, .csv, .txt). Would be great if users had the full array of options as shown below, without setting up a custom action.
Level 1 Model Building - Importing Data
Hi In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, 1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) still have to be defined in the import file. 2) the mapping for the parent (Product Family) still…
Level 1 Model Building - Importing Data
Hi In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, the following still need to be defined: 1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) in the import file. 2) the mapping for the parent (Product…
Unable to map module /csv
Hello Everyone, I am trying to import a csv file in my module but having troubles with the mapping for one of the columns when I tried to do "Match on names or codes" all the items are ignored and when I tried to map manually it doesnt allows to pick any value from the target items. Please see below screenshots for…
Data Quality/Integrity Checks within Connected Planning Environment
Hi All, In thinking and implemented a Connected Planning environment, where we have specific models for specific areas our finance team that are brought together. We currently have a number shared hierarchies (across cost/profit centre, GL), shared data (TB, Subledger etc) and currently handled via the data hub as the…
Run multiple actions from selection in Actions panel
Would be great if you could run multiple actions from the actions panel based on your selection. For example, if you selected two import actions and hit Run, Anaplan would run those two actions as though they were in a process. This would greatly help model builders test actions where creating a process is not needed. The…
Error in List
This is the original list. This is my new List.
multiple import action within same module
Hi, I created a module with a dimension of 3 custom version ( Current version, previous version,delete version ) since I need to retain the original values entered on a specific period and I need to delete data entered in the current version after copying the data in the previous version.. After creating the import action…
Excel Add-in to highlight header mismatch if user changes it by mistake
Once we import a view in excel using excel add-in and let's say there are 4 rows in the view City-A City-B City-C City-D Keeping the order same, if the user renames City-A to City-ABC by mistake and then tries to push data to Anaplan then instead of showing no changes, Anaplan should show header mismatch. This can further…
Excel Add-in Data sync to generate Log in Anaplan History
Anaplan to generate detailed log of Excel add-in sync in history. A cell level change log as we see for any Anaplan cell in any of the modules.Ex: 1. Value of one cell in excel add-in got change from 1000 to 80. 2. We do refresh and sync data. 3. Anaplan generates a log in history for this line item value against that cell…
API
Hi Team, 1. What is API In Anaplan? 2. How to configure API and can you please explain step by step. Regards, Mahesh
Memorialize Actual Data in Historical Planned Versions
Hello, I am currently running into an issue with one of my models where historical plans are changing due to actual restatements. I have a model with 4 versions. Actual, Budget, Working, and Current Forecast. Working is where all of the planning is done, and then that version is copied from working to current…
Formula to display values from the page selector in a column
Hi, I need to be able to display the page selector value in a column. The purpose of the module is to assign multiple positions to an order. If it had been the other way around (assign an order to position) I could have used an "assign" action, but, now he task is to do it this way. I need the order column to display the…

Data Integration

Discussion List