Modeling

Line item type defaults to Number
Hi Whenever I create a line item in a general list or Module, the type defaults to Number and I have to change to the relevant type. As Text is the type we normally use, how to change the setup so that the type defaults to Text instead of Number? Thanks Regards Prabakaran
New Filter Option: "Absolute Value" and "In Between" Filter
It would be very helpful to have a filter option added that allows a user to filter on absolute value as well as to filter by defining a top and bottom range that returns amounts in between the range. Currently, we have built line items as a work around, but these tend to take a lot of space. This functionality should be…
Planual Explained - Day 28
“Rule 4.01-07": Article 4, Chapter 1, and Rule 7 – “Avoid buttons for Navigation”. Use the contents page for navigation rather than clutter the dashboards with buttons Here is how it was done in Pre Planual Era: How often have we seen this kind of layout on our dashboards. That is exactly what should not be done What is…
PLEASE HELP--- Importing a value in the list
Hi Friends, I have a module abd SYS Mod 1. It has no list but only Line Items. I want to import, the Line Item value (ie. Jun 20) in the list. Kindly assist.
Planual Explained - Day 27
"Rule 4.01-04": Article 4, Chapter 1, and Rule 4 – “Turn off module page selectors”. Show the page selector is appropriate but try and drive the selection from a general page selector. Here is how it was done in Pre Planual Era: We used to have page selectors enabled for each grid of the dashboard What is wrong with this…
Level 2 Model Building: Activity: Create DAT03 Historic Volumes Module
Hi guys I am having a hard time importing the Historic Volume file into the module. I think it has to do with the week?
Single formula for different list items
Hi, I have a list called Apple having items A,B, A+B. A+B should contain the addition of data of A and B. In the module i have a line item called data and applies to Apple list. I have to write the logic for Data line item such that the module shows up values for A, B and A+B should have addition of values of A and B.…
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…

Modeling

Discussion List