-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
How to select only one Boolean line item at a time by disabling all other Boolean options?
I want the user to select only one boolean line item at a time. When the user selects one boolean, other booleans should not be selected, and once the user unchecks the selected boolean, all booleans should be available for selection.
-
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…
-
Setting current time period
This guide will walk through the Time setting in Anaplan models, as well as some best practice recommendations on automating the current time period to simplify formulas and dashboard views. The Time setting is a critical component of the model structure and should factor in long-term objectives and the purpose of a new…
-
Guidelines for model impacts when removing a user from a workspace
Removing a user from a workspace There are two different ways to prevent a user from seeing and accessing models: You can set the user's model role to "No Access." This is set on a model-by-model basis and will prevent the user from seeing the model on the Tiles screen, as well as completely preventing the user from…
-
Parenth
Hi all, a simple one this time. I am trying to get the parenth member of the list. But I keep getting this error. my formula as i remember it is Parent(Item(L3 Department)). then i got an error on it Any idea what I am doing wrong. Appreciate the help on this one. Regards,
-
Matrix Inverse using Optimizer
In the following article, we will discuss how to use Anaplan Optimizer to compute Matrix Inverse. Matrix Inverse as a functionality can be used to solve a Multi Linear Regression Problem in Anaplan. Using Matrix Inverse, we are going to solve the following Multi Linear Regression equation: Y = b0 + b1x1 + b2x2 + b3x3 +…
-
Community perspective: Monitor activity in your models using an action log
Model actions are a useful tool when it comes to automating routine tasks in Anaplan. They enable a wide range of applications such as data integration, list management, or model maintenance. To keep track of action-related activity in a model, we can rely on the Start Date and Time (UTC) column in the Actions pane: A…
-
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…
-
User Access Management: Part 2 - This is how we do it
At Anaplan, we are using Anaplan internally for many of our business processes; this is how we set up our User Access Management. Anaplan User Access overview Unlike most enterprise software, Anaplan is extremely customizable. Access happens at 3 levels: * Page builders are provisioned at the tenant level * Model builders…
-
Add create action to a process??
Hi, I would like to add a Create action to a process, but I can't seem to. Does anyone know how to do this? Thanks, Ethan
-
How does Authentication with CA Certs work?
Why CA Certs? The purpose of this blog series is to give a deeper look on the use of Certificate Authority (CA) Certificates, especially on how this method of authentication works and how to use them for your different integrations. A Quick Recap On Anaplan APIs Authentication We recommend our readers to have some basic…
-
PlanIQ - Probabilistic forecasting using forecast quantiles
Probabilistic forecasts & forecast quantiles PlanIQ produces probabilistic forecasts. This means that PlanIQ algorithms output a distribution of possible values, rather than a single point forecast typically outputted by other solutions. This distribution can be divided into quantiles. Applied to forecasting, quantiles…
-
Community perspective: How to maintain corporate brand standards in Anaplan
Overview One responsibility of a marketing team is creating and regulating the corporate brand standards. Logos represent the most recognizable part of this tool kit, but the choice in color can be equally important when consumers are challenged with recognizing popular companies. McDonalds: Red & Yellow. Starbucks: Green…
-
Seeking Insights on seasonal forecasting within Anaplan: Share Your Experiences and Best Practices!
Hello Anaplan Community, I hope this message finds you well! As we approach the holiday season, I am eager to learn more about how companies in our community are leveraging Anaplan for holiday forecasting. This is a crucial aspect of planning for many businesses, and I believe there's a wealth of knowledge and diverse…
-
2.3.10 Activity: Create Demand Forecast (Big doubt )
Hello Everyone I have a logical question to make sure my approach and formula is correct for demand forecast in question on the LEVEL 2 SPRINT 2 activity . As we see, we have to create the baseline forecast for the current FY by importing the historic volumes data to the current FY from previous year FY19 data which we…
-
Exporting all the URL's from assets
I have uploaded 200 images to the Assets section, and as the url does not use the image name! I therefore need to export all 200 URL's and then create a lookup. I can export 1 URL at a time, but 200 may take a while. Can i export all the URL's for the images anywhere?
-
Is there a way to export a module into excel with each line item on a different tab?
I have a module dimensioned by time and a store list, with cost lines as line items. I'd like to export into excel with each line item as a separate tab. We don't have widespread use of the excel add-in so I'd prefer a way without needing to use that if possible.
-
Community perspective: Version compare and dynamic module line item description update
There are times when we need to generate output modules with the ability for version comparison. Although Anaplan has its own version comparison function, sometimes we need to build a dynamic scenario creation and comparison function. Please see Planual instructions for versions before proceeding with custom versions, as…
-
Process ID
Hi, We are trying to integrate with Onecloud to have automatic uploads of files. For this I need workspace, model, and process ID. I have found the workspace and model id by just looking at the url. How can I find the Process ID?
-
Using Python 3 with the Anaplan API
* Getting Started * Authentication * Getting the Information Needed for Each Script * Uploads * Multiple Chunk Uploads * Single Chunk Upload * Imports * Exports * Actions * Processes * Downloading a File * Deleting a File * Standalone Requests Code and Their Required Headers * Get Workspaces List * Get Models List * Get…
-
User provisioning
We know how good it feels when you start exploring Anaplan on your own. One very important area that needs special attention from you is the Users section in Anaplan. This is the section where you add users into Anaplan or remove users from Anaplan. There are other things as well that you can do in the Users section, but I…
-
Delete from list using selection
Hello Everyone, I have a module dimensionned by two lists, in which I added a boolean "Delete" which is codded by true, and I wanted to create a delete from one of the two lists using selection in the "Action" table, based on that boolean, but when I look for it I don't find it in the droplist of "selected using", which is…
-
Calculate the difference between two dates (days/months)
Calculating the difference between two dates is a common requirement and one that you will likely need to do at some point. Below you will find the best practice for calculating the difference between two days, and the best practice for calculating the difference between two months. While there are multiple ways to get to…
-
Improve Productivity: How to Optimize Scheduling of Products
Business Problem In manufacturing and production planning use cases, we often come across problem statements to solve for optimal product sequence on a production line. As different combinations of products can have different changeover times, a sub-optimal product sequence can impact the productivity of the production…
-
Stock Re-balancing between Stores
Hi Anaplan Experts, I'm trying to calculate the re-balancing of stocks from one store to another based on the logic below. Step 1: Rank Supplying Stores based on their available stock to give (OUT) Step 2: Rank Requesting Stores based on their needed stock to take (IN) Step 3: Re-allocate available stocks from Supplying…
-
HyperModel: five tips to improve your experience
Are you considering HyperModel for your ecosystem, or have you recently deployed it? Fantastic! We've compiled a shortlist of the top five tips to help make kicking off your HyperModel experience as smooth as possible. Check out these top five tips to improve your experience: 1. Recognize that the Hyperblock has not…
-
Dynamic Display by Language Selection
Problem Statement Ever wonder how to display your data in a different language format in Anaplan or simply just want to cater to language display options based on user selection? Step-by-step guide We need all the lists that require translation to be defined and it is best to have modules with definitions of each language…
-
Community perspective: Anaplan user license management
What is an Anaplan user license? Users get access to Anaplan based on the model role provided to that user. From an Anaplan commercial perspective, each Anaplan user is consuming one active Anaplan user license. On a high level, Anaplan has the following three types of user licenses: * Model builder * Contributor * Viewer…
-
[Start Here] Anaplan Connect 2.0 and JDBC Connectivity
* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Integrating with Snowflake * Integrating with Azure SQL Database * Integrating with Google Cloud (GCP) BigQuery * Integrating…