-
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!
-
CloudWorks performance question
We were considering using Cloudworks for integration instead of Anaplan Connect scripts and someone is dissuading us from using Cloudworks because it had "performance" issues because there is only one server dedicated executing all actions setup on Cloudworks? Is this true as I'm unable to find any such information on this…
-
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…
-
Macroeconomic Variables
Hello Community, Is there a way to source into Anaplan for modeling purposes forecasted/consensus macroeconomic variables such as GDP, benchmark rates (Fed Funds, SOFR), Unemployment, etc? Thanks! Daniel
-
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 ?
-
Can anyone describe the disaggregation in Anaplan
-
File Download API using name instead of ID
Hi Everyone, I have an Anaplan ←→Azure integration pipeline where Azure Data Factory pulls some data using an export action via Anaplan APIs. We were using the name instead of the id when we run the download API. However, today observed that it no longer works. Getting a 404 Not Found. { "status": { "code": 404,…
-
Exporting Saved View from Tabular Single Column
Hi, I'm trying to export a module saved view for tabular single columns, but the export includes every line item. However, when I check "current line item" it doesn't capture what's present in the saved view. Has anyone encountered this and has a solution?
-
Workaround for Access issue with Cloudworks?
Hello everyone, I am currently struggling with CloudWorks integration and I would like to ask if anybody in the Community have faced similar issue before. The setup: We have few modules which have DCA enabled in them - both Read and Write This Read and Write DCA is based off another modules where you basically set up…
-
AnaplanClient.bat is not recognized as internal or external command, operable program or batch file
Hi Team, Could you please, assist with this problem? @echo off rem example. Set AnaplanUser="example@example.com:password" set WorkspaceId="*****************" set ModelId="*****************" set Operation=-via http://example.net:10085 -export "Export_action.xls" -execute -get "D:\output.xls" rem *** End of settings - Do…
-
Actuals that change according to Versions
Hello, I am facing an issue regarding Versions, and I was wondering if there are new ways to resolve this. I have looked into this thread, but it is from 3 years ago, so I was hoping for an update on the matter… I figure I can’t be the only one.…
-
Model size has been rejected after adding new line item: How do I solve?
I'm not able to add a new line item to our DEV model because of the following error: The model size is actually 20gb. I don't think the size is an issue. Is there another reason for this error? and how do I fix it?
-
Summary method for time
I have a reporting module that shows me gross and net revenue totals by month, with line items for each member of a hierarchy as well as the period. I can select each period to see each month's data, but I'm wondering if there's a summary method I would need to be able to see all of the months when I have the whole fiscal…
