-
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.…
-
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…
-
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…
-
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…
-
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…
-
Loading file in Deployed Mode with same name in Actions "Import Data Sources"
Hi, For the past few years, I was able to load files manually in the Actions pane's "Import Data Sources" by loading a file with the same name. Usually it fails the 1st load, but works the 2nd load. I try doing this method today and this does not work anymore. I tried 2 browsers and tried removing cookies and no success.…
-
Can Connection Strings Be Used Instead of SAS Tokens for Azure Connections in Cloudworks?
Hi Anaplan Community, I'm currently using Cloudworks to integrate with Azure Blob Storage. In my setup, I see the option to enter a SAS token for authentication, but there is no field to enter a connection string. I have reviewed this Anapedia documentation, and it only references SAS tokens. Is there a way to use…
-
SUM Function Example
I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me know, if I am right or wrong? I have shared Screenshots for reference.
-
anaplan api 401 Not Authorized using Postman
Using Postman: I can use Post and get an authorization token, but when I create the Get with Authorization = AnaplanAuthToken <token from Post> Content-type=application/json Basic Authentication and workspace ID and Model Id in URL https://api.anaplan.com/2/0/workspaces/<workspace id>/models/<model id> I get: { "status": {…
-
Importing Values to Booleans via Model to Model
Hello, I hope you are all doing well and good. I would like to ask about a challenge that I'm currently experiencing. Situation is, I need to create an action, just a simple action that will be published to the NUX. This will be an Import action within the same module via a Saved View. Please refer to the encircled line…
-
Does it make sense to have multiple data hub models for different uses?
We currently load multiple data sets into our data hub, then from there to various spoke models. We want to increase the frequency of one of the loads but are concerned the process timing might conflict with another load. Does it make sense to load the data into different data hub models in the same workspace to avoid…
-
Allow User to Enter Comments at Parent Level?
We have a text-formatted line-item where we want users to enter comments at both the child and parent levels. The current solution works fine for the bottom level, but Anaplan won't allow comments at the parent level (Marketing - Corporate Memberships). Is there a simple fix to this issue?
-
Data Import for REV02 module
I'm getting this error while importing data for REV02 module. PFA screenshots.