-
Cert Auth without SSO enabled
Will a user account (api user) be able to use certificate auth for api calls after the 3 month password expiration without SSO being enabled? The Anaplan articles seem to indicate SSO is needed but I just wanted confirmation. I am hoping that cert auth will last until expiration of the certificate regardless of SSO. Thanks
-
Alternatives to connect Anaplan to Tableau
Hi, We are connecting Anaplan to Tableau in one of our engagements, where Tableau is the downstream system. Currently we are refreshing Tableau data or pulling data into Tableau via Anaplan-Tableau connector (which is native to Tableau). However, as per Tableau 2023.1 release, Anaplan connector will be depricated in 1-2…
-
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…
-
OTH01 Module Import from INV05 saved view
I got expected saved view created for INV05 and was working on importing this view into OTH01 in FP&A model. Kept running into an issue where location 'Mumbai' was not found - weird issue with all other locations mapped properly. I was able to solve this by re-importing G3 Location list from Supply Chain Model into FP&A…
-
Anaplan Integration with Alteryx
I'm currently experiencing an issue with a new Alteryx to Anaplan connector. I've setup the import and mapping process similar to how we map for Anaplan Connect. I create the imports manually, map the file as "Admins Only" and then add it to a process. On the Alteryx side I reference the process name as a part of the…
-
Anaplan Integration Sript Generator
Hello, I have just recently heard about an Anaplan Integration Script Generator which really looks like a game changer. Does anybody know how to access it? I can't seem to find it anywhere. Many thanks, Luca
-
Bulk API Import (Files have extra rows, no one else can see files)
Good day, I'm wondering if there's some kind of parameter I can add to my file upload request that ensures the file uploaded via bulk api does not have extra rows as I see on my end. Also, is there a way for everyone to see the files uploaded using the bulk api?
-
Anaplan Connect and SCIM API
Hello, I'd like to use Anaplan Connect to get user informations through the SCIM API. Is it possible ? If yes, how to do It please ? Regards
-
Unable to onboard whole data into Anaplan
Unable to onboard whole data into Anaplan Source data: Translate business process into Anaplan components Expected Result: Translate business process into Anaplan components Onboarded data into Anaplan: Translate business process Please guide me!!
-
Export Action
Hi Members, Can someone please guide me, how can I create an export action? As Export Action is not displaying.
-
How to integrate from Anaplan to ETRM through API.
Can you please help me on how to integrate data from Anaplan to ETRM, with API's, or if I can get API's script by which I can change workspace and model id and use that script.
-
Anaplan API : Could not connect to database!
Hello, I'm following the Data Integration Training - Part 2 on how to use Anaplan Connect to import data from a relational database. The training suggests an access database named Employees.mdb. Upon execution, I encountered an error (please refer to the screenshot attached). Any help will be highly appreciated. Thank you…
-
How to upload multiple files using multiple import actions with one Anaplan connect script?
Currently I am using this script, it is unable to upload the second file @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit…
-
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
-
Automate refresh from Anaplan to Google sheet.
Hello, we've established a connection between an Anaplan module and a Google worksheet through an Add-on. What are the available methods for setting up an automated refresh schedule from Anaplan to Google Sheets?
-
Anaplan Connect API not found
Hello, I'm trying to use Anaplan Connect. Everything seems to be OK (Java, authent, proxy). But I have an "API not found" error. It's a simple script listing all processes (It works with Postman) @echo off setlocal enabledelayedexpansion AC_PATH=C:\Users\UBQLZC\Desktop\anaplan_connect_4.2.1\ set…
-
Anaplan Connect - No errors but no data uploaded
Hello, I'm working on the first activity in Anaplan Connect training-Part 2. The Goal is to upload a list of employees to the Financial planning module. I have diligently followed each step outlined in the training. Upon executing the script, it reports that the file has been uploaded. However: I am unable to observe any…
-
Integration Account Access Settings
Hi Everyone, Hoping there is easy setting for this that I am just not aware of. We are trying to keep our integration account that we use with Anaplan connect as a non-workspace admin user. Occasionally we have to take the model offline, but still have hourly connect scripts running. Because the user is a non-admin and the…
-
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…
-
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.
-
Boomi to Anaplan Connector Failing - Password expires every day
We have Boomi integration to push data from Netsuite and Openair to Anaplan. Boomi is using Basic Authentication with Email and Password and WE DO NOT USE ANY SCRIPTS. Just one connector object with Basic Authentication and is the only place we give the password and user id. All the jobs keep failing early morning every…
-
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…
-
Anaplan Models Not Opening Up/Loading
I am having multiple models not being able to open up in different workspaces. It's stuck on the loading screen and I can't even access production models.
-
Anaplan Power BI connector - not refreshed from Power BI
Hi all, I am working with Power BI connector for the first time and have a problem with the Refresh part. The first time data from an export action is imported into Power BI by Power BI dev team, everything is OK. When numbers are changed in Anaplan and a manual Refresh is done in Power BI, data is not refreshed. If I test…
-
Managing Hierarchy with members moving between levels
What are the ways of Hierarchy Managemnet when, list member are moving between levels? For e.g. the file we recieve from Third Party system, is used to create the hierarchy. This Data Module contains line items referring to various Levels L1, L2….. First Iteration of Data Import gives us say an L7 item with its respective…
-
can we send a file name into the process api?
Hi: I have a Process which contains delete list, import list and update module action, as import action need users to pick a file from their computer, do we have any API for Process that can receive the file name? I want to use ETL tool to call this API and send the file to it. I know the Import API can receive the file…
-
Help with Level 1 model builder 7.2.3 : import issues
Hello ! In the import, commission % is 0.15% but when it appears on my dashboard Anaplan it writes 15% which is not the same ahah I tried to change format in blue view but I don't know what to do ?
-
Anaplan Connect - Script Import Files
Hello I used the following script provided by the Anaplan Connect guide to import files: set AnaplanUser="useremail:password"set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set WorkspaceId="8a81b09e5f88df6e015f9773e37c675f" set ModelId="FCDBA62F401B40E9B73A42983C4FDDCC" set Operation=-debug…
-
Cloudwork export don't include the time stamp
Is there a way i could exclude the time stamp? i basically don't want anything that's from _January until 034607. Thanks.