-
Anaplan Certificate obtained from Sectigo - Private Key issue
I recently helped a client obtain a certificate for use with Anaplan Connect from Sectigo, using the document below. https://community.anaplan.com/t5/Releases/How-to-Use-Third-Party-Certificates-With-Anaplan/ba-p/49116 The public key that Sectigo send as per the guide works when installing it in Anaplan tenant admin. The…
-
Anaplan -mulesoft connection timeout
Hello, Our mulesoft team is reporting that since two weeks prior anaplan is giving time out to them, they have expanded their timeout to two minutes which is alot. Has there been any news with this api or integration or errors that might appear? Any ideas on what to check?
-
Struggling to create a new line in a formula
This ought to be really easy but I cannot seem to work out how to do this. Every time I try to create a new line when editing formula, in an existing formula by hitting enter, it just runs the code, instead of creating the line. I have tried using notepad to create the formula and copying and pasting the whole thing in but…
-
How to import data into anaplan using power automate by custom connector?
I have worked with custom connectors and created the action that is to be used to create flow and I got stuck in uploading the file and the data is not reflected in Anaplan. Need to figure out the CSV file reading and loading the CSV file through API
-
7.2.3 Activity: Import Data into Employee Details Module
Hi everyone, I'm a newbie to Anaplan. I have checked and tried every suggestion in this forum regarding this problem. Kindly help me out. Attached are the screenshots of everything I have done. Any suggestion would be appreciated. Currently stuck. Thanks
-
Better Formula Editor for Anaplan; A new Chrome/Firefox/Edge Extension
Hello all! I have made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor. This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done. It also works with the…
-
8.5.2 Activity: Import Data into Price Book Module issue?
Hi everybody. I import the Pricebook.csv file to REV01 Price Book module. Everything seems in order until the importing process is completed. As you see on the screenshots after importing the file the prices don't represent the correct value as in the .csv file. Where have I done wrong?
-
Importing from one model with versions to another without
Hi, I would like to import a view from a module in one model to a module in another model. The source module contains versions so I filter for the current version but the target module does not. I am getting an import error though as the version dimension has no where to map to. You can see 'Versions' in red, the same as…
-
7.2.1 Activity: Import Data into Product Details Module - Invalid line item identifier
Hi, For L1 Model Building activity 7.2.1, I am having some issues importing the data file for SYS06 Product Details module. I am getting the following error "Invalid line item identifier" when importing the file Below my mapping selection Doe Does anybody know what the issue might be? Thank you
-
L1MB - 7.2.1 Activity
It seems that there is "Product" data but I cannot see data in Column SIZE. It is not allowing me to import it again. Any suggestions?
-
Level 3 Sprint 2 Employee Details into G3 Sales Reps
Hey Team, I have encountered some issue(s) with importing the datahub saved view employee details module into the G3 Sales Rep list in the Sales planning model. After a completing the import, the results (per the attachment) are not the employee names but numbers. Could you advise on how best to quell this issue and…
-
Export View with 4 dimensions to the left side and time in the columns
Is there a way to export with 4 dimensions on the left side and time (months) in the columns? I created a saved view and used tabular multiple column export (filtering the specific months with a boolean in a separate module). However if I put the line item and time in columns it errors stating line items must be in columns.
-
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…
-
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