Modeling

FEATURE REQUEST: Universal List that can be used in all Models
Currently, the process to use same list across different models is a complicated process of importing lists from one model to another. If Anaplan really plans to be the a Connected Planning tool, they should have a feature of having a Universal List that can be used across all models without doing import. I am proposing…
SYS02 Region Details
I am stuck in 6.8.1 I can not see region details, my model is not same the screenshot, please guide. Thanks,
Bulk Copy for Production Lists
Need ability to be able to create a bulk copy action for the production lists.
Need help connecting text values between two modules
I have two modules with a common text formatted line item Employee ID. The modules are DATA03 and ADM07. In ADM07 there is a corresponding text line item called C4 Code. I want to bring the C4 Code value into DATA03 into the C4 Connect line item based on where the Employee ID line item matches between the two modules. What…
Bulk Copy On Items Within Modules and Bulk Copy Actions On Dashboards
Hi Anaplan, Currently the ability to 'Bulk Copy' of data only exists a list items data to be copied to another list item across the entire model. My idea is to have the ability to 'Bulk Copy' but only within a module from a list item to another list item within that model. Meaning that the data being copied only happens…
UX Page ability question
Hello, I am trying to figure out below two things for UX pages Is it possible to add status of a running import job on the page. I have user action button that starts a cloudworks integration job. Anyway to show status of the job like its running or is complete? Also I notice that once the import is finished, the data on…
NUX - Text Card - Use Hyperlink Line Items as Dynamic Text Values
We are trying to put together a landing page where the user can see basic information about the purpose of the tool + and can have supporting links. With the new edits to the text cards, it is really nice to put together such page. I was trying to use dynamic text value functionality to use the text-hyperlink formatted…
FINDITEM(Manipulation)
Hello All, I have a situation where I need to do a FINDITEM on a bit different situation. I have one list called Org with codes such as 1001_AX_501, 1002_BX_503, etc. Other list called CC with the same set of members, however, the codes are 1001, 1002. In order to map them, I need to do a FINDITEM with some twist so that…
NEW UX: Link to pages in other apps within the same workspace
In Classic Anaplan, we have one big model within a workspace. We're considering building it again in the new UX and expect to break the big model into more functional apps. The trouble is some of these apps are not entirely siloed, i.e. users will need to move between pages within multiple apps. It would be really helpful…
How to Make a Line Item Manual and Highlighted Yellow
Hello Anaplan Community! I have a question about adding new line items. When I add a new line item to a module in the backend of Anaplan, how do I know for sure the line item will be manual entry and shown highlighted yellow in the app page? For example, in the screenshot below I inserted the highlighted line item and as…
Add 'Does Not Contain' as condition when performing a filter on a text formatted line item
Many of our users would find it helpful if when filtering on text formatted line items, there was the option to use 'Does Not Contain'. There is a 'Contains' condition, which has proved helpful, however a 'Does Not Contain' would also provide a lot of value.
Five tips for a (mostly) painless model rollover
Author: Clarissa Hassfurder is a Certified Master Anaplanner and CEO at Double10 Consulting. As Anaplanners, we all hope that when a model is being build the Solution Architect and model builders think about and document all maintenance requirements for the admins. But this isn’t always the case, especially when many hands…
Retail: Markdown Planning
Summary As a buyer, you are responsible for managing your price reductions to a monthly markdown budget. But markdown management at your company is not that straightforward. You must also adhere to the company’s pricing policies when considering a new price for your items, including having to use price tiers, percentage…
New UX Idea - Dafault source model listed in more than one model used as a source for a page
This will be helpful to choose a default out of two or more sources used in a created page. Currently users see the first listed source when they open a page for the first time. And can be confused of the wrong data they see on the screen. The order in the settings of a page below does not affect on how the models will be…
RE Create Inventory Ordering Saved View and Export
Hi , Please guide me how to filter out parent in rows to make exactly same as export view. Thanks Abhishek
How to delete Anaplan Community Account
How can i delete my Anaplan Community account which i deleted by mistake.
Change Order and Style of Line Item Subsets
Hello, I am looking for some help. I have a module, call it "Module A", which feeds a Line Items Subset, call it "LIS A". I used the "LIS A" to populate an end state report, call it "Module B". How can I change the order and styles of the LIS A points in Module B? When i make the edits (reordering of lines or changing…
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)
Ability to Add Data Write Action to Existing Process
1. It would be really a game changer if we are able to add Data Write Actions to the existing processes, It would not only scale up the usage of the Data Write Action but also would save a lot of time and effort and would save us from creating multiple saved views and actions. 2. Currently, Data Write actions can only…
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…

Modeling

Discussion List