-
Hyphen formatted numbers issue when exporting to excel.
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue When setting a numbered line item to hyphen format. When exporting as xls or xlsx, the hyphen formatted cell will only ever display a hyphen, even when edited to be non zero cell values.…
-
SAP S/4 HANA & SAP PO to Anaplan integration best practices
Hi all, Looking to see if any other members of the community have integrated SAP S/4 HANA to Anaplan. If you did, were you able to achieve the integration with Anaplan Connect or the API through the SAP Process Orchestration middleware? Or did you *have* to write some custom wrapper program using either Anaplan Connect or…
-
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…
-
Level 2 Conclusion: Import Shipping Expenses into OTH01 Module
Here everything is mapped correctly as per me but then also errors are coming. Can anyone help me out? @jagadishdash @Misbah
-
Can a parent and child in a list have the same code?
Hello, Can a parent and child in a list have the same code?
-
How to best design your model to facilitate variance analysis.
I have a requirement to create a model that can facilitate variance analysis like Compare CY Sales, with PY Sales and show % along with doing the same for CY Sales vs Budget. What would be the ideal model design? Should I be create versions or should I create line items for CY, PY and Budget in the module and then…
-
How to go over 130 GB allowance?
Hi all, I would like to go over my workspace 130GB allowance. To do so, I could add another workspace and split my models between these two workspaces (6 models: 3 development and 3 production environment). What can be the cons of this split? I have currently no API connection, only connection between Anaplan models.
-
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…
-
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:…
-
Does file ID change if I update the import source for an action?
Hi all, We are testing bulk API's data import, on which I had 2 queries. Suppose I create an action in Anaplan for a file and then data in loaded using bulk API's, but later I went to manage import data sources and updated the import source of that action with a new file. Will this change the file ID of the file which is…
-
ANAPLAN CONNECT - Password update request
Hi, We have 20 scripts for ANAPLAN connect, and they each contain a user logon and password. set AnaplanUser="username:password" There are 2 questions. 1) Can the password be hidden in the script, as anyone can edit a script and see it? 2) When ANAPLAN insists on a password change, all the scripts stop running, this can…
-
CloudWorks Integration Flow || Regarding Blocking Actions
With the new integration flow feature available in CloudWorks, I wanted to get some information on how it blocks the related models for running the import. Consider the below scenario. Integration Flow 1 consist of 2 integrations (INT 1 and INT 2) INT 1 runs a process in Model 1 INT 2 runs a process in Model 2 Now if I add…
-
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
-
Can we send file to Azure blob using Service principle
Hi Team, We are sending the exported file from anaplan to Azure blob by using SAS Token. Can we do the same with Service Principle.
-
In 2.3.9 and 2.3.10 why are my weekly growth not what I expect
If I understand correctly, if the monthly growth in the DEM01 are 1%, then in DEM02 the weekly should be Month/4, in this case 1%/4=.25% but in DEM02 they are 1%, then in DEM03 everything seems much larger than I would expect. Am I reading too far into it or is there an error in the formula for DEM02 and DEM03, which…
-
Problem Solved
Hi All, Thanks for the help, I already solved the problem.
-
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…
-
Anaplan SAP Integration
Hi Community, we want to integrate SAP and Anaplan, but client has asked not to use any files for integration, so is it possible to load the data from SAP to Anaplan with API in json format? and how to map the fields. Please suggest
-
Anaplan data integration
Hi Team, We have integrated SAP with Anaplan and data flows are scheduled from SAP to Anaplan data hub. However we keep getting memory warnings for workspace as i am sure this is to do with workspace memory. From an architecture standpoint how does Anaplan store data in datahub ? when we are sending 2-3 MB of data from SAP…
-
Is it possible to achieve passing parameters in the API call URL.
-
Anaplan Connection - Invalid Credential
Hello team, We are getting an error frequently, almost daily baysis, related to "invalid credentials" between Anaplan connection and Power BI Desktop. Every time that team (two developers analyst) needs to work with the data, we need to reset the password and we are worried about this for the future. Do you know if this…
-
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…
-
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…
-
Kindly help with steps to configure S/MIME certificate
Kindly help with steps to configure S/MIME certificate
-
Text Formatted Line item character Limit
Hi Team, Just wanted to know do we have any Limitation of character for a text formatted line item value entered. I am aware that Max of 60 Character can be entered for a line item name , but for value to be entered.is there any Limitation and will it effect my model size aswell. Thanks Madhu
-
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…
-
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:…
-
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.…
-
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…
-
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…