Data Integration

Schedule model-to-model imports in Anaplan as often as you'd like
Use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation, add-on services, or technical resources are required to use—everything you need to move data between…
Ability to change Pivot in Google Sheets Add-on
The Google Sheets add-on doesn't let us change the dimensions in the Pivot when setting up the connection, unlike the Excel add-in. We need to create custom views in the model to be able to pull the data in the format we want. This is a big deterrent towards adoption of the Google Sheets add-in and restricts the…
Issue with Anaplan Certificate and Anaplan Connector
Hello All - It is my understanding that the latest version of Anaplan REST APIs and Anaplan Connector (v 1.4, lets call this AC) requires a CA Certificate for authentication against Anaplan. As…
Is Anaplan Add-in application the same for both MS Office 32bit and 64bit?
Our Finance team is upgrading to MS suite 64bit. Is there any known incompatibility between Anaplan Add-in 4.2 and MS Suite 64bit?
Export not Utilizing Filters
Hi Anaplan Community, I am working on a dashboard that includes a module with 3 dimensions (list 1, list 2, list 3), one for each dimension. On the dashboard there is an additional a module with a single line item that is list formatted. The second module is page synchronized and works as a drop down selector for the…
Cloudworks to include all Process status just at running in Model manually
In Cloudworks, only the detailed status of failed Process/import/export is shown, the successful ones are not shown. Would be great if the details status (Updated, Ignored, Unsuccessful) will be recorded for all imports/exports run, so that users will be able to confirm if the Process has been run correctly.
Informatica Scheduled job
I have an Informatica Linear Taskflow that consists of running some exports in Anaplan (via mappings) and then moving the output files to an FTP via Informatica FileProcessor (with Filemove in a Synchornization Task). This works great, when Anaplan has data to export. The problem is that this job is scheduled to run 3…
Anaplan Excel Add-in Prerequisites
I wanted to share an uncommunicated prerequisite for the Anaplan Excel Add-in 4.x series. Reading through prerequisites, the documentation explicitly indicates certain items that are not natively part of an operating system, like the version of MS Office or the supporting technologies of .NET 4.7.2 and Visual Studio Tools…
CloudWorks–This is how we use it - Part 5: Model-to-model
If you need a reminder on CloudWorks; go here. Why we are excited With the new CloudWorks release comes a long-awaited feature: “model-to-model" (or M2M) actions. Until now, you had 2 options to automate Anaplan-to-Anaplan flows: Implement a third-party tool such as Anaplan Connect (requiring a server that can run Java) or…
Building a Chat Bot - Part 1: using AWS
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Using Anaplan APIs on AWS Cloud * Authentication * Create a role * Python Code * Examining the code * Best Practice: Information encryption * In summary What is covered in this article? First of…
Conversion to V4 - copy of older version is not made on Onedrive
To upgrade to V4, workbooks that are created in lower versions have to be converted. On conversion, a copy of the older version is supposed to be made. This works on a local drive but it does not work on OneDrive. As most of our files are on OneDrive, this will not work in our business operating environment. We will not…
Unable to open several workbooks with same connection
I have recently been testing v4 of the Add-in. We are current using v3.3. I am unable to work on several workbooks that have the same connection/model at the same time. V3.3 allows for several workbooks to be opened at the same time. I would point to several systems that allow for this, namely, Smartview (Oracle) and BW…
Excel Add-in: Clone Workbook button
Currently on the Excel Add-in I am able to clone worksheets. I would like to have the ability to clone an entire workbook or multiple copies of a single sheet rather than doing this 1 sheet at a time. Why? * Currently the Excel Add-in does not allow for copied workbooks to be opened simultaneously * This will facilitate…
Level 2 1.3.10
Hii I am not getting G3 distribution center column eventhough i created subset for Try it hierarchies I am attaching some screenshots..can anyone please reply where i am doing mistake
Ability to Connect Power Point Add in with Dashboards
It would make every end users' life easier if we have an ability to connect Power Point Add-in directly with the dashboards instead of modules. Now Reporting page coming into action, it will make a lot of sense if we could just create the connection with any page/dashboard and boom power point is ready.
API Import Error : There was an issue with your file upload: 500
We had to reset index count of a list after which we imported data using Postman into the module. Airflow DAG for the process which uploads data in the above module/list have been failing since that day when they run for the first time. However, when re-triggered they run without any errors. What will be the solution for…
Import data with source and target items differences
Hi All, I need to import some data, but the source items are different that the target items. Source items end with "_EN". What options do i have to upload this data? Thanks,
Using NUX forms can cause rollback on duplicate code input
Hi all, Our team is in the process of converting from legacy/old dashboards, to NUX and one feature that holds a lot of promise are the NUX forms (for the purposes of adding to lists). The old dashboard style made it a bit clunky for creating new list items with controls and prerequisite inputs, but the forms are…
CloudWorks Scheduling by Day of Month
It would be great if we could schedule Imports & Processes during Month End dynamically. e.g. Each Month I need to edit my schedule to update the Start Date & End Date for the relevant month end period. Would be great to have 1st day of month as a selection from Start Date and 7th day of month for End Date as an example so…
Import Enhancement: Tab- Line Items: Being able to select Multiple, All, or blank "Mapped to"
Currently when Mapping a file, view, or similar, if you have extra line items/columns, Anaplan doesn't always identify that a new line item is selected, and takes multiple attempts to have your selection identified. (Bug, and I use Chrome with 90% zoom) Being able to Map everything you are going to map, then select all…
level 2 conclusion DEM04 Demand Saved View
Does the below screenshot look correct for the DEM04 Saved View? The directions say that the product should only have a Product SKU Level. Also, are we supposed to actually export out a copy of the saved view?
Use value referenced from a diff module
Hi All, noob here, just started my Anaplan hands-on journey today. Hope you can help me 🙂 I'm looking for the right formula to get value from a module to a different module based from an existing module data. Below I have two modules. Loans and Lookup Rates In Loans module, I have two line items called Term and Rates. I'd…
Level 2 Model Building conclusion - Import
Hi, I am having some trouble importing the Shipping cost export into the OTH01 Non-Employee Expenses module. I am getting the below error. I have also provided additional screenshots. Can someone please help me on where I may be going wrong? I'm so close to finishing up Level 2. this is one of the things that is tripping…
Remove a selective access by import
@Tomishand I recently needed to have the ability to remove selective access for certain users from a selection module and a model-to-users import. The documentation on Anapedia is not very clear on the subject so I thought I’d detail the steps here. We import the code of the items to add in the Read / Write though…
Excel Add-in No Access Error
Hi, The following problem occurred : Excel Add-in does not allow me to look at the Saved Views of some modules, giving the error No Access. It is important to note, that the modules themselves are large, but there is much less data in Saved Views. Is there any solution to this problem, provided that you do not want to…
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2 While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly. why? because: It is the reason that region flat has 3 line items: AMER, EMEA, APAC. However the csv DATA file attributes the…
2.3.9.1 Import data into DAT03 Historic Volumes module
i am trying to run process 9 but i got this error can somebody please! help me
How to remove a dimension from a pivot?
Hi, Does anybody know how to remove a dimension from a Pivot? I need to remove "time" from the "Pages" (See below). Thanks Juan
Lock overwrite of snapshot
Hello, I am currently working on a scenario planning model, where I have two custom versions lists. My first list is a "modeling scenario" list, which is user editable. And once the users decide to lock their assumptions, they create a new "snapshot scenario" and run a process to copy over the data from the modeling…
CloudWorks - Possiblity to launch processes without being necessary to choose Datasource or Target
As Model Builder/ Data Integration specialist I would like to be allowed to create a Process in CloudWorks even it is not chosen a Datasource or Target. CloudWorks could be very useful tool to schedule data integrations between Anaplan models. Currently, this is not allowed and it is received the error: "Connection and…

Data Integration

Discussion List