Modeling

How can I get PY Sales Revenue from Sales Revenue in a module without a time dimension?
I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for a particular territory? I tried the following and got errors: Sales_Revenue[lookup: territory_id, lookup: PY ar_date] Sales…
Modelling using users properties
As a model builder, i d like to be able to model aroynd users properties that are found in "users" panel in order to bring new functionalities to functional admin users, granting them in dedicated modules or actions within a model the following - ability to check users selective accesses rights (read / write permissions)…
Create DATA02 SKU Volumes module
Hi im unable to import the data from my supply chain model as I don't know which module to pull it from
Bulk Copy Action - Line Item Input
Great addition this past weekend with the Bulk Copy Action so that it can be tied to a process. As another enhancement to this feature - it would be great if the model builder can set line item values to drive the input - similar to the update current period action released prior.
Level 2 Model Building: Conclusion DATA02 SKU Volumes
Hey folks, I'm on Level 2 Model Building: Conclusion, and it says: "Import Final Demand Forecast into DAT02 Module In the Financial Planning & Analysis model: Import the Demand data into the DATA02 SKU Volumes module. * The results should have none ignored and 0 errors. Update Actions and Processes: * Rename the import:…
Bulk Copy Action
I am aware that I can add Bulk Copy as an action via Action in Model Settings Bar however to set this up I have to select the target and source version/list member. Is there any way to set this up so that I can select the target and/or source when the action is being run?
How to sync manual data to from one module to another
Hello All, I am trying to bring the data from an existing module A to another module B ( have created the same column in the module B with correct dimension), but I am seeing no data in that module Going forward i want this column to be up to date with the live data in Module A Is creating an action my only way? Approach…
UX User-Filter & Context Selector Issue
Hi, I have a user filter that was working correctly before (and still working in some old UX pages) but it seems that after the last Anaplan update a bug had happened and I am not able to apply the filter anymore. In my UX page shown below, the user-dimensioned selector (Blue box) filters the context on the page (green…
4.8.2 Activity: Import Data into E2 Employees# List
Hi Anaplan community, Had a bit of trouble importing employee details into the list. I followed all instructions given in the community regarding this and even tried deleting and importing the list multiple times but it still displays employee number instead of name. Hope someone can help. Thank you!
How to vary the calculation used for each version for a single line item?
I have a large model that is used to generate a business forecast. Each time we need to generate a new forecast or scenario, a new version is added so that the inputs can be changed and the outputs then compared to previous versions. However, sometimes the calculations themselves need to change to reflect our evolving…
Production Data - Top level Can be Changed?
I have a scenario as follows: I have a List named "Product L1" which has been marked as production data. While I understand that structural changes can still be made to a list that has been marked as production data, I have noticed that the top level, which cannot be changed if the list has been marked as production data,…
Rank Formula Work Around
Hi! I have a module dimensionalized by a list of unique identifiers that is the child of a Location list. I'm trying to rank survey dates (a date formatted line item) in descending order based off of how recent they are BUT there are multiple UID's with the same survey date. The problem is, with the "RANK" formula, the…
Hold and Release functionality
It would be great to have "Hold and Release" functionality extended to NUX as well. Break back seems to be working fine with NUX but sad to see missing hold and release functionality. Hope this feature will be added soon. Thanks, Sandeep
level 3 4.6.3 Data Hub Model: SYS14 module
In the Data Hub model, create a SYS14 Create Account>Product system module * Dimensions: Account Flat, Product Flat Add lines items and functionality: * Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13…
NUX, Subsets, and Context Filters
Hello! I've got another unusual NUX issue I need some help with. I've tried to include relevant snips below, but as always happy to answer any questions and provide more info as needed! It has not been an issue until now, so we suspect recent Anaplan updates are the cause but have no way to verify beyond it being a new…
Module not showing all list items
Hello, I have a 4 tiered list hierarchy. On the lowest level I have thousands of items that do not have a parent and need to be deleted. I would like to create an action to delete these list items and add the action to an existing process to maintain good model hygiene. My challenge is that any module where the list is…
3.3.12 Activity: Create Product Replenishment UX Page
Hello, I am stuck with 3.3.12 Activity: Create Product Replenishment UX Page. I have saved all required views and trying to create a board based on SYS00 and INV01 modules. When I link SYSS00, it shows data in not editble view. can you please advise why its so?
Handling Forecast Outliers
Greetings Anaplan Community, We are currently using the Anaplan statistical forecasting model for our demand planning, and a question has come up around how we can better handle outliers that can drastically skew our forecasts when there are periods of zero demand. We have a process for manually backfilling demand in these…
Sort Workspaces in Model>Model Import View
When setting up an import and selecting the "Connect to Anaplan Model" option, if you need to navigate to a different Workspace, you may be in for a bit of a maze. The workspaces are randomly sorted today, when nearly every other view (manage models from home page, new breadcrumb navigation in updated modeling experience)…
Model building checklist
Author: Nicole Johnson, Senior Anaplan Model Builder at Autodesk. I love a good checklist. Naturally, that passion comes through when I plan and build enhancements for an Anaplan model. I've created a model building checklist that I use to think through and document changes I need to make to a model, and I'm sharing my…
Issue while accessing 90 days free trial
I got the error while I was building a model. URL Path: * https://us1a.app.anaplan.com/a/modeling/customers/8a81b00e7122e5db01715001231c1f6c/workspaces/8a81b00e721f39240172397f56a47aed/models/A98B6141757B4170A4BD5B4CCB9E9ED8 * Client session id: Rzl22sFEp Please advise.
Lag Function without Time Demensions
Hi Anaplanners, I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principle is to add the queue from the previous segment and add to the current segment, however the model does not have any time…
January 2023 releases and February sneak peak
Hopefully you've all been able to get your head around the new Community platform. Hint: always go to product.anaplan.com for new platform related stuff! No doubt @Paul & @CatherineH will bring this up in March but there's been a tonne of new-ness released and we're only in February. For me shapes in Management Reporting…
When not to use Numbered Lists?
Given how flexible numbered lists are, is there a reason why I should not make all lists in a model 'numbered'?
Does reseting the index limit affects the list or list items in any way ?
I have came across a issue in which because of exceed in index limit the import is failing.So I looked into the Anapedia for this concern and got to know that I can reset the index of list if the following conditions are fulfilled :- If your list is empty and the Next item index is between 899,999,999 and 999,999,999, you…
Maximum Limit on Adding Hierarchy lists.
Hello, I need to understand what is the maximum limit on adding the hierarchies? I have tried adding upto 50 lists and the parent of List 50 was List 49. I am not sure if it has any limit or we can add without any limit. Can any one could help me?
Quarterly Account Sales Revenue Targets
Hello, I'm in the process of building the module for user story 1.11 and I am struggling to get the correct formula. I need to convert yearly data to quarterly data using the SYS99 Time Settings module (only line item dimension). My formula currently pulls the yearly total for each quarter which is incorrect. Any guidance…
Demystify non-linear optimization: Episode 1
Prologue The Anaplan community has been facing more and more interesting optimization problem statements every day while they solve complex business problems. Business challenges often involve finding optimal assignments such as sales reps to customers, demand to production capacity, or workers to shifts – all while…
Hide zero rows in Boards (modeler setting)
I want to be able to setup such a feature which will automatically hide zero lines from a Board if it is turned on. Problem: Filters set by model builders on modules are easily get cancelled if an end user pivots this modules. It may sometimes reveal the data you don't want them to see. My example is when I setup a filter…
Quarterly Account Sales Revenue Targets
Hi @JaredDolich @Misbah , How are you? I completed the User Story 1.11. But I have a question. When I select All Account, the % of Account Sales Target aggregate automatically. Any help would be appreciated. I am looking forward to hearing from you soon. Best regards. Wei

Modeling

Discussion List