-
Pull the mapping for Imports and source for each model in a tenant
Currently, the only way to extract the information for Import and source mapping is from individual model through the Anaplan interface. These mappings are very useful to track how the data flows across different models and files. To be able to identify how the data flows using this metadata is going to help eliminate a…
-
Only allow import before certain date
Hi, Can I create logic that only allows end users to perform an Import Action if the today's date has not passed the deadline? Best regards, Johan
-
Anaplan Connect Import, ERROR: Cannot determine Java version.
Hi! This is my first time using Anaplan connect. I am running a basic authentication to execute an import list action on Windows. Below is my script: @echo off rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see doc\Anaplan Connect User…
-
Regarding Anaplan Connect Import Scripting
Dear Team , I am using Anaplan Connect on Windows server where i need to write Script for Import/export files from Windows server to Anaplan Application . My Question he as below : Let say I have 1 folder in Windows server named Import Files where ETL jobs keep the file to load into Anaplan System . So once that file is…
-
Solved! How to Get and Automate the System Date into Anaplan Using Python
Anaplan Community!! Hey, I just published a KT article in the Retail Anaplan Group that shows step by step how to get and automate the import of the system date into Anaplan using Python. Hope you like it! Cheers!
-
Import to List from Module
Hello Community! Hope you are all doing great. I am trying to import from a Module to a List, but it is not working for me. My LIST is called "Machines by Mill", and the headers in there are the name, the PARENT, the CODE and WORKCENTER: I created a module with those names within LINE ITEMS, and as input, the item that I…
-
Sample batch file for process in Anaplan Connect
Hi Community, Has anyone got any sample batch files to hand for a process that includes a number of imports? Many thanks, Callum
-
Updating data trough Excel Add in
Hi all, i have an urgent question: i'm actually trying to import a monthly cost report trough excel add in, the goal is to have a report which I can refresh every month. The problem is that I would like to exclude all the empty cells of the module/view, so during the import trough add in I can see only the full cells. Is…
-
Export is showing formulas
Hello, I have a grid in the New UX in which one column features Names that link to that persons' email (done through a MAILTO formula in the model). Unfortunately, when I export that grid into an .xlsx, the column populates in excel with the full MAILTO formula, instead of the name it should be showing. Has anyone else…
-
Export - Labels change order without Deleting and Re-entering
Real world instance: A request to either re-order, add in new columns, or update an existing export with new information. Current Solution: Clear all of the properties prior to the new column's location and re-enter all of the properties that were required to be deleted. This takes time, and is susceptible to mistakes. New…
-
Run a Process via Informatica (Delete and Insert)
I tried to "run" a process. Process runs when manually clicked in Anaplan. Process has two actions Delete table contents Import data from Data Hub I tried to set as Source : Dummy table from SQL Query (1 Column 1 row : Set = 1) Target : Desired Process (Tried Operation = Insert and Update both failed) Does not seem to…
-
Getting error when trying to load a file
Hi I am trying to load a data file into my module, using the navigation Action<Import Data Source but getting 'Unmatched Delimiter character '. Please see the screenshot of the error and the datafile. We want to keep double quote (") as the text delimiter for our data import. can you throw some light on what is the issue…
-
where or what menu that I can see the detail of PR have been submitted last quarter (Q1 - Q3) ?
where or what menu that I can see the detail of PR have been submitted last quarter (Q1 - Q3) ?
-
Excel Add-in
Hi all, for the monthly cost analysis, I would like to import a customised report via the Excel add in, so that every month I can only refresh the data. When I select the data to be imported via the add in, the system only gives me the modules and views. Should I customise a view? If I customize it, will I be able to see…
-
List Subset Definition based on formula
Is it possible to add functionality to make list subsets based on formula? Currently we have to either manually select list items to be included in subset or need an import action to update based on subset logic written somewhere else. Can we have option to add formula directly on list subset definition? This will help a…
-
Make a Line item Sign Change
Hi, I would like to know if it is possible to make a line item that I'm drawing data into from a flat file to make the numbers coming in negative. I have a Flat File where the numbers are negative on the Flat File, but need them to be positive in Anaplan (Vice Versa). How would I go about this without completely changing…
-
File download issue in running export with python API
Hi Everyone, I have been trying to run an export action and a process containing the export action using python API for Anaplan. The output shows python API running the export perfectly but no file gets downloaded. Can anyone suggest the reason for the same and if any workaround is available for this issue ? I need the…
-
Add custom Text Prompt or Dialog Box to Actions
In the new UX, I would love to have the ability to add custom text to the dialog box for imports and other actions, or add a confirmation prompt. For example, "warning: running this submit process will make all entries final and prevent further editing".
-
Azure Connector informatica
I am trying to bring data from Azure data lake to Anaplan using informatica. But I am getting this error when I create an Azure data lake V2 connection and test it. Has anyone faced similar issue in informatica? Thanks
-
Have a timestamp on when an action or process was last ran
It would be great to have Anaplan built in functionality to tell a user when an action or process was last ran. This would be extremely helpful in identifing forecast locking, data loads, etc.
-
Level 1 Model Building
In 10.2.2. we import non employee expense data but the mapping is not working and there are no ideas in the training. Any solutions would be greatly appreciated. Thanks Neil
-
Level1 exam import the SKU volume data
I imported the csv file but the mapping was not correct and all data was showed on the Jan. Although the time scale is monthly, the data isn't imported per month. Could you tell me how to fix it please?
-
Ability to export values as formatted for .CSV
As a user, I need to be able to export data in the format I have set instead of a standardised format when exporting as .CSV. For example, I want to be able to export * Large numbers - The option to export "1,000,000,000,000" rather than "1.0E12" * Small numbers - The option to export "0.00001" rather than "1.0E-5" My data…
-
'Last run' column in Settings>Actions>Imports grid
Description of the enhancement required: Imports and Import data source tabs were added with the recent Anaplan release. We would like to be able to view the date the last import is run in say another column. An example of the enhancement: Column field next to the import action that shows the date. How would it…
-
Question: Action Timestamp Obtainable in a Line Item?
Community, Does anyone know if the Action Timestamp can be shown on a page or dashboard, most likely through a line item? Or, is it just on the action tab? Can the action timestamp be retrieved with the new Transaction APIs?
-
Anaplan Level 2 Sprint 2 Lesson 2.3.9 Import Process 9
Hi I tried this process and got error messages. Now I find I have accidentally deleted the Process 9 from the Actions page. I can't see the process 9 in my Supply Chain model. Could someone help me with this please. I have provided the screen shots of my previous work with error messages. I am not sure what went wrong.…
-
SAP BW
How can we use Informatica to establish a connection from Anaplan to SAP BW server? Are there any links or tutorials for the same?
-
Leason 4.8.2 , Import data in E2 Employee
Importing and Exporting Data Hi team, Did the mapping as per my understanding making some error here, I am unable figure out the error getting numbers under the Sales and not the names of employees in sales team. Please guide me. @noelle_murphy I also tried the steps from…
-
Modelbuilding 1 question 7.2.3 importing employees
Somehow I can't get the employees imported, in SYS08 Can anyone explain how to do it, I do not know what to use as mapping. I tried this: But it returns failures on start date, leave date and other columns Then I tried manual mapping, which partly worked but still it won't fill all the columns: Does anybody have an idea…
-
Search Functionality for Import Data Source Selection
When setting up an import into a list or module, it would be useful to be able to search for a module/list/saved view when connecting to an Anaplan model on the "Select Source" section. I have a model with hundreds of modules and having to scroll through these modules every time I set up an import action can get tedious.…