Modeling

Optimizer - Variables min, max setup
Hi, From the optimizer user guide v01, for variable section, it states the min/max configuration are optional (as below and see the attached full document). So the optimizer has been configured without min/max. However, it flows an error when execute. Then, I configured the Min as zero and it executes successfully. If the…
Dropdowns in modules
Could someone help me how to bring in the dropdowns e.g. 'New York' or 'Volumes' into data modules?
Waterfall Chart Issue
Hi All, I am trying to build a waterfall chart and issue i am facing is on the End Total. Scenario - Publish a waterfall chart of basis points value ( not absolute numbers ) or you can consider the percentage value. We have a baseline and division wise input as basis point, we have show the movement across divisions and…
this is the order I have selected. It is correct with fronttoback design. what is wrong here?
NA
Suggestions for Creating a Data Point on a Version, Based on alternate Version
Our model has three key types of Versions - Actuals, Baselines, and Custom Scenarios. I have multiple Baseline Versions and many more Custom Scenarios - the end-user will be able to select which two they would like to use. My thought is a drop-down List of the Versions for "Baseline" - all other modules on the dashboard…
Assigning No Access for a User. What happens?
I'm trying to understand what this means. What exactly can get deleted as a result of assigning a no access to a user.
TIMESUM Function with aggregation method AVERAGE
Hi, I am using TIMESUM function with AVERAGE as aggregation method for specific from-to period. Some of the cells have the zero values in it, but this functions is considering those zero cells also into count . This gives me wrong average. How can we skip zero cells and calculate average only for non zero values with…
List : modification
Hello, I would like to create an easy way to add or delete some items from a general list for the end user. I saw that i can create an action button "create" to do that, but i can't find the list Do you know why, or how I can do that ? Thank you,
Optimal if statements
I want to make sure that I optimize my if statements, hence some question * If you need to get a maximum of two line items, is it more efficient to use an if statement "if a > b then a else b" or to use the max formula "max(a,b)" * Is there any performance difference in "if x<y then a else b" vs “if y<x then b then a” (in…
NUX: Enlarge freely a Text Formatted Line item published as a field
In the old UX, when you published a Text Formatted Line item, you could make the text box as big as you want. In the NUX, when you publish a Text Formatted Line item as a field, the size of the text box is limited. I would like to be able to freely choose the size of it.
Retrieve List as Text used in Module
My model has a vintage or "Book Year" dimension which is being used as a list - we model that particular year's performance over time. I'm trying to create a module to result in a Boolean at the intersection of the Book Year and the Calendar year. I'm using a YEAR(ITEM(TIME)) = BookYear. However, I cannot seem to find a…
Clear launchpad filters without selecting reset
Description of the enhancement required: We would like the ability to remove filtered values individually, instead of clicking 'Reset' and refiltering the entire model list from scratch each time to wants to remove a filter value. An example of the enhancement: Login to Anaplan.com > Within the launchpad, click Filter to…
Show the current/logged in user in a single line item
Hi Community, I'm looking for a solution to show the current/logged in user in a single line item that has no dimensionality. The use case for which I'm looking for a solution is a dynamic filter based on the logged in user + to calculate totals based on this filter. More specifically, I have a mapping table dimensioned as…
Level 2 Model Building: Sprint 1 - Prepare for Spring 2
Hello, I have finished the Level 2 - Sprint 1, and am in the preparing for Sprint 2 section. I am stuck at the section of importing from the saved views. After I downloaded the model and saved in my own name, there are no saved views to choose from? Am I going to the wrong place for "in the Data Hub model"? Any advice on…
Import mapping issue
I have an excel sheet which has to be imported into an module. It has columns A,B,C,D and from E Column it has Time Dim and each of these have data. PFB the screenshot as below. In the Module, A Column, B Column, D Column are lists and C Column is just an text filed which has to be imported. Hence I created a line item for…
Loading an Anaplan Model: 504 Gateway Time-out
Hi all, I have recently been facing a lot of 504 Gateway Time-out messages when trying to load Anaplan models. I have narrowed it down to trying to open an Anaplan model and then switching tab on Firefox, so that the tab that is loading the model is not active. I have tested on other browsers and they do not seem to…
Mapping group
Hi team, I have problem about mapping between entity, entiy(holding) and group. exp: entity H have transaction with entity G, but they in a different group (H in group 3, and G in group 2), we can elimination if H and G in a same group, but group 3 and group 2 in the same group 1, so how to create auto mapping using…
editing module name
Hi Team, Can we edit the name of the module once it is created? eg module name entered is - REV01 Price book module edit version of module - REV01 Price Book If yes, then how to go about it?
Customised Time Scale
Hi All, I have a module with customised timescale. In Module A, dimensioned 24 Week Custom Timescale. In Module B with no dimension, I would like to get Sum of 12 Weeks from Module A. Any leads, please? Thanks.
How to obtain start month of a financial year?
Hello Experts, I'd like to obtain start month of a fiscal year. What I have now is current fiscal year in number format. And what I want to do is to compare item(time) and start month of a fiscal year, and get boolean for this, if item(time) is larger than start month of a fiscal year. thanks in advance. Regards, Inoue
Calculation Inquiry
Hi, PLease see details in the attachment. Regards,
Model builder L1, Part 4 subsets - subset not showing in list
Hi Can someone advise, please? I created a subset for E2 employees, as instructed in the video. I went to E2 employees - subsets tab and created it. In the next section the course says to check if I have all lists and subsets. However, I do not see the subset in my list. But it's there under E2... so am I missing something…
Optimizer Exercises - Production Optimization
Hello, I have just done the Optimizer exercises Optimizer: Exercise Walkthrough created by @mark_godfrey , and have an error in the Production Optimization Exercises example. While its possible I messed with the base data, I'm getting exactly the same answer as a colleague. I compared my answer to Optimizer: Use Case…
Old idea that needs attention: Formula scope on combination of Actual and Current version
This request has been posted already in 2013 & 2018 and probably in the years in between. It is not availbale yet, while it will solve a lot of problems for many of our customers. If you do not want to change a previous version, then the option for Formula Scope needs to be put on "Current Version" this however blocks all…
Organize Actions after Model Building
After completing model building activities, we need to prepare the model for User Acceptance Testing, one of the requirements is "Review and organize the Actions to rename and add repeatable actions to a process and remove any single-use/one-time actions"... When I look at the actions, some imports were conducted multiple…
How to make the list of views (used/unused)
Hi, if the model contains an unused views, and i would like to delete the views to make it more maintainable. Is there a good procedure for making like this list? moduleX - View1 - used in dashboadA moduleX - View2 - used in dashboadB moduleX - View3 - unused moduleY - View4 - used in dashboadA →so i delete "moduleX -…
-Shipping time weeks
Hi guys I am trying to figure out how to populate the shipping time weeks line item from shipping method and the shipping metircs module. I know there is a level mismatch and so I created a staging item PARENT(ITEM(P3 SKU) and attempted to do a lookup on that as well as the shipping method line item.
Need Help Regarding NPV
Hi all, I need to replicate the formula from excel of NPV. I've months of first year that sum up to a Year followed by 4 years. Below is the structure of module. Line items are in version dimension - That's a problem too. col- Jan 20...Dec 20 FY1 FY2 FY3 FY4 FY5 NPV Row having no. list I need to apply NPV on yearly level…
Replication Initial flow costs to subsequent Flows
Hi Anaplanners, i am working to meet a certain requirement ,wherein cost incurred in transferring goods from one country to another(referred to as a Flow) needs to be auto captured based on the first flow for all other subsequent flows of the same nature identified by a unique code. Even if the costs for subsequent flows…
Decimal Format Issue
Hi All, I am facing a strange issue in Anaplan. Hoping someone can help me with this. I have a calculated % field called 'Calc %' The formal this field is set to 2 decimal points and percentage. I have another input field 'Input %' The formal this field is set to 2 decimal points and percentage This field is used to copy…

Modeling

Discussion List