Data Integration

Anaplan Model to Model Import with informatica
Hi, Can someone explain if it is possible to schedule an Anaplan model to model import with Informatica and where can I find references to understand how that can be achieved. Any help is appreciated. Thanks and Regards, Aakash Sachdeva
Anaplan restful api uploads with zip files
Hello, I have a question about using the Anaplan integration API V2 guide. Is it possible to upload a csv document inside a .zip file to Anaplan? I'm able to manually upload a zip file with a csv in it, which works, but cannot figure out if its possible to do it with the API. I'm trying to do this with Postman but the data…
Support commercial key stores in Anaplan Connect
Add support for commercial key stores to Anaplan Connect. In addition to the supported Java key store, include support for AWS Secrets Manager and Azure Key Vault. These could be plugin components, or just a pluggable architecture for customers to add their own code to support commercial key stores.
Control of pull-down items
こんにちは！プルダウン項目の 1 つを非表示にしたいのですが、サブセットを使用できません。また、最上位レベルは表示されたままにする必要があります。これを行う良い方法はありますか? 教えてください。
Updating Lists on Transaction Data Import
Colleagues, hi! I'm seeking your advice on the following case: on a weekly basis, there will be a transaction file with the unique "purpose of payment" texts for each transaction and potentially new suppliers that don't exist in Anaplan list yet. How can we achieve automatic update of supplier list upon import and having…
REV02 Import mapping Problem
i am trying to map Volume+Inputs file.csv data into module but Cant seem to get data map. Tried Multiple methods. But cant seem to find a way. If anybody can help then comment down. I m also attaching the problem.
Retrieving Item ID from Dimension ID (Transactional API) from model front-end
Hi, We have a current use case where we are retrieving module data for a specific object within a list, and achieving this through the use of the transactional APIs (querying the view). We have the view structured such that the dimension for the object that we want to retrieve is in the "Pages" segment of the view. This…
Python and Anaplan: Pt 1—Setting Up Your Environment
Combining a scripting language such as Python with Anaplan can provide you and your team greater flexibility and functionality in your planning journey. If you've never used Python before, or want to check out some different ways and use cases of Python and Anaplan, look no further—this series of articles will introduce…
Error with Anaplan Connect Script
Hi, I am trying to run a process with Anaplan Connect , using Java 8 and tried both anaplan connect 1.4 and anaplan connect 2 . I am getting the following error Any help would be appreciated. Thanks and Regards, Aakash Sachdeva
Mapping issues related to Activity 8.5.3
Hi, Need help in this Level 1 Model Building exercise. Though I did not get any errors after importing the data and mapping, the G3 Location Tab does not look right. Secondly, the pivot table in the line item view has to be changed. The volume needs to be before the Nutzo Bar. See mark up on Line Item screenshot (attached…
How to import a csv file into a module where the only reference is a single line item (text format)
Hi, Any idea how to import this csv file: into this module: The third column (PR Number) is in text format (8 characters truncated from the first column) and its not a list nor a parent/child of the first column (PR line). Parent of the first column (PR line) is something else i.e Material. I have nothing from Source to…
Google Sheets not working properly using Subsets
We are experiencing some strange behaviour from Google Sheets Addon when the Module uses Subsets, if the Module has a No Data formatted Line Item as the first Line Item, normally we use this as header for our Line Items inside the Modules, to confirm that I've made some tests using different combinations of Line Item…
Initialize a specific dimension using another dimension from the same module
Hello I currently have the following problem : All the modules that constitute my model are run by a dimension "3 year Planning scenarios". This dimension is a list of different planning scenarios, each one has a different year of start as a setting ( initialized in a unique administration module) . What i'd like for my…
Add Minutes to trigger frequency in Cloudworks
Suggest to add minutes to trigger frequency Currently in trigger frequency in scheduling window there is no option to select minutes, This can be extremely beneficial and can add more flexibility to scheduling tool As example 1. During active forecast and budget time data constantly needs to be imported & exported 2.…
Access multiple tenants with Tableau connector
As an Anaplan Partner / solution consultant I need to analyse regularly data from Anaplan Customers. To do this efficiently, I want to have direct access from Tableau via the Connector to multiple tenants / customers without the need of downloading large data sets to the hard drive (which in my opinion is unsecure).
CloudWorks - bumping up again - model to model import is here!
NEW FEATURE RELEASE Scheduling model-to-model imports has never been easier Model-to-model import is now available in CloudWorks! Easy to set up and ready to use, model-to-model import lets you effortlessly move data from one model to another—on the schedule that’s right for you and without relying on additional IT…
10.2.2
I am running into errors with this import please help.
Multiple import steps in a Process - merge file selection?
Using the same csv file, I want to be able to import to different modules and it will be seamingless to the users. But the "Choose File" button appears twice when I click on the button even though it's the same file I'm importing. Is there a way to show it only once? Thank you.
Export action not working
HI, I created an export button and used March period when I created the export action. Now I published the button in the dashboard. In the dashboard I selected period June and clicked the Export button. I was expecting that June period will be exported but the exported data is for March period. How do we sync the export…
Am getting an error while importing data
invalid date identifier have validaed the date formats in the file but import fails with same error
What's wrong here?
Source (Line Item Type is Number) Target (Line Item Type is Number) Import Action: Failing even after every possible mapping
Level1 exam activity 5
Hi, I am having issue on level1 exam activity 5. I have seen queries regarding this . I changed Role format text to list and given top level is All roles in the configure tab.But still showing zeros (Bonus,car costs,phone costs, medical costs).I dont know where did i the mistake.i will share my screenshots.can anyone…
Why characters get garbled via model to model imports
Hello, I hope you are all doing well and good. I have a situation here. When I upload a text file(with special characters) to Model A's list and then import the list data from Model A to Model B, characters get garbled in Model B. text file -> Model A ***text encoding: Windows-31J(MS932), Totally no problem*** Model ->…
How to link parsed list back to List codes
Hi, I've created a module that contains a list with data that has 3 components of a list concatenated (to limit the number of rows). The list data looks like this: CCCC_AAAAAA_DDD - with the C's being company code, A's being account code, and the D's being department code. I now want to have another module that references…
Pivot feature for Google add-ons
The information toolbar suggests that we pivot in Anaplan using filters and pivot feature. This is an inconvenience from the user experience perspective. If that were to be the case then we are better off creating views for everyone. Moreover, this feature that's been mentioned as information does not work as intended.…
Statistical Forecasting algorithms into a user specific model
Hi - I am new to Anaplan and I have a quick question: Let's presume we are to develop a supply chain demand planning module for a client. Since we exactly know what all lists/line items are needed along with the hierarchy and the calculation formulae for different line items, I prefer to have that developed everything from…
Optimize a parameter in statistic forecast
Hi. We are trying the Statistic forecast. In monthly model, we need to set parameters to run the statistic model. (Like Holt's α in Holt's Winters model) But this setup is manual input. Can we calculate the best parameter(0.0~1.0) by Optimize and minimize MAPE?
2.3.8.2 Import into DEM01 Module
I seem to be having an issue uploading my data into this module. The module is set to month, yet when I try to set the import period, it is in weeks: Separator can be any non-alphanumeric character Y represents year number (1, 2 or 4 digits) W represents week number in year Further, entering a custom format of YY?MMM to…
8.5.3 Activity: Different data problem
Hello all, I am working on Level 1 activity 8.5.3. I imported the file without any problem but my numbers are different from the screenshot given by the course module. Could you please help me with that? Merve
Change import default name while setting it up
It will be good to have ability to change an import name the same time when you first create the import. For example, having a special field on import setting window, like in screenshot.

Data Integration

Discussion List