-
User-friendly way to override a formula in a line item allowing to edit the cell
Hi everyone, I was wondering if there was a way to make it possible to edit the values of a line item that has a formula. The most obvious way and that is taught in the Model Builder training is to do an override. To do that you create 3 line items: * One with the value you want to override with. * A boolean that indicates…
-
Anaplan Cloudworks - Azure Blob Storage Integration
Hi All, I am trying integration via Cloudworks to import csv files from Azure Blob Storage. As per Anaplan Documentations, its just mentioned Azure Blob storage. Is it the ADLS2 Gen 2 Blob storage or normal azure blob storage which is required for Cloudworks integration. Thanks
-
Combining Data in two different Modules
Hi, I have LI's from one Data Module that I need in another Data Module that doesn't share the same dimensions. The common mapping I would use would be BB Contract ID. What would be the best way to go about this? Target Module Source Module Thank you
-
Versions
Hi community, While building a model I came up with some questions regarding versions. In my model I have some values that I refer to as "actuals" and I want to be able to import them monthly. And all the other modules that I previously built should update their values, with this I mean: the past values should remain the…
-
Action Time-Out on Importing Numbered list security into Users > Selective Access
Hello all, I am building security actions and processes. I have a number of lists with selective access. My imports on non-numbered lists all work fine with the import line items formatting as the lists. One of my lists that has selective access is a numbered list. Instead of the import line items being the list, I have…
-
What is the difference between Modules and views. can multiple views creation possible in a module?
3.) What is the difference between Modules and views. is it possible to create multiple views for one module.
-
Is it possible to Retrieve cell data based on Task Id/Job Id.
2.) Is it possible to Retrieve cell data based on Task Id/Job Id. Retrieve cell data API - /workspaces/{workspaceID}/models/{modelId}/views/{viewId}/data?format=v1
-
Do we have any option to get the JSON format response using Get chunk data API ?
1.) Get chunk data API is returning the response as an application/octet-stream format, we have any option to get the JSON format response using this API ? Get chunk data API - /workspaces/{workspaceID}/models/{modelID}/files/{fileID}/chunks/{chunkID}
-
Help figuring out Data Import into List Action
Hi, I have a Action that was not set up by myself and trying to figure out how the Action is working. How I'm interpreting the Action is that it populates the List by Puling LI's from a module called D02a. But that module is dimensioned by the List so I would think that List would have to be populated first. So I need help…
-
Anplan import job log file in CloudWorks integration
Hi All, I have created a integration task in Anaplan CloudWorks using Anaplan import action. I am not able to get log / error log file (in case import action ignore rows due to duplicity). Is the any way to get error log / log file on email from CloudWorks Anaplan import integration task ? OR How to get error log / log…
-
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…
-
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!