-
Getting data integration right: Best practices for building robust, scalable connections
Author: Dmitri Tverdomed is a Data Architect and Director at Zooss Consulting. Data integration isn’t just a technical exercise anymore — it’s foundational to a business’ ability to move quickly, make informed decisions, and scale sustainably. Whether you’re integrating Anaplan with upstream data platforms or pushing model…
-
Excel Add-In OLE Action
Hi All, I wanted to see if anyone has been encountering this issue with the Excel Add-In. Oftentimes members of my team will go into Excel, log into the add-in, and then the whole Excel Application feezes. It freezes for a few minutes and then comes up with a message box saying "Microsoft excel is waiting for another…
-
API V2 Enhancement - more info about models
As a member of Anaplan Center of Excellence and user of Anaplan Integration API, I need to get more information about models. In old version of API (1.3), we could get more information about models than in newer one (2.0). The missing (and really useful) data are: -'isoCreationDate' -'lastModified'…
-
Efficient Data Exchange: Integrating Anaplan with SFTP Servers
In the dynamic landscape of modern business, data integration plays a pivotal role in decision-making processes. Many enterprises rely on Anaplan as a comprehensive planning and performance management platform. When it comes to data exchange, integrating Anaplan with SFTP (Secure File Transfer Protocol) servers offers a…
-
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
-
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
-
SCIM API（IdP 設定自動同期）手順（Okta例）
こんにちは！ SCIM API（IdP 設定の自動同期）手順 を、Okta を例に 画面ショット付きでわかりやすく資料化 しました。 SCIMとは： System for Cross-Domain Identity Management 複数のクラウドサービスやシステム間でユーザーID情報のやり取りを自動化するために作られた業界標準規格です。 このAPIを用いると、IdP側（Azure ADやOktaなどのSSOツール）に行ったユーザーIDの作成・更新・削除を、自動的にSP側（Anaplan）に同期する仕組みを構築することが可能となります。 内容 SCIM API とは IdP 側の設定 IdP 側の操作 ご不明な点がございましたら、担当…
-
CloudWorks × AWS S3 連携：検証環境作成手順
こんにちは！ CloudWorks と AWS S3 の連携 検証環境作成手順 を画面ショット付きでわかりやすく資料化しました。 内容 AWS 設定手順 ・ユーザー作成 ・アクセスキー作成 ・バケット作成 ・まとめ CloudWorks 設定 Appendix ・CloudWorks 実行サンプル ・AWS S3 オブジェクト削除方法 ・AWS アラートメール ご不明な点がございましたら、担当 CSBP までお気軽にお問い合わせください。
-
OAuth認証を使ったAnaplan Connect 利用方法
こんにちは！ OAuth 認証を使った Anaplan Connect の利用方法 を、画面ショット付きでわかりやすく資料化しました。ぜひご活用ください。 内容 Anaplanでの OAuth Client 作成・設定 OAuth 認証を使った Anaplan Connect スクリプト作成 Anaplan Connect 認証方法の解説 参考URL 関連投稿 🔗 OAuth認証を使用したAnaplan Connectの使い方 ご不明な点がありましたら、担当 CSBP までお気軽にお問い合わせください。
-
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
-
Introducing Anaplan API Python SDK
Author: Vinzenz Klass is a Senior Data Engineer at valantic. Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support…
-
Volumes for DATA02 SKU
Hi team, I have mapped the data SKU.csv as per below screenshot. And under DATA02 sku line items mapped volumes However, only Jan 2019 and Jan 2020 data is visible in the sheet attached jpg, Please guide me with steps to rectify so that volumes are visible under each month.
-
Transactional APIs - Part 3: SQL Query Anaplan data using Transactional API via Data Virtualization
Here’s a sample transcript of conversations I routinely have with our customers who are new to Anaplan platform: * Customer: I have a need to query Anaplan ‘table’ and integrate Anaplan data to my database. Is this possible? * Anaplan: Certainly, using Anaplan Transactional APIs, you can query a saved view and output the…
-
Integration with specific criterion
Hi, I am experiencing an issue with the Anaplan integration where data is not updating in the target model as expected. In the source model, users select the specific PC they want to update in the target, and then run the integration based on a saved view filtered by that PC. The unusual part is that when I run the…
-
CA Certificate Quick Start Guide using Sectigo
Creating an Anaplan CA Certificate using the Sectigo Personal Email Security (S/MIME) certificate involves several steps. Here's a quick start guide to help you through the process: Step #1: Purchase the Sectigo Personal Email Security (S/MIME) certificate from Sectigo's website. You can find it here. The cost is $15 for a…
-
3 Improvements for Comments in the New UX
Hi, I'm missing 3 basic capabilities on the current comments' fucntionality to be able to use it for my clients: 1- Comments are not flagged to end user 2- Not recorded in full context (in all dimensions I'm looking at) 3-No option to publish or export from Anaplan This custom fucntionality I built allows me to overcome…
-
Set text encoding format for anaplan connect script upload
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
-
2.3.8.2 Import into DEM01 Module
Hello, I'm attempting to import Volume Growth Rates.csv. When mapping the time (column headers) on the file, I select Periods, but there is no Y-M or M-Y option. I assume something is messed up that I'm unaware of. Any feedback would be appreciated. Sean O
-
Changing source file name
Hello Community! I´ve been working with Anaplan for several years now and whenever I´ve needed to change the import file for an import action I´ve just created the action again using the new file. This usually isn´t a problem so I haven´t given it a second thought but what if you had 15 actions that are included in several…
-
How can I change my email id
Hi, Please help me here as I have changed my organization and for new organization I will be using different mail id. How can I change my email id from old organization to new organization in Anaplan community. Thanks, Vicky
-
500 Internal Server Error occurs with requests made with API V2.
To export data from the View, a request is made with an API call to download all pages. The View has a lot of data, so the number of pages will be about 100~3000. I am using Azure pipeline to download one page at a time, but when I finished downloading about 120 pages in 50 minutes, I got a 500 HTTP Internal Server Error.…
-
Notification while reaching the threshold of index numbered list
Today, we can reset index list manually in the list setting tab. In our business case, we use a numbered list in a dimension of a staging module for daily data integration. As we erase and uplaod the list every day, the the numbered list index limit is reached very often. With no manual intervention of an administrator,…
-
Comparing SAP × Anaplan integration: Why ADO is the right fit for planning scenarios
Author: Miki Sato is a Product Manager, Product Management Team (Data Management) at Anaplan. To drive accurate and agile planning, it’s critical to integrate actuals from SAP ERP systems (such as S/4HANA) into Anaplan in a structure aligned with its model framework. This article compares three integration approaches — SAP…
-
Data Related Training Classes
Overview This set of classes address how data is used and managed within an Anaplan model: Anaplan Connect (301) Anaplan Connect enables the Anaplan administrator to automate Anaplan imports of data and lists, exports. and other actions from the client. Find out more about this valuable tool in this course. The Anaplan…
-
Regex Formula
It would be very helpful to include a regex style formula in Anaplan so we can pre-process text fields ahead of an integration, or even help to cleanse messy inbound text. Currently if we want to remove special characters, or parse strings into cleaner formats we have to specify one by one the characters we wish to remove…
-
How I Built It: Beginners guide to integrating with Anaplan using Python
Author: Matt Budd, Certified Master Anaplanner and CIO at Nightingale College and Solution Architect at Dialed Solutions. Hello Anaplan Community! In the last year, I've done a lot of work around creating automation and integrations with Anaplan using Python. Several solutions I've built using Python include: Creating a…
-
Action to copy data from one version to another version only for a specific module
Ideally, I would like to setup an action that can copy data from one version to another only for a specific module. For every new version I create, I import new data into certain modules and then I manually copy data over for a specific module. I am wondering if I can just setup an action to select an origin version,…
-
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
-
Anaplan-Informatica Cloud Integration
Hello, I'm hoping someone has had this error and was able to resolve this. Would like your help on it. I currently have a Dev and Prod model setup and I'm using a simple import to a date-formatted line item action to refresh the current date. I was able to set it up on my Dev model and it works perfectly. But when I…
-
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…