-
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
-
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…
-
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…
-
How to create multiple file ID for the same process?
My Anaplan model is connected to an outside system by API, user can accept or reject a request in a workflow in the outside system and the result is transferred to Anaplan by API, then Anaplan will refer to the result file and update the status to proved/rejected. However when multiple users run the same workflow at the…
-
Anaplan API: Could not initialise service credentials (Anaplan API: Invalid certificate-alias provid
Hi, I am testing an Anaplan Connect upgrade and am struggling to get our scripts to run. We had recently had our certificate renewed and I have refreshed the KeyStoreAlias in line with live scripts. I am getting the following error message now: "Anaplan API: Could not initialise service credentials (Anaplan API: Invalid…
-
OAuth Authentication and Anaplan Connect
Hi, I have been testing OAuth connection with Anaplan Connect. And it has been quite a struggle. I started with "Authentication - Generate OAuth Token With Force Register" and it was not really working but giving strange error messages that didn't really help. After trial and error I got the example script to work by…
-
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.…
-
Time Aggregation from Time to All Periods
Hi everyone, while working on a module containing Sales Data by Month and then referencing the same into another module containing Sales Data without Time Dimension, I noticed that Time doesn't aggregate on All Periods (which is set on Time Calendar) as other custom lists do through Top Level setup. It seems that for Time…
-
CloudWorks Failure Status Description Definitions?
We have CW jobs that are failing. These jobs do not have an error log, all we have is the Status Description on the Activity page. Is there a list of status descriptions and their meaning for CW job failures available so we can troubleshoot these failures?
-
Multiple Sheet Add in Connection
Hi everyone, I have 2 questions about excel add in Refresh Multiple Connections function: Does the refresh multiple connections functionality refresh only the dimension selected on the selector (for example July 23) of the module/excel sheet or all the data present in the module? 2. In case of many sheets connected to…
-
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…
-
How to Avoid an old "Default File" from importing into Anaplan via Anaplan Connect if no file loads?
Here is our setup: We have an Anaplan import that runs via Anaplan Connect. The file drops into the folder location daily on the server. Then Anaplan Connect picks up that file & loads it into Anaplan. Here is our problem: If no file drops into the folder location on the server, then Anaplan Connect will default to an…
-
Data Orchestrator release date?
Hi all Is data Orchestrator available? There are On demand learnings but I can't see anything as in the screenshot below when I'm connected. Thank you
-
Error on Excel Add-In
Hi All, do you know why I receive this error when connecting a view through Excel Add-in? Thank you, Joana
-
Snowflake Integration : Anaplan Connect with Private key
Hi All Anaplan connect is unable to extract private key while making a JDBC connection to snowflake. Error says “Try setting the JVM argument: -Dnet.snowflake.jdbc.enableBouncyCastle=TRUE” I believe I am using the supported version of Java (v8) & the latest version of Anaplan connect(4.2.1). I have converted.p8 to .pem…
-
Lesson 8.5.3
I am on my way to finish the Level 1 Model Building Training and I am in Lesson 8.5.3 and I am not able to rearrange the dimensions in the REV02 Volume Inputs model to the target screenshot. The Mapping failed… Help, please….Shalini
-
Data is not getting updated into Production model through integration
Hi Team, I am having issue regarding the updating the records into the production model via integration and action is marked as production data. In test, data is getting updated correctly with same action but in prod action is running but records are not getting updated. Anyone can advise on this issue please? Thanks…
-
How to download Pages using API
Hi, I have created a Page and I am able to export it from the UI. I need help to download the same page using an API. I am not able to find the right API for this. Please assist. Regards
-
Troubleshooting certificate authentication approach using python
Hi, Has anyone encountered this error before? I am trying to implement the certificate approach, but it seems there is an issue with the file packages, as indicated in the error messages. If you have experienced a similar problem, could you please explain how you resolved it? Thank you! Additionally, if there is an…
-
Import to numbered List
Hi People, I want to import transactional data into the model from excel csv file. I formed a numbered list, where I am importing this csv file, identifying the unique key by using a combination of properties, but there are other columns that are not forming part of the combination. (basically, those are values/number…
-
Anaplan & Fluence Connection
Does anyone know how the connection between anaplan and fluence works… or can point me in the right direction for documentation?
-
Trying to get .xlsx from Anaplan Connect but comes out as csv
I have an export that I am trying to run through anaplan connect 4.2.1 however it is causing some issue When I run the export direct in anaplan, it comes out directly as an .xlsx file, but in anaplan connect its format is .xlsx but excel won't open it, and if I rename the extension to .csv, it opens correctly. So it seems…
-
How to remove the New line / Line break Character
Looking for a solution to remove the line break or new line character from the text formatted line item editable by end users. reading the text from the user editable line item to another line item, in the process want to replace new line character if any from the text. Because of New Line character the data while being…