-
Anaplan File Upload Automation - iPaaS Reviews
We are automating data uploads from our Snowflake tenant to Anaplan. Our current iPaaS solution fails constantly on the upload process and doesn't provide much feedback. Can anyone provide their experiences with other iPaaS platforms and their Anaplan connectors? We don't have developers in-house so we have steered a way…
-
How to INSERT or UPDATE a record in MS SQL with AnaplanConnect export action (jdbc properties)
Hi ALL, We have a requirement to export Anaplan data into a Microsoft SQL Server database. We have requirement that, need to insert in a table if new records or replace with existing records. As per Anaplan Connect latest user guide shows it’s achievable with REPLACE or INSERT IGNORE SQL commands. But I’m facing following…
-
Excel Add-In "Send & Receive" detects no changes
I am very new to Anaplan I have become proficient at extracting data, but this is my first attempt to update our forecast. But I can't even get past the first step. I change the data, but when I hit "Send & Refresh" it detects no changes
-
Anaplan API Authentication service - nuances...
Official documentation from Anaplan: https://anaplanauthentication.docs.apiary.io/# In order to successfully connect to the Anaplan Authentication service you will need to: * Generate a CA certificate. with access to both the public certificate and the private key * Add the public cert to the anaplan security site *…
-
Possible to extract Workspace security using API ?
Hello, We have a requirement to send security extracts on a weekly basis, since we have 10 or more workspaces, is there any way we can extract this information via APIs ? It's jus the Extract option on the users screen that we are looking for
-
CloudWorks Integration with Amazon S3: "There was an internal server error"
Hello, I'm trying to get Anaplan to an Amazon S3 bucket. I have set up a connection and it seems to work, however when trying to pick a data target I keep running into the issue of there being an "internal server error". Any thoughts on how to resolve this?
-
Google Sheets Add-on Performance
Hello, We would like to use the Google Sheets Add-On, but face the problem that every step, including the refreshing and sending of data to and from Anaplan is very slow and time consuming. Using the Add-on in a new empty sheet works faster, but the client works in several Google sheets with multiple…
-
Reset Index number without affecting Data
Hey community members! I'm facing an issue with resetting the index numbers for List A in my project, and I could use some guidance on how to solve it. Here's the situation: I have a hierarchy consisting of three lists: A, B, and C. Currently, List A has reached its maximum index number. To give you an idea of the item…
-
Import Fail - Invalid Date or Time Scale Error
Hi Team, In Level 3, I have imported activity 4.6.1 Historic Revenue by Product. I'm facing issue with the Time Dimension even though I used the Time Range concept Any ideas on why this is 'Failing'? Is this because of the Model Time scale as a "Week" SS Thanks Devika
-
Anaplan: Valid To period - 9999
Hi Expert, Good day! Would like to seek your insights on how to upload the ValidTo period as 12/31/9999 and in Anaplan it will become blank (Date format). Since in Anaplan unable to load this period format unless set the format as text. Is there any workaround to handle this one or a system limitation? Thank you in…
-
Can we update Source Model mappings using an Action or through an API in Anaplan ?
Hi, Can we edit Source Model mapping in Anaplan using an Action or through an Anaplan API? e.g.: We want to import metadata from 2 sources into 1 target model : We have same module name, line items, metadata (codes) and saved views exist in Model 1 & Model 2. Model 1 ⇒ Model 3 (using "Action 1") Model 2 ⇒ Model 3 (using…
-
Anaplan Import Action - Import connector: Error obtaining input stream (caused by: File not found)
In snaplogic, We are using Anaplan-connect SDK 1.4.4.8 version to connect to Anaplan. As part of one of our customer usecase, we have created a process with 8 Anaplan import actions in it. Using Snaplan Anaplan snaps, created a pipeline which executes 8 anaplan uploads simultaneously and once all uploads are successful, we…
-
Level 2 - Conclusion - Create Country Currency List
Hello, While I try to import the currency data, the data for EUROS is not getting updating because it is similar for 3 countries. I tried selecting the name or code also, name only and code only. Tried selecting countries as parent and deselecting it. But facing the same error. Kindly help. Sneha
-
Excel Import - Month Format on csv
I'm in the process of building a bulk load export/import process. The (no time dimension) module has 2 lines" Start Month and End Month (both "Month") When I export to csv, the date format looks like "23-Jan" (Formula bar looks like: 1/23/2023). When I try to reimport the file, it gives an error saying that "23-Jan"…
-
incremental synchronization
Is there any way to implement incremental synchronization of data loads? which will only synchronizes the data in the application that has changed since the last sync from the data source?
-
sample code for rest API
Hi all, Is there anyone who can share a sample file with code to use for REST API. We would like to setup a data integration between SAP and Anaplan using REST APIs, but it is hard to get started without sample file. Thank you!
-
How to get Export output in json format?
Hi all, I am running a download API in logic app to get a list of my exports, i am able to get the result, but its in octet-stream format while i want the data to be in JSON format so that i can create a blob file with it. Any ideas how i can achieve this, also the Apiary links says that my result will be in JSON format…
-
Loading file with different file names for the same action in deployed model
Hi All, I am trying to run the action through Anaplan Connect with different files in deployed model. But the action is running only for the file that matches with the source label of that action and if I use the different file name scripting is failing. Attaching the screenshots for reference. Screenshot1:File name same…
-
Date Format - Custom Mapping
Hi! I am having trouble in importing a file with a YYYYMMDD date format and it says that I can set the data as a custom mapping for those line items when I map the source to target before mapping. I mean how I can successfully upload it without revising my upload file?
-
Issue on Importing a File
Hi Community, I would like to ask this issue. I have never encountered this before so I hope you can provide me some insight. For example: This is the view of the file I am going to Import ini Excel mode(just a sample). I do the usual Save as "CSV format". I open the CSV format and everything is fine. I proceeded in…
-
How to use the RANK function
Hi everyone. I would like to use RANK function and extract only the data for the most recent date. However, the module have over 10 million cells. RANK function cannot be used... What should I do now? The following error message is displayed. Best regards.
-
Viewing Incoming API CSV Files on Anaplan Server
Hi Anaplan Community! My colleague and I are currently working on a new API connection between EDW and their Anaplan Data Hub. We are currently having difficulty loading all files through the connection. We have reviewed the queries and scripting for sending over the CSV files and cannot find any errors. We also are…
-
How to get File IDs for a specific process and then download Via Azure Logic App.
I am trying to run couple of exports in a single process through Anaplan APIs, the challenge is I want only the file IDs for the process which i am running, but if i run the get file ID API, i get all the files within the model, so is there any API which will let me take only the files which are under the process? or is…
-
Pulling data into Anaplan from a file (.csv/.xlsx) which is stored at a share location
Hi team, For one of our enagements, we have a requirement wherein the client wants Anaplan to refresh the data that exits in file on a regular interval. Following are the assumptions: The file data can be simple text formatted and will come to Anaplan inside a line item. The data in the file will be altered by multiple…
-
Help - Stuck on 1.5.6.1 Create Historic Volumes Module
I am still having trouble with 1.5.6.1 in L2, Sprint 1. It says "DAT03 Historic Volumes Invalid Line Item Identifier." I have attached screenshots of how I have mapped things - can someone please help? Thank you.
-
Issue while Importing Dates in week format
Hi All, I am trying to import data into my module however, i am not able to map the date format with the modules timescale, the date is in "Week 1 FY19" format and i am not sure which time scale format will be suitable for the same. Thanks.
-
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…
-
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…
-
Update Formula's Automatically
Hi All, Is there anyway by which formula's can be directly imported in a module for a line item? The blueprint view import option does allow to import a new line with a parent and a code from a file or any other module but is there anyway that the formula's also get updated automatically from another module or a csv file?…
-
ServiceNow tool integration with Anaplan Possible?
Has anyone connected ServiceNow to Anaplan to display the ticket information on dashboard ?