Data Integration

Level 3 Sprint 1 Import
Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file. I am struggling with the import mapping "Time" and "Baseline Financial Forecast" portion. I keep getting failed errors regarding date format…
Stale Module Data in Power BI
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credentials were validated, I selected the Export Action that I had previously created and loaded the data. Initially, all data…
ADO Access
Hi Everyone, Can anyone will help me how can i get the access for Anaplan Data Orchestrator(ADO). Regards Rakesh ****
Ability to mask or sanitize all of the Production Data within a model
I would like to be able to easily mask all Production Data within a model. Currently, this involves a lot of manual effort. For example, replacing all names with fake names, and all numbers with fake numbers. Being able to do this is useful for a couple of different purposes: * If I need to have Anaplan Support take a copy…
Use Microsoft EntraID for Azure Blobs
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Use Microsoft EntraID to connect to Anaplan and use this EntraID to connect to an Azure Blob, instead of using a SAS token. Our…
BULK COPY - How to choose the SOURCE member and the TARGET member from a page in the app?
Hello Anaplan Community! Does anyone know how to choose the SOURCE member and the TARGET member from a page in the app? Thanks in advance. #NewFeature #UX #Dashboards #BulkCopy #Data #AnaplanRelease
How to integrate Azure blob and Anaplan For transferring files
Is there way to connect azure blob and Anaplan to upload/import data can it done by rest api call or can i use custom script to call Anaplan connect import hub from azure??
Anaplan to SAP journal posting
Hi All, I am working on automating journals from Anaplan into SAP via SAP BTP/API. The API is linking to saved exports with a saved view. Journal data updates on a monthly basis but the changes in data don't get picked up by the API and instead old data gets posted into SAP. Has anyone encountered this before? Is there…
August 2021 Release and Sneak Peek at September
August 2021 Release and Sneak Peek at September Bulk Open from Table of Contents: From the Table of Contents section of New Modelling Experience (NMX) you can quickly open the objects of a particular functional area for faster access to the information that you may need. It leads to increase in productivity. Tab…
How to Automate and Retrieve Authorization Code in Anaplan OAuth API Automation using Python
Hi, I'm facing an issue with the Anaplan API integration. Currently, the authorization code retrieved manually, but we are looking for a way to automate this process as part of our integration workflow. Thanks
Workflow builder - Include or Exclude emails
Workflow Builder Enhancement It would be fantastic if you could toggle the option to include or exclude emails generated from Anaplan from the Workflow builder. I have a two step machine task process in workflow that is published to the UX. The process steps are to run an action in the workforce planning model to prepare…
Data Source or Target issue
Hi everyone, I am wondering if anyone else has encountered an issue with Data Source or Target not working correctly in CloudWorks. For some reason, the Data Source or Target list is diminished for all administrators/integrators in the Workspace. As you can see on the screenshot below, there's a list of few items and then…
4.6.7
I used the mapping column 3 family code to P2 product family column headers to parent column 1 product code to code I get the error another row has already been processed with this key and invalid name 53 failed
Data Related Training Classes
* Anaplan Connect (301) * Anaplan Data Integration Basics (303) * Creating a JAVA keystore for use with Anaplan Connect Overview This set of classes address how data is used and managed within an Anaplan model: Anaplan Connect (301) Anaplan Connect enables the Anaplan administrator to automate Anaplan imports of data and…
Microsoft Teams - Anaplan Integration
A number of customers have expressed a desire to have an Anaplan - Microsoft Teams integration in the same way as now exists between Anaplan and Slack. * Push links to pages to users' Teams accounts * Anaplan notifications * Subset of above: as Anaplan Process Orchestration progresses the need / benefit from Teams link…
[Start Here] Anaplan Connect 2.0 and JDBC Connectivity
* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Integrating with Snowflake * Integrating with Azure SQL Database * Integrating with Google Cloud (GCP) BigQuery * Integrating…
Ability to Add Data Write Action to Existing Process
1. It would be really a game changer if we are able to add Data Write Actions to the existing processes, It would not only scale up the usage of the Data Write Action but also would save a lot of time and effort and would save us from creating multiple saved views and actions. 2. Currently, Data Write actions can only…
2.3.8.2 Import into DEM01 Module All Products Growth rate
Hi, I am having problem getting the total of all products for each month and I have no idea why it is not populated. Can anyone please help on finding out why it is not populating?
Log exports in the model history
Description of the enhancement required: Customer wants to capture the export information also to be captured in the history log. Currently, only import information is available. A story for why you want the enhancement: For the customer, apart from imports that are scheduled , if a user clicks on export they want that…
Anaplan Connect - Running the proccess/imports
Hi All, I need your help regarding process or imports in anaplan connect. In the import or process when any of mapping is selected as ' ask everytime while import'. How can we complete that process or import successfully using Anaplan connect
Anaplan Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…
Update Current Timestamp by adding a New Action Type
As workspace admin, I would like to have the possibility to update the current timestamp in UTC timezone by having a New Action type created ( similar to the below picture ). This could work in a very similar way as the very nice new feature "Update Current Period": 1. Create in a module without any dimensions a line-item…
Actions Tab Improvements
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Looking to review trend Process executions and durations. How often is this impacting your users? We are currently implementing API…
How to Import from Source to Target with Different Number of Dimensions
Have you ever faced a scenario where you wanted to import the data from one module to another with different set of dimensions and you were not able to successfully achieve it? Usually such type of data movement can easily be achieved through formulae but in some cases writing formula might not be the solution, for example…
Applying one Pivot Filter to multiple cloned connections with the Excel Addin
I have one Excel workbook with multiple worksheets and I want to apply one Pivot value filter (e.g. Time - May 21) to all the worksheets. Rather than updating each individual worksheet "Time Value".... When I used reference this value across worksheets it is blown away after the refresh.
Entrust CA Certificate - Error outputting keys and certificates
Hi there guys, anyone using Entrust CA Certificates for Anaplan Data Integration? Following the recommendations from Anaplan's list of Supported Root CA Certificates, I have purchased a S/MIME certificate from Entrust and got a ".p12" certificate downloaded to my computer. When trying to export the Public Certificate…
L2 Model Building Conclusion: Failed Import into Shipping Expenses OTH01 Module
Hello Anaplan Community, I've been stuck for too long trying to import the shipping costs from my Saved View into OTH01. I've tried numerous saved views but can't seem to resolve the errors. I've deleted all Saved Views and started over because I think I am confusing myself. Below are screenshots of where I am currently…
Incorporate daylight savings in Cloudworks time zones
Now if I select London time zone in Cloudworks schedule, it will not automatically change the time in accordance with daylight savings in UK, forcing us to adjust the schedule manually. The same goes for other countries with daylight savings. It would be great, if daylight savings were added to Cloudworks schedule time…
Easily Get Current Date Using CloudWorks
Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using python for getting today's date. But this approach has some cons: * You must learn to code or involve someone who can do it.…
Dev and PROD desynced following a backup restoration
Hello Everyone, I have taken over the Workspace Administrator responsibilities within the business and I am still learning about the basic model maintenance tasks. We've had a deployed PROD model synced with a DEV model to sync any structural changes and using revision tags. Recently, I have taken a copy of a PROD model…

Data Integration

Discussion List