Data Integration

Selective Import
In Anaplan we have. Now we want to maintain monthly data appending. This works fine. Next I find the old actual data for some records was incorrectly entered. I update it in the Hub but it doesn't get reflected in automatic process, as it takes the old values. I don't want to select the other option as my old data might…
Retrieve information from subsidiary view to use in a Boolean
Hi, I need to retrieve information from a subsidiary view and use in logic in another Boolean formatted line item. I want to see which account is unassigned during a given point in time. I already had a subsidiary this by month. I needed to see it with a yearly time scale as well so I created the view below with time scale…
Anaplan error 404 when importing to Anaplan
Hello, I have error when importing data to Anaplan using new CA certificate and version 1.4.1. This command working in Anaplan connect 1.3.3.3 java -d64 -Xmx48m -Dhttps.proxyHost=XXX -Dhttps.proxyPort=8080 -jar "XXX\anaplan-connect-1-3-3-3.jar" -c "XXX\xxx.cer" -workspace "XXX" -model "XXX" -file "XXX.txt" -put "XXX.txt"…
Series of Action (Process)
Hi Friends, I want to know, I have 6 Modules. Mod1 data flows to Mod2----> Finally Mod6. Now can I create any Action to automate the full process?
Anaplan connector 1.4.3 not giving output
Hi Guys, We are upgrading the anaplan connector to v1.4.3. We are using a .net application to consume the connector and import data. We are having 80+ lists to be imported everyday and the .net program used to pick one by one and import the data to anaplan. Based on the output, we are considering the data is load…
Very urgent ---- Formula assistance needed
Module 1: I have a Transaction List and the Employees responsible for the Sales. Module 2: These are 3 types of Cars of different cities Commission percentage. Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.…
'Upload File Not Available' Errors / Default File Setting for Deployed Models
We have occasionally experienced failures in import actions (on deployed models) called via Anaplan Connect with the error ‘Upload file no longer available’. Our understanding is the default file should to be specified as ‘admin’ instead of ‘private’. This setting can’t be changed via API call, so we updated the mappings…
rename the filename of a file before export
Hi Community, I have a module in which I created 2 saved views in order to have 2 different export actions (1 for region A and 1 for region B) . I saved the export definition and used Export name: forecast_A for the first export and forecast_B for the second export. In the actions overview, I see those 2 different export…
Filtering Import
This is my Original Module. Now I want to create a New Module which will have only Orange Data. But I can't use Lookup, as I have restrictions of Formula Linking. Only thing I can do is Import. Is there any way to do it? Need your support.
Data Pulling into Target Module
Hi Friends, I can't populate directly from list but need to populate the values from Module 1. I was trying with LookUp but it throwing error mentioning 'List does not have a built-in top level'. Please help. I am learning on my own and none to ask assistance.
Dashboard for beginners
Hi Friends, I want to learn how to create a filter list item in a Dashboard. Such that if that list item is selected, automatically the associated modules displays only that values. Any link will be helpful.
Month Formula
Hi Friends, I have a list of Fruits and the month that is sold. Now someone has entered the month in TEXT format 1,2,3,..., 11,12. I want it to be Jan, Feb, Mar,...,Nov, Dec. Writing IF-ELSE is a tedious one. I was trying it in that way. Can you please highlight some easy way.
What is a Source Module?
Hi Friends, Please tell me, when do we need to build a Source Module?
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?

Data Integration

Discussion List