-
Refresh function in Excel Add in should provide option to Select all or Unselect all Worksheets
Hi, I am keen to have a button to select all or unselect all when refreshing multiple worksheets in excel. Any thoughts? Thanks Jerald
-
How to make a numbered list to populate another numbered list increasing its size?
Hi everyone, Anyone knows how to submit data from a numbered list to another numbered list (with the same dimensions) by adding lines to that other list? Both lists are numbered because their items have no identifiers such as code or name. The idea is to have an initial list that is blank that users fill out, and once…
-
Hey, How can i Autogenerate Codes in a Non-Numbered list?
-
Update Formula's Automatically
Hi All, Is there anyway by which formula's can be directly imported in a module for a line item? The blueprint view import option does allow to import a new line with a parent and a code from a file or any other module but is there anyway that the formula's also get updated automatically from another module or a csv file?…
-
"Line Item identifier(s) were not mapped and ignored" during data import
Hello! I am running an import from saved view into a model and I am facing this notification - it is not an error, but at the same time nothing gets imported because of it. Weird thing that this line item was indeed mapped and it was mapped automatically. Any idea what could be wrong here? Thank you!
-
Errors while running process.
Hi, I'm getting below error while running for all process in the model which were running correctly till last week, each process involves imports from multiple models(1 -5), what can be reason for this error? what is workaround? error -> Error Message : "localMessageText": "Import connector: Failed to retrieve data from…
-
Informatica - Export to Flat File
Hello, I have built a Mapping Task in Informatica to run an Anaplan action that yields a flat file export to a specific target. The process works well. The only question I have is that when selecting target formatting options, Anaplan suggests that you select Double Quotes as a text qualifier. The problem then is that all…
-
[Part 2] Script example: Leveraging the SCIM API to bulk remove users
* Prerequisites * Getting started * High level process * Recommended usage * Script walkthrough * Section 1: Libraries * Section 2: Logging configuration * Section 3: SCIM API configuration * Section 4: Authentication * Section 5: Parse CSV file containing Users * Section 6: Call the SCIM to perform the selected operations…
-
Excel Add-in Saved Views / Formulas and Filters
Hello all, I have recently discovered Excel Add-in existence. I had a lot of questions but current trainings (or at least the ones i watched) do not provide answers. First, I would like end-users to have only permission to retrieve saved views in order to prevent them to see technical items (not relevant as end-user). Is…
-
Invoking Informatica jobs from within Anaplan on a button click
Hello, We have a bunch of Informatica Integration jobs that receive data from other systems like Salesforce and generate csv files to be loaded into Anaplan. We use Anplan Connect (Anaplan_Client.bat) to invoke the actions to load the files. These jobs are scheduled via informatica and few of them are through Windows…
-
Noob question
Hi Guys, I am trying to map the price by SKU from another module but unable to. Not sure where i did wrong. Pls help!
-
Error Message when loading into a List
Hi, Could you please explain what this error message implies? I believe that it is saying that it rejected the duplicated in that column of data that I loaded into the List, is this correct? Thank you
-
Remove Column Headers when exporting
Hello! I would like to export a csv without column headers. I was able to remove the display name, but I can't find a solution for column headers. Can you help me out? Thank you
-
Community perspective: Using Anaplan APIs with R
R offers different ways to consume the REST APIs. This article aims to provide a foundation to use Anaplan APIs with R. This article assumes you have installed R or RStudio IDE. To work with APIs in R, we need to install and load R packages. These packages contain functions that facilitate HTTP requests, manipulate and…
-
Import special characters
Hi When I am importing "ñ"(alphabet with special character) into text formatted line item through csv file, it is taking as "ñ". But I need "ñ". Could anyone please help me on this. Regards Shirisha.
-
Level 10-2-5 Boolean not showing the check box
Hello, can anyone help me with this please? I do not know why Boolean doesnt show the check box after importing data (please see a screenshot) I have been struggling with this for a long time. Any help will be greatly appreciated!
-
Export Issue
When I'm trying to Export a file from the Anaplan model in .xml format I'm getting an error message like below:- But when I'm trying to export the same file via CSV format, the row count is below 700. But previously the mentioned file was able to download in excel format without any issue. Can anyone suggest what will be…
-
Unable to export view to Excel
Hi All, I am currently unable to export a view from an app page to Excel. When I select this option the screen goes blank and nothing happens. This feels like a bug but could there be a setting needs to be updated to enable this as I am able to export to a csv.
-
Export Button based export filters Error
Hi, I manage a model that has export filters at the bottom of the dashboards. There are multiple dashboards. They are the same export filters; Version, year, and department. There is also an export button to export based on the export filter selections. The export buttons were working a few days ago and today we are…
-
Inserting multiple list elements using an action
Hello, I was wondering if you could help me with a problem I am having. I have a numbered list A where the user would like to insert some elements without using the 'Insert' option, but instead by an action. Before, the user inserts the desired number of elements of the list A from 1 to 1000, as it is a numbered list,…