-
Integration to between Workiva and Anaplan
Hi, Can I use Anaplan Cloudworks to have data integration between Workiva and Anaplan? I need to load data from Workiva to Anaplan. Thanks, Tom
-
How to make a numbered list to populate another numbered list increasing its size?
Hi everyone, Anyone knows how to submit data from a numbered list to another numbered list (with the same dimensions) by adding lines to that other list? Both lists are numbered because their items have no identifiers such as code or name. The idea is to have an initial list that is blank that users fill out, and once…
-
Level 2 Sprint 1 List Import Errors
When I imported flat files for Sprint 1 1.3 I did not include a parent as instructed, so my country list has only a code, and my location list likewise (see image). However, when I then import this list into G2 Country, it now has no parent listed under region. When I try to write a PARENT(ITEM(___)) formula, I receive…
-
Exports linked to saved view and user selection
User Story As a model builder I would like to set-up exports that are connected to saved views and that synchronize with a dashboard to provide for end-users dynamic & efficient export possibilities and enable sustainable integration with other systems. Explanation Unfortunately, we are not yet in the position that all…
-
Anaplan Connect 1.4.4 Upload Error
Hello community I try to run Anaplan connect to import data from my local computer with email and password. But it doesn't work. I've already set import file as Admins Only. I don't understand just this error **** what is wrong. ERROR [c.a.client.Program :650 ] 9204 |-- Anaplan API: Could you tell me what is wrong? bat…
-
Import is not working with saved view contains 6 dimensions or Lists
Hi, I am trying to copy the one line item data to another line item within same module by using an import action from saved view(Source) to module(Target) and it is not working in expected way.. Module and saved view have 6 dimensions or lists, due to this i could not bring all these lists into Rows section of pivot option…
-
CloudWorks: customizing the integration list
Hi all, To make working with the list of integrations faster and more convenient, I propose to make it possible to change the columns in the list by adding any necessary fields from the "Overview" and "Schedule" tabs (selecting the necessary fields with checkboxes in the list menu). This way, you won't have to click on…
-
How to get the export ID other than the API method
Hi, In the Anaplan account, where to find the export id in the account? I tried through the Rest API-Postman and I am getting just the square brackets. Is there any other way to find the export id?
-
Level 1 Exam REP04 Employee Expense Summary
Hi, Formula doesn't work here, there is no value in REP04 Employee Expense Summary, how can I solve this issue, could you help me, please? Thanks,
-
Combining Data in two different Modules
Hi, I have LI's from one Data Module that I need in another Data Module that doesn't share the same dimensions. The common mapping I would use would be BB Contract ID. What would be the best way to go about this? Target Module Source Module Thank you
-
Versions
Hi community, While building a model I came up with some questions regarding versions. In my model I have some values that I refer to as "actuals" and I want to be able to import them monthly. And all the other modules that I previously built should update their values, with this I mean: the past values should remain the…
-
Large transaction data imports with Code > 60 characters
Hi all, I'd need some experience sharing regarding some challenging data imports that have the following : - Large volume of transactions - Multiple attributes (> 10) to load - Unique code would be > 60 characters if we want to follow planuals and best practices to have a good performance load Has anyone solved this…
-
Action Time-Out on Importing Numbered list security into Users > Selective Access
Hello all, I am building security actions and processes. I have a number of lists with selective access. My imports on non-numbered lists all work fine with the import line items formatting as the lists. One of my lists that has selective access is a numbered list. Instead of the import line items being the list, I have…
-
Using CA Certificate to execute Anaplan REST API 2.0 from VB .Net (C#)
Hello, we had an application that calls the REST API 2.0 using Basic Auth. Now want to move to CA Certificate approach to get the Auth Token but we get 401 error. we took as a reference the instructions in link below:…
-
Do we have any option to get the JSON format response using Get chunk data API ?
1.) Get chunk data API is returning the response as an application/octet-stream format, we have any option to get the JSON format response using this API ? Get chunk data API - /workspaces/{workspaceID}/models/{modelID}/files/{fileID}/chunks/{chunkID}
-
Is it possible to Retrieve cell data based on Task Id/Job Id.
2.) Is it possible to Retrieve cell data based on Task Id/Job Id. Retrieve cell data API - /workspaces/{workspaceID}/models/{modelId}/views/{viewId}/data?format=v1
-
Is there a limit for parallel processes
Hi Community members, I am using Anaplan Connect v2.0 to import/export data in Anaplan. I would like to understand whether Anaplan allows multiple processes to run at the same time, or is there is any limit that it can run only one or a few at any given point of time? Any documentation link which I can refer for it, will…
-
Help figuring out Data Import into List Action
Hi, I have a Action that was not set up by myself and trying to figure out how the Action is working. How I'm interpreting the Action is that it populates the List by Puling LI's from a module called D02a. But that module is dimensioned by the List so I would think that List would have to be populated first. So I need help…
-
Anplan import job log file in CloudWorks integration
Hi All, I have created a integration task in Anaplan CloudWorks using Anaplan import action. I am not able to get log / error log file (in case import action ignore rows due to duplicity). Is the any way to get error log / log file on email from CloudWorks Anaplan import integration task ? OR How to get error log / log…
-
CloudWorks vs OneCloud
Hi, Can anyone explain the difference between Cloudworks & Onecloud & when to use what? I gathered that Onecloud has both cloud & on-premise options as compared to Cloudworks, however I'm not sure which is more effective - features wise, cost etc. Also, in terms of Data Integration with ERP tools (cloud/on-premise) - how…
-
Community perspective: Add a timestamp to processes utilizing Anaplan API and Python
Anaplan is a critical tool for different business processes, and it is used to handle a variety of data. One key attribute for data quality is the timeliness and reliability of the data. It is a known best practice to use Data Hub for centralized data management and then import data to different spoke models. Even though…
-
Refresh function in Excel Add in should provide option to Select all or Unselect all Worksheets
Hi, I am keen to have a button to select all or unselect all when refreshing multiple worksheets in excel. Any thoughts? Thanks Jerald
-
How to Create Connection Between Anaplan and Power BI with API 2.0
Power BI is a popular reporting tool. One of the reasons is that in Power BI you can get data from different sources, and there is an increased interest of our customers and Anaplan builders to be able to import data from Anaplan. In order to make this connection, we developed a solution to set up the integration. It is…
-
Option for the default file format for new exports from classic dashboards
In a May Anaplan release the platform was updated such that when users in classic dashboards created a new ad-hoc export, the default file format was now .csv, not .xls. In many respects this was an improvement and certain customers preferred the .csv setting, but some customers need the files to be in an Excel format and…
-
Hey, How can i Autogenerate Codes in a Non-Numbered list?
-
Remove Column Headers when exporting
Hello! I would like to export a csv without column headers. I was able to remove the display name, but I can't find a solution for column headers. Can you help me out? Thank you
-
Enable Display Name Functionality on Non-Numbered Lists
Hi Anaplanners, I love the Display Name functionality on numbered lists. I sure could use this across all lists. Sometimes building lists off transaction IDs makes sense but by the time the data gets to the end user flipping to the description would be nice. Thanks!
-
Anaplan Excel Add-in
Hi all, Following a member's recommandation, i'm posting 3 main ideas. I have recently discovered Excel Add-in existence and here are the 3 major points in my mind : First, I think it could be nice to be able to give only permission to retrieve saved views in order to prevent them to see technical items (not relevant as…
-
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
-
Anaplan API: Basic Authentication failed!
Hi, I am trying the Anaplan API connector tutorial and I keep getting an Authentication failed error. I have seen a similar question asked but might is particularly strange. Below is my script. When I include my password in the script I get the failure error. Anaplan API: Basic Authentication failed! (Feign: status 401…