Modeling

Options for Override
Hi I have a module containing values that need to be reviewed and adjusted by an end user. The values are likely to need to be changed and there is often a high possibility that the value to override with is zero. The data is often copied between different dimensions. What options are available for methods to override…
why is my formula not returning any values
I have a numbered list in Anaplan (#Job Profile) this list has a Unique Code for each of the members in the list. the list also contains property line items called "Comp Code" and "Comp Location" I have data module that is being populated with Comp Code values and Comp Location values. What I am trying to achieve is to use…
L1 Question 6, getting 0s
Hello, I have entered the following formula and I'm getting zeros on the Employee Expense Summary. Any ideas?
Using LOOKUP on multiple properties in a Numbered List
Hi - Wondering what is the best/practical process here. I have a Numbered list (#Job Profile) with "comp code" and "comp location" as properties (Attached for reference). I have a module has the Job Profile Code (Job code = comp code) and Connect Comp Location, the data/line item by itself is not unique but the paring…
Sprint 2: DEM02 Module Formula
Hey, When creating the DEM02 Volume Growth Rates by Week module, the activity wants you to "Write a formula to pull Volume Growth Rates value (in months) from DEM01 module and convert to weekly value". However, under the Anapedia resource it links to explicitly states that the functions listed can aggregate from Weeks to…
how to convert date to text
Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)
Demystify non-linear optimization: Episode 2
Episode 2: Changeover optimization In Episode 1, we discussed how to configure optimizer to evaluate IF-THEN logic and multiplication of two binary variables. In this episode, we will be discussing how to solve a changeover issue for the beverage manufacturer. Changeover on a production line happens when the production…
Where is the data coming from?
There is an error in the data in the spoke so I looked and the the spoke indicates that the mapping came from this module in the Data Hub. However, the data isn't flowing through in the Data Hub but is coming through in the Spoke. Is there anywhere else I can look? I've tried pivoting the view but no data pulls through at…
Cell history changes publish as report under NUX pages
Based on my understanding, currently users have to click each of cells in worksheet/ grid just able to see the cell history. Or Admin users can run an action to export change history. Is there any method to publish cell history to NUX pages (1st preferred way base on our current client request)? Or non-admin users can…
Find earliest date and latest date in a non time dimensioned list
Hi, I've got a module, dimensioned by a list (numbers), and line item with the dates of various cashflows. This module is not dimensioned by time. How do I find the minimum value i.e. 23/04/08 and max value? Any help is appreciated, Thanks
remove double counting of projects
Anaplanners, I have a query on how i can remove double counting of Projects. Case artifacts: T1 Teams, which is a hierarchical list, so for example Team A.1 & Team A.2 rolls up to Team A, like wise Team B.1 rolls up to Team B; all rolling up to total teams. M1 Members: Flat member list. P1 Projects: a Numbered list of…
Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module
Hi, Can somebody please tell the formula for this line item in this activity? In the Supply Chain model, create a new module: * Module Name: INV03 Distribution Center Summary * Dimensions: P2 Products list, s G3 Location: Distribution Centers? list, Time (month) * Category: Inventory * Functional Area: Inventory * Summary…
Level 1 Lesson 6 - 6.6.5 Activity: Add Formulas to Time Settings by Year Module
Hi, Can anyone help me with below? I don't have FY20 and FY21 checked (see below), however, the example has them checked
Use KPI Cards to Hyperlink between Apps
Use KPI Cards to Hyperlink between Apps Provide the ability to enter a custom URL in a KPI Card that allows users to click on a KPI card and navigate to a separate Dashboard within a separate App or external website. Currently KPI cards can only link to Dashboards within the same App.…
Allow model builders to differentiate models by changing the color of the "Anaplan" blue header bar
We have many different models our team of builders uses, all of which have a slightly different name, but sometimes that's not exactly obvious if one is working in the Revision 1 model, or the Revision 2 model, Staging, or Production etc. I would like the ability to alter the color of the blue anaplan header bar so that I…
Problem by selecting Zone with my Export button on UX page
Hello, I have created a UX page, and I would like to add an export button in it. The export button should export : Fixed unit of measure (here PAL or TO) : I would like 1 button for PAL and another one for TO Flexible Country Zone : Depending of what it's filtered by the user I succeed to do the first point, however I…
[First Look] Create page
Feature: Create Page Release Date: 02/28/23 Impact Assessment: Tighter link with UX What is changing? A new button is available in the Pages interface called “Create page” that gives you the ability to create a page in an existing app. Once the button is clicked, a new tab will open that will allow you to setup and design…
Option to add multiple models in App[Multisource App] at one go.
Hi Team, Currently, We are using a multi-app set-up (Dev, Test, Prod) for our UX apps to a single app enable with multiple source models. But we need to go page by page and add the multiple models. It's very time consuming process cause if we have around 40-50 pages , we need to do one by one. It is better to have option…
Performance affect of "SELECT:" and "LOOKUP:" used together
Hi community! I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as LOOKUP (thanks to @DavidSmith for insight). So does it mean that SELECT and LOOKUP can be used together, unlike SELECT and…
Does Anaplan allow different formula for each versions?
Hi! For example I have 4 versions namely: Actual, Budget, Forecast 1 and Forecast 2. Does Anaplan allow different formula for each version I have in my module? Say, Actual version will have a different and unique formula with Budget, etc for the same modul. Thanks for any help!
Level 3 Sprint 1 3.2 Model Build Specifications
Should I be creating a separate module for the Volume Growth rates by country and then using a lookup to pull in the requisite %'s into the TRA01 module?
Apps > Report: Add Variance between rows
The new feature in Apps > Report to add variance between columns (as shows in the screenshot) is fantastic. It would be very useful to have the same feature to calculate variances between rows, but this is currently unavailable. It would be greatly appreciated if this feature could please be added as soon as possible so we…
How to Use DCA to deactivate boolean selection?
Hi Community I have 2 list. List A & List B. I have created one module using list A and there are two line items Product Family (Formated as list B) and Applicable?(Boolean). I have to disbale boolean if I select Appliacble aginst other list item if I select A(Other A should be not accessible) while I can tick boolean of…
Error Pop up for Ignored Mappings(Subset List)
It would be great if we have the functionality as below. Current functionality: When importing a sku volumes and in the SKU list SKU1 is not there we get an error saying "Item not located in SKU list". Similar functionality as above for , example if we have subset of SKU list(SS SKU list) and the SKU1 is present in SKU…
Formula for Subsets
Add in a formula functionality to conditionally add items to a list subset, rather than having to manually check a boolean.
Assistance needed adding a column filter to a UX custom view dashboard
I'm trying to add a filter to the columns of a UX custom view and not getting the expected results. Any assistance would be appreciated! Purpose of model – allow users to allocate employee salaries to multiple locations. Model hierarchy: C1 Company C2 Balancing Unit C3 Cost Center C4 Provider (these are the employees) We…
OEG Best Practice: Formulas and their effects on model performance
Details of known issues Challenge Recommendations Performance issues with long nested formulas Need to have a long formula on time as a result of nested intermediate calculations. If the model size does not prevent from adding extra line items, it's a better practice to create multiple intermediate line items and reduce…
Button
Hello Everyone, I have a question. The button below "Show Accounts without Category mapping" but as you see in the table "List of Accounts and Mapping", accounts are showing up that have category mapping. Does anyone know the possible reason for this and potential solutions on how this can be resolved?
Level 2 Sprint 2 2.3.10
Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please? - DEM01 screenshot 1 (DEM01) - DEM02 screenshot 2 (DEM02) - DAT03 screenshot 3 (DAT03) - Formula: IF 'SYS01 Time Settings By Week'.'1st Forecast…
List Formatted Line Item-Dependent Drop Down
Anaplanners, I have a line item which is list formatted, wherein end user selects a list item. List: R3 Category List: List Items Important Semi Important Not-Important with a top level item "All Categories". Problem: User is also able to select "All Categories", which is actually a top level item and should not be the…

Modeling

Discussion List