-
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…
-
Set up Aligned DCA and Selective Access Management
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. On a list level, you can use two ways to manage the access: Dynamic Cell Access (DCA) and Selective Access. There are benefits and limitations for both approaches. I'd like to share an approach that could leverage the…
-
Python API - 401 - 'Auth scheme not supported - AnaplanCertificate'
Hi all, I tried to use the certificate authentication method with the Python API. I used one of the many Python scripts provided but I get a 401 Response : 'Auth scheme not supported - AnaplanCertificate'. Do you know if it is required to enable the Anaplan certificate authentication method somewhere in order to use it ?…
-
Activity: Prepare Data Exports - comparing results to INV01 Inventory Ordering.csv
In the Level 2 Conclusion, Activity: Prepare Data Exports, Anaplan gives a csv to download and compare our results to. Is anyone else having issues with their numbers tying out? After a lot of analysis, it seems the Weekly Order Schedule that I uploaded from the Level 2 Sprint 3 exam is not what should actually be loaded.…
-
Time dimension formula
Source Module has Year, Target module has Months. Source - Time dimension (YEAR), Cost center dimension, Line Item Target - Time dimension (Months), Cost Center dimension, Line item Source has rate by year, for example for FY23, Want to bring FY23 rates to all the months in target module. What formula would i use in terms…
-
New UX - Allow page builders to enable / disable the "Model is busy" notification
It would be great if page builders are able to control if the "Model is busy" notification appears on a page. We have been recently seeing instances where the "Model is busy" appears on worksheets for a few seconds, which causes the whole table to "Jump" around which some end users have voiced grievances to.
-
CloudWorks - possibility to cancel Export Process
It would be nice to have an option to stop export process to external data bases in CloudWorks. We ended up a few times with situation where a process exporting data to Google Cloud was stuck for 16h and it could not be stopped by us or by Anaplan Support.
-
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…
-
January 2024 Community Member Spotlight: Tristan Silverio
We are thrilled to kick off 2024 with our latest Community Member Spotlight, @TristanS ! Tristan has been part of the Anaplan ecosystem for the last eight years and an active contributor in the Community for nearly seven years. Continue reading to get to know Tristan, his inspiring Anaplan journey, and contributions below!…
-
Formula
Hi, This strikes me as a very simple question, but I cannot seem to find a working solution. I have a module which list a number of Farms
-
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
-
Formula SUM
I have A List of Farms - 'FarmNames' - showing the Farm name, and a Property - 'Shop NameShop Name' -which shows the shop the farm serves. A module - 'Farm Apples' - showing the name of the Farm, and the manually entered number of apples by month for the past two years, where apples is the only line item. I want to show -…
-
Assign values to duplicate items
Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like below UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan 5 A1 25-Jan 6 B1 25-Jan I want to…
-
Is there any way to export the line items wise view, by using export action(date format line item)
Line-item kept in page selector as Date format
-
Linking Personal Pages
Hi there, upon a quick search in Community I did not find anything about this issue. Please let me know if it is a known issue. I have created 2 personal pages, and linked perosnal page A to personal Page B using a Text Card. When using that link to go from Page A to PAge B, Anaplan does not find the Page B. Still, I can…
-
Allow tenant administrator to add/delete workspaces
Hello, Currently we have to reach out to our account manager if we have to add/remove workspace or reallocate any space between workspaces. Is it possible that Tenant admins are given this functionality?
-
Full deletion of historic users in Tenant Admin
Hi, currently within Tenant Admin, this shows all the users who have ever had access to your Workspaces. You can disable them on Tenant, and delete their licence within the main Anaplan platform for your Workspaces, but you can't currently fully delete these users on Tenant (as far as I'm aware!) I would like the ability…
-
Setting time as forward 52 week
Hello, For my model, planning cycle we look at it forward 52 week. The planning cycle start at the beginning of each quarter. so if we are in Q2 2024, 52 weeks will be from Q2 2024 - Q1 2025 I see option to set week as calendar type but for planning year, I can only select complete year. The only option I have is to select…
-
Track Page Usage by User and Model Role
It would be great to be able to see which pages are most utilized by our users. This would allow us to be more strategic with future page building, while also allowing us to remove pages that are no longer being used, thereby reducing clutter for end users when navigating between pages. Having the ability to view these…
-
NUX quick sum selection cannot exceed 1000 entries
When quick sum in NUX are performed for over 1000 entries then no sum are displayed, due to "Your selection exceeds the amount of data that can be retrieved from the server". In the classic dashboards up to 10000 entries could be displayed. This might protect performance, but some users are concerned on transitioning into…
-
Change fiscal year without losing Data
Hi Everyone, Is there a workaround to change the fiscal year of a model without losing the data? My colleagues made their planning in a model that has timesettings for 2018, but they want to change the Fiscal Year to 2019. is this possible without erasing their data (which is manual input)? The Model only knows the current…
-
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…
-
Line Items: Are there more than 50 line items in a module?
When is this a problem? When any module includes more than 50 line items. Why is this a problem? It goes against the best practice, which is to not include more than 50 line items in a module. How to correct: Break up the module into separate modules, especially if any of the line items use subsidiary views.
-
What does an Anaplan model Builder do?
Ans;-Your job is to unlock the power of the Anaplan platform. You will design and build your Anaplan models, prepare the data to serve your end-users, and deliver a fantastic user experience that drives Anaplan adoption. This tailor-made onboarding site serves to provide you with the information you need to be successful.
-
Bill of Material Explosion - Best Practice
Hi, Pondering my head around a Supply Chain use case where a bill of material explosion is required with an undefined amount of steps to get to the lowest level. This should be an iteration where an SKU can have a one level explosion or up until 6 levels of bill of material. What is the best practice of Anaplan to set this…
-
3.3.5.3 check your work numbers are out (most likely Dem03)
Hi team, Working through the level 2 model builder course and have hit a snag. My Dat03 Historic values is populated and working as intended with the forecast year pulling the value from the previous year I believe my demand forecast is also working as intended with FY21 pulling from FY20 My issue is my final forecast is…
-
Multi-Dimensional Sorting for Hierarchical Lists
We need a way to sort hierarchical lists by multiple dimensions. Currently, Anaplan's 'Sort Order Action' for hierarchical lists only allows sorting by parent or by child, which limits our flexibility. Problem Statement:Currently, when working with hierarchical lists, the sorting functionality is limited to a single…
-
Use of Generative AI for planning functions
Hello There, I wanted to bring to your attention the potential enhancement of incorporating Generative AI into the planning function within the Anaplan platform. The integration of Generative AI capabilities has proven to be valuable in various business sectors, and it's an aspect that warrants consideration within the…
-
Sort on multiple line items like Excel
To enhance the usability of UX grids, it would be nice if users had the option to sort on multiple line items at once. This would mimic Excel functionality that allows for multiple fields and sorting logic in one sort: