-
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 +…
-
How to edit the display name property of a numbered production list in a deployed model?
I can add items to the production list but can't edit the display name. Ps. It's a deployed model
-
Multilevel Adjustments Removal of checkboxes
Hi Everyone,I am working on a requirement where the customer wants adjustments at multiple levels and we are working with multiple hierarchies so there are a lot of combinations (total level combinations also needed). Now at the dashboard level the user comes in and selects levels from dropdowns and then clicks on a…
-
Track Filter dependencies
Filter dependency should also be considered in module to not miss any referenceability.. this will help technical team immensely!
-
Option to export conditional formatting in export to xls
Description of the enhancement: Add an option to include conditional formatting in exports to xls
-
LOOKUP not behaving as expected on production list
Hi all, I'm trying to understand why using LOOKUP on custom versions from a SYS Constants module isn't behaving the same as SELECT. I recently converted all of our custom version lists to production lists to help save space in the DEV/UAT model. As part of that change, I updated all SELECT statements referencing custom…
-
Splitting out a text field using a delimiter
Hi Everyone. Just wondering if anyone had managed to find a way to split a text field out to show all characters to the left or right of a delimiter, rather than a specific number of characters. (Similar to the way it works in a Text to columns formula) We have had a change in our HR system, and for our Egypt staff their…
-
How do I do this? Create Forecast Periods Saved View In the model, open the OTH01 Non Employee Expe
How do I do this? Create Forecast Periods Saved View In the model, open the OTH01 Non Employee Expenses module. Create a new saved view: Filter: Forecast Months only Save and name the view: Forecast Periods When there are no versions used? or am I missing something?
-
Rank Error with Multiple Dimensions/Lists
I am building a module that is ranking the Cost Centers for the Corporate segment based on the amount of Expenses per Employee (USD) that it has accumulated in 2023 for the Travel & Entertainment account and the Employee Relations account separately. The time dimension includes YTD, QTD, and Month. I want the rank to…
-
How to Bring in Value from Other Module
Hey Everyone, I've been working on Anaplan going on a year and still working to build on my modeling skills. I ran into an issue with a live production module we have. I have two modules I'm dealing looking at: Module A - Dimensioned by tiers (Range for achievement bounds), E1(Employee list) subset on a component type and…
-
Source Model view model labels
In the Source Models view, when you change the name of a model being sourced, the name change does not carry through to the Source Models view. This can cause confusion. Can we have the Source Models view reflect the updated Model names being sourced.
-
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…
-
1:1 allocations in dependent Line Items
Hi, im quite new to Anaplan, so I do not know several features. I want an 1:1 allocations from a List to a List/Module Im working with Line Item Dependency, that works so far, that only child items can chosen from the same parent. But what doesn't work is that I mustn't select multiple times the same item. i tried with a…
-
List Hierarchy Update Failure
Hi All, I am trying to update a composite list hierarchy with 2 levels they are both Numbered List. In the source module the List being imported are NOT a numbered List only in the PROD model it is set to a Numbered List. Here is the Parent List and Code is concatenated with _L1 Below is the child list that Rolled up to…
-
How to Apply Filter in a module with respect to Dynamic Time filter
Hi, So I ran into a situation where we had provided User specific Dynamic Time filter for Months/Quarters/Year. Now I want to Display only Non-zero Values in my Module W.r.t the Dynamic Time Filter. So, If I select Quarter FY25 then only those line items should appear which has values and when I change the Dynamic Time…
-
Returning a Blank in a IF THEN ELSE statement involving a list
Hi, I am looking for a way to return a blank for an IF THEN ELSE formula involving a list: IF x AND y AND z THEN Values to lookup[LOOKUP: Mapping] ELSE Return a Blank The Return a Blank part is what I am having an issue with. I can't use 0 or "Null" as the format of the line item is a list, is there a way to return a blank…
-
Hello! How to set value as TRUE based on other line item value
Hi everyone, I'm wondering if someone could help me with this. I would like create module like picture below. I have general list "Summary SKU" and "Detail SKU". These general list are not having parent-child hierarchy for each other. Then, in Line Item "Delete Detail SKU", user will check the Detail SKU they want to…
-
Setting up dynamic list of values
Hi We have a requirment as below. We are setting up a General List to track the consumption of hardwares at different sites in the world. There are two columns in this general list. One is Combination which can have three values (Region/Country/Site). The next column is Combination_Name. The idea is based on the value…
-
Cloudworks API: Change Schedule
I'm working on a script that would update integration schedule. In future my target is to have a script that would move all my integrations + integration flows +/- 1 hour on DST changes. For updating integration shedule I have sent PUT request to endpoint…
-
Case - % Increase on Previous List Item
Hi All, I am working on one use case where need to calculated the value on the basis of previous list item. Module doesn't have a time dimension. But I've created mapping module to identify the previous item. Please see below screenshot for your reference. Final Value = Previous (final Value)* % increase. Can you suggest…
-
Forecast Phasing with Adjustment Issue
Hi All, I have a module that I am trying to do a phasing . (a) Forecast Amount: have an even spread amount as (current best guess) and Total spending amount for FY23 is 22,000. (b) In the Adjustment Line: I want to enter an adjustment for certain months with a new amount (Due to the knowledge of certain month will incur…
-
How to forecast the data in anaplan?
-
How I Built It: Fantasy Football draft
Author: Zach Hird is a Certified Master Anaplanner and Senior Consultant at Peloton Consulting Group. Hello Anaplanners! Learn how I used Anaplan to aid my fantasy football draft experience in this fun and different ‘How I Built It’ tutorial. I use live fantasy football data to give myself a competitive advantage while…
-
Quarterly Account Sales Revenue Targets
This data from here is impacting a lot of things and I am not sure if the % taken to distribute the Sales Target over the Quarters is the same as PY Account/ PY Country Product Family. Help plx!
-
Comparison with y-1, results from last year
Hello, I'm trying to build a module, where we compare the results with the results of one year earlier. Whey we change the year or date, the columns highlighted in yellow, should automatically show the data from one year earlier. How can I do this? Using a formula?
-
Unbind a flat list or a module by busbars
Please, someone could help me to desconcatenate if it is possible the flat list and if not a module Thank you so much
-
UX Page cells data alignment
Hi all, I have published a Grid card on the UX page and I want the cell data to be centered in alignment as you can see in below image it is towards right corner and really want to know where to explore on these alignment options. Below is the screenshot of the grid card As I understand this is a basic function however,…
-
How to create an alternate/Parallel hierarchy
Hi Team, I am new in the Anaplan. Could you please explain me how to create an alternate hierarchy with example? Thanks!
-
multiple developers are working on different enhancements to the same model
We have two approaches to manage scenarios where multiple developers are working on different enhancements to the same model, and we need to push their changes separately into the production model: 1. Rollback Method: After completing a build in the development model (in standard mode), the developer meticulously documents…
-
ALM syncing when multiple developments are happening
We have 2 developers working on the same model in different modules. One has completed his changes but the other is not ready to sync. Unfortunately you have to sync the whole model, and this means partial changes would then be synced. If the first developers' changes are urgent, waiting for a major change to be finished…