-
Anaplan Connect: Export to SQL Server
Hi, I am setting up export connections from Anaplan to SQL Server. We do this using Anaplan Connect. We have already set up around 100 export connections, but we are still facing difficulties with one specific export. In the screenshots below you can find the error log we’re facing. We use a simple query to insert the…
-
Export Action
Hi Members, Can someone please guide me, how can I create an export action? As Export Action is not displaying.
-
Level2- Sprint1- 1.3.8 model to model import-unable to import parent from saved view build location
Level2- Sprint1- 1.3.8 model to model import -unable to import parent country column in G3 Location list from saved view - build location. Please help me out to resolve the same.
-
OEG Best Practice: Anaplan Python OAuth Example
The Anaplan Python OAuth Example demonstrates using the Anaplan REST API with OAuth with device-based authorization. The code highlights how to generate a device_id, access_token, and refresh_token. Additionally, the code highlights a multi-threaded approach to request a new access_token while performing other,…
-
OEG Best Practice: Using Anaplan Connect with OAuth
How to Use Anaplan Connect with OAuth Authorization Anaplan Connect is a powerful command line interface that allows you to automate your Anaplan environment, enabling seamless data integration and synchronization between Anaplan and other systems. While Anaplan Connect offers various authentication methods, including…
-
Bi-directional Integration: Bridging Workday and Anaplan
Intended Audience Level of Difficulty: Advanced Requires an experienced developer, solution architect, or data engineer Resources Required: Internal Expertise: Data Engineer/IT Admin/Integration Admin Tools Needed: Anaplan Connect, SQL Database, Text Editor Access Requirements: Database access, Anaplan model/s Estimated…
-
Data load to SQL using JDBC connection failed : Cannot deserialize value of type
Hi Team, one of the export from Anaplan to SQL tables failing with the following error message. This script ran successfully till 27th Aug and it was failing for past 2 days. No changes were made and it was the same export script and JDBC properties file and same target table is being used. Appreciate for your guidance to…
-
CloudWorks - Model to Model Processes
I am trying to schedule automated Model-to-Model processes using CloudWorks so that it doesn't have to be done manually by a human. What I've noticed is some of my Actions within the automated Process don't run properly when CloudWorks runs it vs. when I manually run it. It seems that Cloudworks, "Internal (Full Access)",…
-
Duplicate Rows or Columns Excel Add in
After closing and reopening an excel add-in linked workbook I am seeing the attached error. The workbook worked fine before being closed. It has also broken the connection on another tab that was working correctly, I think this may be a separate issue.
-
Cloudworks - view the queued processes and/or cancel process queuing
In case of Anaplan issues with Cloudworks servers, processes that were on schedule start to form a queue that is released once Anaplan solve the problem. We ended up a few times in situation where the same 30 min process (normally scheduled every 2h), run 3 times one after another. This is causing problems with other…
-
Update Current Period Action
From April 24, 2021, model builders will be able to update Current Period via an action. Workspace Administrators (WSAs) can always update the Current Period manually via the Model Calendar, however, this may not always be convenient. The Update Current Period action enables the WSAs to increase efficiency and reduce…
-
How to mass-delete data from a List
Hi experts, Could someone give me a way to mass-delete data from a list? There are 300,000 of product data in the L_Product, and when I try to select all and delete them, "Cannot delete over 10,000 records" error appeared. Regards, inoue
-
Timedimension while exporting a module in .csv file
I am facing an issue when trying to export a module in .csv format. I have setup a Time Range that has 2 Periods and have available aggregations set as Total of All. In a Module I have this Time Range (which is in periods - Jan 20/Feb 20/etc...) in column and when I am exporting the module as a .csv file in the .csv file…
-
Data Validation when using Anaplan API
One thing i've found quite challenging when doing API implementations (and at this point i've done well into my 20s of these) is, what is the best way to validate that my API calls are properly working? Specifically - how can I validate that file uploads are pushing in the right data? There are so many different variables…
-
Provide capability to import blank values for dates and list formatted line items
I would like the capability to blank out cells. This is not currently possible without clearing target before import. Description of the enhancement required: Ability to blank out cells without clearing the entire module each time An example of the enhancement: During the upload, there is an option which allows user to…
-
JAVA REST API example with Anaplan generated Certificate
Hi All - SSO is enabled for my tenant with exemption users not allowed due to internal policy so certificate authentication is my next option to bring data into anaplan is a systematic flow. I will obtain a CA Certificate as described…
-
Update export actions created from a saved view when saved view is modified
I think the title says it mostly, but to be clear I'd like to be able to do the following: 1. Create a saved view of a module 2. Create and export action using the saved view as basis 3. Modify and re-save the saved view (i.e. add a new column, change the filter etc.) 4. The export action should update itself based on my…
-
Model history api endpoint
As a integration admin, i d need to be able to access to the model history through an api endpoint and in the model This is required in order to - listen to models actions and check if / whenservicess outside anaplan should be triggered - extract for audit purposes the history of anaplan model and expose it to auditors or…
-
1.3.4.3 Update SYS07 Location Details Module
Hi All, I completed this task and everything seems good. Except Location name not populated in the SYS07 location Details module. Please see the screenshots attached and advise everything is correct and I can move forward. I tried to Manually map location to code under 3rd tab but not able to do it. Someone please help me…
-
RESTful API How To
You can interact with the data in your models using Anaplan's RESTful API. This enables you to securely import and export data, as well as run actions through any programmatic way you desire. The API can be leveraged in any custom integration, allowing for a wide range of integration solutions to be implemented. Completing…
-
Excel add-in save & refresh: possible to fill line item data with formula's in excel?
Hi, Using the Excel add-in, I am curious whether it is possible to auto-populate line item data using formula's in Excel. Can anyone tell me if it is possible to set this up and if so how? As an example: consider a module linked in Excel where cell A7 contains a line item with B7 a number that is editable. Is it possible…
-
Anaplan Excel add-in 4.3 Cloning
I am trying to copy an excel sheet with an existing Anaplan connection into another workbook. However, once the copy is done, the Anaplan connection seems to be broken and cannot be refreshed. I understand that the cloning function currently works within a workbook only, does anyone have any workarounds with respect to…
-
Different numbers being imported
I have 2 modules, both with exactly the same structure (2 dimensions, multiple versions, no time scale, and with only one line item). I created a simple import from one module to the other, however, once the import has run successfully with no errors, I'm getting different numbers landing in the corresponding cells in the…
-
Importing data directly from another Anaplan module
When a user is attempting to import data directly from another Anaplan module, they need to be able to use an identifier (code or link vs. the display name of the field) to ‘connect’ the records. For example: When a user exports from a ‘source’ Anaplan module, the user has the ability to export the ‘code’ or ‘list link…
-
Anaplan Connect: Difficulties setting up export from Anaplan to SQL Server
Hi, We're trying to set up a connection to export data from Anaplan to Microsoft SQL Server. We already have a working connection to import data into Anaplan, but we can't manage to set this up the other way around (export). We set up the export connection using the Anaplan Connect guide and our working import actions. We…
-
Add Bulk Copy to action list to be added in process chain.
Hi there, Current limitations with the version dimension mean we are not able to select Version as a list formatted line item (there is a separate ticket with community support on this topic). Because of that, we are forced to do a number of data moves using custom version lists, list subsets, and collect statements to…
-
Line Item Subsets API Endpoint
Create an endpoint for retrieving list of Line Item Subsets in the model. Also, we need an endpoint to see which line items are included into the subset.
-
How to set up integration from MS SQL Server table to Anaplan model via Talend
Hi, We are trying to load contents from a table in MS SQL Server table to Anaplan model (processes, actions, etc.) using Talend. So far we are able to make connection to Anaplan model and do the authentication successfully. We are able to view all import ids of the model / process ids / action id. I am following this user…
-
Integrating to Anaplan with Talend
Hi all, Has anyone successfully integrated a Database result to Anaplan using Talend Studio? I've looked all over and cannot find successful examples of querying a db, using that dataset and pushing it to Anaplan without saving it to a file first. My issue is I cannot get the db result into a format that feeds correctly…
-
Transactional API for Direct Module Data Access
Hi All, Has anybody built a solution using the Transactional APIs to Retrieve cell data for a view yet. There is reference of Denodo Virtualization tool on forums but it does not work for modules above 1,000,000 cells since there is restriction on the API endpoint.