-
Excel Format Issues - Copy and Paste
Hi all, I am having an issue when it comes to copying and pasting data from Anaplan to Excel. In fact, the data format changes from number to general or scientific. I don't know how to fix this problem, may anyone help me? Thanks in advance, Luca
-
Very big difference in Process execution time and component action execution times
Probably this is the wrong place to ask this question, so apologies in advance. In one of our models the total execution time of a process was 3000 seconds, and if we look at the component actions and their execution time, the total was less than 1500 seconds. Any idea on where these extra "magical" 1500 seconds were…
-
Are there API tos create (define?) a file in Anaplan, prior to external upload
I am building an integration in Boomi to move data into Anaplan via Boomi's dedicated Connectores (or by API calls). Per Boomi Connector: Note: To upload a file, it must already exist in Anaplan. If you did not previously upload the file to Anaplan, you can use the web-based application to complete this step. You can then…
-
Anaplan Connect issue:- sun.security.validator.ValidatorException: PKIX path building failed
Hi Expert, Anaplan Connect scripts were working fine since 1 year, not sure what happen suddenly I'm getting below error messages while executing. error: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target (Validator: PKIX path building failed:…
-
Anaplan Connect using BatchScript For Windows-How to extract txt file from bat script in VDI Server?
Hi All- I am trying to execute on batch script using Anaplan Connect. My Requirement is i want to extract txt file from the batch script (Extract means result of entire batch script). As per requirement i had created one batch script and tested in my windows system, it's working fine to me. Command listed below: Same…
-
Import process works but when added to my Connect Script I get an error
I have a JDBC connection which works and creates a csv file with data succesfully. I have mapped an import using a file with the same format and name as the csv. This import works, creates the csv file, but then i point to the process that imports the data I get this error… !!! The operation failed !!! =( Property-based…
-
Problem Solved
Hi All, Thanks for the help, I already solved the problem.
-
Is it possible to achieve passing parameters in the API call URL.
-
Best Practice for code promotion
Hello All, I am looking for information in terms of code promotions from the different environments with Anaplan. Currently if we have a development environment with our models and we have moved the code to a test/stage environment for UAT. In order to propogate the code to prod would you move the code base from dev to…
-
Datahub Data Mapping Ideas
Hi folks, How would you map of what's coming to your Datahub and what data is leaving the hub to any spoke model? We have a big Datahub with over 100 processes and sometimes when we have a data mapping issue it is very challenging to have clear visibility of what data connection is missing. We use the Hypercare app that…
-
Selective Access and Tabular Multiple Column Exports
I have defined an export using the Tabular Multiple Column layout, filtering using a Boolean from a separate module. The module being exported uses a list with Selective Access. When I try to limit my access and run the export, to test how an end user would interact with the export, the model exports rows for ALL members…
-
Exception in AnaplanV2client java.security.InvalidKeyException: Key must not be null
Getting error while connecting to Anaplan using Anaplan Connector in mule 4 with cert authentication (not the basic auth) While testing the connection i get following error org.mule.runtime.api.connection.ConnectionException: Unable to contact Anaplan API Services org.mule.runtime.api.connection.ConnectionException: Unable…
-
Flexibility when importing .csv file with Time Dimension
Hi! Does Anaplan have an option to have a flexibility to import .csv files with regards to time? For example, one user exports a .csv file with Y-M time format (23-Jan, etc.) while other user exports with M-Y format (Jan-23). These files exported from Anaplan will eventually be imported back. I know these differences are…
-
Are we able to indent bullets in a text box in the UX?
I am trying to type out a list of instructions using numbered bullets. The instructions will end up being about 10 steps so they will be numbered 1-10. I want to be able to add sub-bullets (a,b,c, etc) under instructions but I can't figure out how to indent them. Does anyone know of an easy way to indent the bullet points…
-
[Informatica] Can't see any actions (objects) while setting up target object
Hi all, I am trying to create an interface based on the existing one. It is mapped to a prod model and I what to setup a test model and connect to it. I created new connector and mapped it with correct Model and WS IDs. The test shows all working fine: In a copy of a process that supposed to upload a file to my model via…
-
Flat list module to module with key made from the flat lists
I have a module dimensioned by 4 flat lists. A line item in this module creates a key using 3 of these flat lists. I have another module dimensioned by the key and the 4th flat list. How can I map data from first module to the second module?
-
How can I add dimension item ids/names to a module through a transactional API?
Hi I'm currently trying to use the write cell data transactional API to fill a module in Anaplan with required information. However I can only currently add to dimension ids/names already defined in my module. For reference, in my current module Dimensions sequentially increase in number #1,#2,#3 etc. I can add to these…
-
CA Certificates for Service ID (Password less Connectivity)
Do we have a list of CA Certificates that are mostly used to implement password less integration with Anaplan and if anyone has an estimate of pricing & validity of those certificates? Our client is looking for the feasible options while choosing the Certificate Provider - So a consolidated list will actually help the ask.…
-
SSL handshaking
Hi Team, I'm facing this issue and can anyone provide solutions to resolve this Task execution failed. Exception: 2023-03-01 17:03:23,078 - ERROR - Job failed with status: FAILED 2023-03-01 17:03:23,078 - CRITICAL - java.lang.RuntimeException: Can't execute job FLOW-TO-STR-L-POD Caused by:…
-
Postman API connection to model
Hello, I'm having a bit of trouble authorizing my connection to model in postman. i'm using the official anaplan collection setup. From what I understand first I go to Create an Authentication Token (Basic). I change authorization type to basic auth, type my username and pw and send the request. That gives me back token…