-
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…
-
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?
-
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.
-
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?
-
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…
-
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…