-
Can we stop a integration flow in Cloudworks which is running indefinitely?
A integration flow which usually runs between few seconds to 1 minute is now taking 30 mins and still running, whereas in model there is no tasks running. Can we stop/**** the integration flow without hampering the model?
-
Cloudworks succeeds but doesn't actually run
Hi all, I've noticed for a CloudWorks process I have that the actual integration says "success", but when I check the model, the last run time of the process was not updated, nor was any new data added to the model. This is an integration from BigQuery that worked previously, and is now not actually pulling new data. Has…
-
Integration data between Anaplan and SFTP file
Do you know about integration data between SFTP (Filezila) to Anaplan? I want to import data from SFTP file to Anaplan.
-
How to import Negative Values from txt files
Hi All, I am importing data from tab separated txt files and I noticed wherever the values are negative, its populating as positive numbers in Anaplan. As shown in above example the negative values are denoted by a negative sign after the number in the txt file. Is this format supported by Anaplan? Thanks in advance
-
Anaplan Connect with Snowflake & Public/Private Key
I am attempting to utilize Anaplan Connect to move data from Snowflake into Anaplan. In order to work with our snowflake setup, I need to use a public/private key pairing as opposed to a snowflake username/password. I have been told the most recent version of connect (3.0.0) does not work without these fields and that an…
-
DCA and Internal (Full Access) user Issue
Hi Anaplaners, I have a scheduled job run by an integration [Internal (Full Access)], in the target module some data/values (text or numbers format) are imported correctly however, in some line items with DCA the values imported are zero and this is not the value in the source module. Internal (Full Access) has WRITE…
-
1.5.6.2 Import Data into Historic Volumes Module
Hello, I'm trying to import historic volume data into the DAT03 Historic Volumes module but somehow the load is being ignored. Please help. Note: All SKU and Accounts flat line items are mapped successfully.
-
Text formatting within email's body
I am building email template for MAILTO formula. Is it possible to format the text (make bold, italic, colored) and create paragraphs in the emails' body? Maybe implement html tags?
-
How can we automate data imports from IBM sterling on premise server to Anaplan
Hi Team, Please help me in understanding how can we import data from IBM sterliling on premise server to Anaplan and automate it.
-
Deleting List items that are having no data
Hi all, Could anyone please help me to know deleting the list members based on data in the landing module? In my case, I want to delete the list item which has no data by all quarters and versions. And Summary is turned off for the line item which holds data. Thanks in advance.
-
Error while using anaplan-connect-4.1.0 .bat scripts to connect to Anaplan portal
Hi, We have recently purchase a CA certificate (.P12 ) from Entrust. We followed the Interactive CA Certificate from Anaplan and converted our .P12 file to Public certificate and Privatekey.Pem files using OpenSSL 1.1.1. Uploaded the modified Public certificate into Anaplan portal and it worked fine. When I tried to…
-
Anaplan Connect Process
Hello Everyone, I would like to understand the process of Anaplan connect. For example: I will define the export action in Anaplan connect and it will export the file in some local folder based on schedule (daily basis). Will Anaplan connect overwrite the csv file in the folder everyday or a new version of the file is…
-
Ragged and Balanced Hierarchy help. Many to Many relationship with Ragged Hierarchy.
Hi Community, I have been reviewing the knowledge around Ragged and Balanced hierarchy. I have a bit of a unique situation and need some help from the Community. Attached is a file that breaks down the flat file I have put together of a relationship between entity-owner. Each entity has an owner. That owner can also be an…
-
Time treated as common list on Import Action
Hi, I am loading a CSV into a module that has simple time list at month level – however the import action is treating TIME as a common list rather than allowing to do the specific time mappings as expected. Im sending below the details with all the screeenshots I believe are necessary to help understanding the issue. Here…
-
Hyper Links and sending mail,
Quick question, not sure why this item is not displaying as a clickable link. Also, I was checking the mailto function, I am looking for the capability to click on an email as a link, and maybe an outlookprompt would open and let the user type their issue, is that a posibility? I see that it just let you create mails for…
-
Export/Import Time Periods
Hi team, I have a situation whereby users have the option to export the data from a module, adjust the relevant cells & then import the same CSV file to the module. There is an issue with 2 line items that have Time Period as the format. When they are exported the format in the CSV is 'MMM-YY' rather than 'MMM YY' & if you…
-
"invalid name: ....." error
Hi community. When trying to import into a list I receive the error "invalid name". Do you know where I can find the explanation of this error? Thank you.
-
Sending data from Anaplan through Informatica
Hi, I have an export action which is exporting a list. I want to send this list data to informatica. I have mapped this list columns to columns of a table in informatica. However the job is failing with below error. [ERROR] Error occurred while reading data from the target native system :…
-
Can a Non WS Admin User Save an Exported File to a Centralized Location?
Hello Anaplanner, Can a non work space admin user run an export action and have the export file saved to a centralized location that is not the user's local computer? Thanks, Lily
-
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…