Modeling

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…
Archiving Multiple Models at once in a Workspace
Hi Team, As part of Administrator activities, we cleanup old/test models in our workspaces to restore the space available. As of now, we can archive only one model at once. This would be a tedious job when we have to archive old training models. Is there a way that Anaplan can provide an option at least for Tenant Admins…
Bulk Copy by Month
In the model, Version section, a user would have the ability to run a bulk data copy between time periods/months across and between versions. The new functionality would include: * Bulk copy - ability to select the specific month(s) to copy from one version to another. * Bulk copy - ability to select the month(s) to copy…
3.3.12 Activity: Create Product Replenishment UX Page - Conditional Formatting
Hi, For this section of Activity 3.3.12 regarding conditional formatting, I have not been able to find the rule to reflect the condition below: * Add conditional formatting to display Ending Inventory as red when the value is less than the Safety Stock Target value. See below the options I see for conditional formatting,…
Level 2 Conclusion INV05 Shipping Export
@Misbah Shipping Costs = 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] This formula for the shipping costs line item is giving me '0' as values. Is it because the formulae I have entered is wrong?
How to look up a line item in a line item subset? LIS help!!!
How do I lookup a combination of a line item and a line item subset, like lookup a line item in a module that has a line item subset? Basically we have a module (processing costs) that pulls in values for our GL data, for example Panel Production Volume M3/8s is 94,374 for May 2023. We have other modules that reference…
4.8.2 Activity: Import Data into E2 Employees# List
Hi All, Has anyone completed exercise # 4.8.2 Activity: Import Data into E2 Employees# List? I am not able to procced with this, can anyone j
Calcuation of subsets as my allocation basis
Hi guys, how can i get the totals of my subsets in my formula so the totals of my denominator will only be the totals of the subsets? Thanks in advance.
Max Value for a Line Item on a yearly basis
I am trying to find the max value in a different line item for any given year, all in the same module. time is in months so my start month would be january and end month would be december. so for 2023 I want the max item, for 2024 I want the max item, and so on and so forth.
Update Historic Volumes for Baseline Forecast
Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…
Omit the calculate lineitems by using Lineitem subsets
Hi, I want to omit calculate Lineitems by using Lineitem subset. I have these Lineitems. I have to calculate each(A,B,C…) error(= Forecast - Actual) . But in this table , I have to create at least 4Lineitems and input formulas. Category Lineitem Value Forecast A_forecast 100 B_forecast 10 C_forecast 200 ・・・ ALL_forecast…
Level 2 1.5.8.1 Create Saved View for DAT03 Module - summary method
I'm on Level 2 1.5.8.1 Create Saved View for DAT03 Module, and I have Monthly subtotals in my saved view and I can't see how to get rid of them. Other than that my saved view matches the requirement. Here is the requirement screen shot: And here is my screen shot: There is a hint in the activity about which summary method…
Enable Conditional Formatting using Booleans, Dates and Texts
Presently conditional formatting logic works only on number data type. If it is made to also work on other data types available such as Booleans, Dates, Texts (and lists may be) it would be very helpful and we won't have to work around the missing functionality.

Modeling

Discussion List