Data Integration

CloudWorks Integration Limits
Hello, I am very new to data integration and trying to start explore this subject thanks to CloudWorks. On the CloudWorks Anapedia page, it is mentioned that it is only possible to have 25 integrations per Tenant. I am not sure what it does actually mean. Does it mean that one tenant can only use 25 import/export "Actions"…
Actions
How to add the Import Volume Growth Rates Action to the Process.
Model-to-model import in Cloudworks - now available!
Putting Anaplan data integration in the hands of the end users - no additional need for extra IT resource? Yes - Cloudworks model-to-model import is now available! Take a look at the information in the link and any questions, please just contact your BP. Don't forget this will require the Integration Admin role to be set…
Level 2 Sprint 1 Activity 1.3.4
Hello guys, I'm having trouble completing activity 1.3.4. I think that I'm supposed to refer to SYS05 for the region code when importing the parent to SYS06. Below is the capture of my mapping. After running the import, the "Region" line item on SYS06 is still empty. Your tips would be much appreciated. Thank you
Finditem Fails to Detect Valid List Member
Hi Anaplan, I've come across something strange and wanted to ask if anyone has any ideas what is going on or if this is a bug. I am creating a List using a Saved View that contains a list of codes (text) to be added to a list. The import action is set to use code only, and the source codes are imported into both Name and…
Force the API cell read to include Row Header Labels.
When using the data read API, any row dimensions do not have headers. This is an option in the Export tab when using the UI. When trying to process the results via code, I have run into issues a few times where this is a problem. Please consider always including the row label headers or at a minimum provide a setting to…
KTLO activities and innovations within Anaplan
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to enhance the platform performance and drive more impact to our client. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
Running a process results in The uploaded file is no longer available; please upload the file again
Hello, I am trying to run a process by ID after I upload a file via API. I get the error "The uploaded file is no longer available; please upload the file again" The file uploads and there are no issues, I can see the data in the console. When I upload the file via API, I see the file is set to "This file is not shared…
New features for Bundling Actions.
Are there any new features recently released that can be helpful in streamlining various actions into a process other than the usual way a model builder does it?
Export module with comma as decimal separator
Requesting an enhancement to be able to export to file with comma's as the decimal delimiter. At the minute the export is not using the Number format options of the line items. So if I set my line item format to have Comma as the decimal separator, the export ignores it. If there's an Import option to do this, shouldn't…
Run multiple 'Delete Actions' at once
There should be an option to run multiple delete actions at once under the Actions tab. PROS: Time Save Faster execution (Extra space)
How to convert flat data into monthly - GL example
Confused on how to work with this flat data and derive monthly values from it. Appreciate the help! Each row is a unique combo of Account (GBAID), Ledger Type (GBLT) and Year (GBFY). The snippet attached is 4 entries for the same account and ledger type for 4 different years. GBAN01-12 are entries by month. For example,…
Delete items of list with no parents
Hello all, I'm trying to delete items of a list that are not linked to a parent. Therefore i cannot use "the delete from list using selection" action. Do you have any tips to achieve that ? The list is quite huge so it's difficult to do this clean-up manually. Thanks for your help, Maxime
Allow for more control around duplicating, adjusting, and managing Exports
Imagine you need to update an export with a new column, but you want to retain the previous export for another group. In order to create this new use case, you now have to create an entire new export OR you have to inform the other team that you are adding in additional columns (even if you are allowed). Once you do fix…
Creating custom codes best practices
What are the Creating custom codes best practices. I cannot find in custom codes creation video please.
Import using Python api insert not happening only update
Hello Team, I am trying to import csv data into Anaplan using API 2. but whenever I import new data is not being inserted old values are being updated correctly. When I import new data using browser it works perfect. dataFile = open(data.csv, 'r').read().encode('utf-8') fileUpload = requests.put(uploadURL =…
Level 2 FP&A Build Guide for lost Level 1 Model
Hi All, I just completed the level 2 sprint 3 exam and I need to rebuild the level 1 FP&A model. I followed the given instructions, Level+2+FP&A+Build+instructions.pdf (anaplanenablement.s3.amazonaws.com) however I'm running into a few issues... I built my P3 SKU list and the DAT02 SKU Volumes Module in the FP&A model, but…
Anaplan Mulesoft Connector v3 - Please specify the following parameters: -mappingproperty Period:?
Hello All, I am using a v3.1.0 connector for Mulesoft integration and trying to invoke an import action. The metadata for the import action shows that it is a type: MODEL. { "meta": { "schema": "https://api.anaplan.com/2/0/models/<modelId>/objects/importMetadata" }, "status": { "code": 200, "message": "Success" },…
latest excel add-in - are there any. security risks?
My client is going to use the latest excel add-in, and they are asking if there are any security risks. Does anyone know?
Execute Import Action from Source Model
Currently, the import action needs to be defined and executed on the destination model. (Import by "Pull") Though the authority of the destination model should be set, it will be useful to execute the import action from the import source model. The improvement will be helpful to enable freely set the action execution…
IMPORT failing - Not sure WHY?
Hi All, I am unsure why the Import is failing whilst import into dimensioned / non-dimensioned module.. Import snippet: 1st & 3rd columns are List Item Property Whilst Import it is failing due to duplicate values: The final output in module is the consolidated values of all number types.. Screenprint from BluePrint (not…
Anaplan SSL wrong version number issue in Import action
Hello Team, I have Pyhton code that connects to Anaplan using API 2.0 and import data.I am using proxy server to connect. This was working fine until yesterday we found below error from my application. Error occurred:- Exception method name:- auth_request exception details:- HTTPSConnectionPool(host='auth.anaplan.com',…
Automatically Open Model
We have multiple models that take a significant amount of time to open the first time. I am hoping to find a way to use a tool to schedule a model to open at say 8 AM every weekday. That way executives opening for the first time will have a reduced wait time. Anyone had any success doing something similar? What did you use?
Linking Line item to List
Hello folks, I am new to anaplan and stucked at one small requirement. We are having two modules i.e. Module 1 - Product segment (Defined in List for different products) with transportation cost line item and Module 2 - Transportation cost for Each segment in line items (input). Need to know how can i link the…
Level1 7.2.3 Activity mport Data into Employee Details Module
I'm processing Level1 training and I can't understand how to deal with "7.2.3 Activity mport Data into Employee Details Module" . Could you tell me how to set the Mapping tab (Source) also #E2 Employees Tab ?
Formula to get a Line Item formatted as a List based on a Trimmed data field
I am importing data with a field that has the names trimmed from a list. What formula can I use so that that rediscovered name corresponds to the name of the list in Anaplan?. Let me try to show this example: Data TXT File: Crititcal Line Abrev Field:AllocCrediDirecFixed Anaplan List: Critical Line List:AllocationsCredit…
Microsoft Excel Add-in 4.2 Issue on Data in Excel
Hello, I hope you're doing well... I just have a quick question on Anaplan MS Excel Add-in 4.2. Situation: 1. In Anaplan, I set up a workflow such that, when the data is submitted, the data will turn from blue to black, which means cannot be edited anymore. 2. When I set up a connection in Excel Add-in, those cells that…
Powerpoint Addin Chart Types
Can we update the Powerpoint Addin to support all of the available charts that are available in the latest version of Powerpoint such as the Waterfall chart as an example. Since it is a case of providing data in the correct format for the underlying Excel spreadsheet that PPT uses as the basis of the chart this should be…
Powerpoint Addin Integration with New UX
For the Powerpoint Addin I would the ability to be able to import Cards and or Pages into the Powerpoint Addin. This will enable me to replicate the views available in the New UX into Powerpoint for those users who would not necessarily have access to Anaplan. The import process should create a dynamic link so that the…
Anaplan connect Model to Model import
Hello All, I am looking at the Anaplan Connect documentation and I see the section Model-to-Model import which mentions the option to import from list and module. How about importing from SAVED VIEW. In cases where we want to import only certain items via view, how would we use Anaplan Connect to import. Also, the document…

Data Integration

Discussion List