-
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…
-
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?
-
CloudWorks scheduled status types
What are the different status definitions for a CloudWorks scheduled process?
-
Populating list subset based on a Boolean from a specific version of a module
All, I need to update my hierarchical list subset from a module with versions. I have a module dimensioned with my list and a saved view in forecast version with a Boolean formatted line item (already populated and true for several items) based on which I need to update my list subset using action but I couldn't find my…
-
ALM setup DEV to Test to Prod
Hi Guys How do i setup ALM so that it only works From DEV -- > Test and then only Test --- > Prod Currently i have DEV TEST In deployed mode synced with DEV NO PROD PS:- I know this is against the best practice as we should do DEV --- > Test and DEV ----> Prod but trust me client only want above . Thanks
-
How to upload file in postman while running a collection
Hi Team, I am trying to import a csv file into Anaplan through API in Postman. When I am running individual requests and upload file in body(binary), it gets uploaded into Anaplan but while running the collection all together and putting file into collection runner, it is throwing error "500 Internal Server Error".…
-
Need assistance with custom view filtering
I have a % input dashboard that shows employees in the rows and locations in the columns. The dashboard is filtered based on user selection in the grid above it for balancing unit and cost center. I have another dashboard where users can select which locations they want to see as active with their cost centers. I'm trying…
-
What are the benefits of integrating Anaplan with Azure for administrative tasks?
Hello everyone, Can you tell me about, What are the benefits of integrating Anaplan with Azure admin for administrative tasks?
-
Hi, I am trying to map the E2 Employees# list subset mapping , pls tell me how to map here?
I have to get solution like this , see below screenshot