Modeling

Dynamic Cells Calculation (DCC)
This feature would allow to selectively switch between "Calculation" or "Manual Input" on a specific LineItem. Much like the DCA, the DCC would be based on a boolean. When True, the formula would apply but when False the user would be allowed to type data. This would allow to make Anaplan much more dynamic and greatly…
Multiple Summary Methods Per Line Item
Description of the enhancement required: Ability to use different summary methods by module dimension (list) An example of the enhancement: We can currently summarise differently the lists and the time dimension but it would be great to be able to choose a different summary method by list/dimension. For instance if a…
3.3.5.4 Update INV01 to Allow Override of Order Amount
Hi Everyone, Please advise If I am correct or not. I am having a little difficulty to understand what has been asked to created here. We now have two check boxes or Booleans "Submit purchase order Request?" and "override Suggested Order Amount?". My question is does only one box needs to be checked at one time or they both…
Calculate the difference between two dates (days/months)
Calculating the difference between two dates is a common requirement and one that you will likely need to do at some point. Below you will find the best practice for calculating the difference between two days, and the best practice for calculating the difference between two months. While there are multiple ways to get to…
Stop the mistake research processing
As a Model Builder, I would like to be able to stop the mistake research by using an action button. This processing can be very long when we are building an heavy model (5-10 minutes) and most of the time we already know where is the mistake (format, etc.). That's why we can save a lot of time if we could click to stop the…
Error when changing list dimension to subset
HI, I have a list as dimension in one of my modules, and I am trying to change that dimension to a subset of the same list. However, when I try to do that, I get the following error message; "To serve as an access driver, a Top Level Item must be present on any line item dimensions that don’t match those of the target…
Is it possible to check capacity for each Module?
So I want to change my module. But I want to know how much capacity before and after implement new changes. Current now I only knew that we only can see the capacity for a whole model. Please someone, could you tell me about this information? Thank you!! 😄 BR, Dian Suci
Line items
Hi Anaplan Team, Model builders could work more quickly and efficiently if we could display the list of filters and import actions. When we attempt to delete a line item, Anaplan shows the referenced line items, but it does not indicate which line items that specific line item is using in filters and import actions.
How to get data from current period -1 of current period
Hello, I need to get data from Aug 21 to Sept 21, but i dont want to use "Previous month", if not something like "current month -1", it´s possible? Thanks
Ability to select versions as a list formatted line item for use in lookup statements
Versions are useful as they allow switchover functionality enabling a user to both enter a forecast on a line and see actuals in the same line item. However, comparing versions to eachother (any version to any other version dynamically) requires a "Versions List" and logic to engage that list with the Version you want to…
NEW Community Q&A Challenge — join the discussion and collect a badge!
In the Anaplan Community, we believe that success stems from members connecting, sharing, and helping one another. As we witness members supporting each other daily in forum discussions, sharing ideas and best practices, and showcasing their expertise across various content, we are excited to introduce a new challenge that…
what is DataHub and Spoke Model?
Creating New Model with No Access to others by Default
When a new model is created why does Anaplan provide access to other users within that workspace by default. It would be great if this gets restricted to the user who creates the model and then users can be added incrementally.
Default number format for line item
As model builder I have to change format settings for each number-formatted line item individually when it's created. Would be nice if somewhere in the system I could setup default number format to be applied automatically when new line item is created. In example below you can see that once created a line item has the…
Change Model There Colour
It would be useful to be able to set Production Models header or background colour to something different to Test or other non-production Models. During development activities switching between models in different browser tabs and windows can lead to changing a formula in the wrong model. I've seen in other Finance Systems…
Dimensions that don't exist yet
I need to dimensionalize a report in Anaplan by Regions we currently don't use. They aren't in Anaplan at all. We have the accounts we need but the Regions in Anaplan are different that the Regions needed for this report. I know I can create the Regions but the only issue is that I do not have the data needed to input the…
Line Chart Showing Monthly Values for Fiscal Year Lines
I need to create a line chart showing the monthly values for each of several fiscal years as a line chart. The user wants to be able to see lines comparing each month in each fiscal year. For example, on the X-axis would be each month in the fiscal year, January to December, and on the Y-axis would be each fiscal year,…
How to pull the annual total from the month forecast module?
Much appreciate if someone can help with this one. Source module: monthly expense list: cost center & expense type Dimension: time (by month, with year total FY23); version (actual & forecast) Line item: expense Target module: Annual summary list: cost center & expense type Line item: expense, budget, variance, % NO TIME…
LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks
For Shipping Time weeks, below was the logic i applied and it went through, however the data i am getting is '0' 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] to further break down i searched for other modules for shipping method dimension but no…
HyperModel: five tips to improve your experience
Are you considering HyperModel for your ecosystem, or have you recently deployed it? Fantastic! We've compiled a shortlist of the top five tips to help make kicking off your HyperModel experience as smooth as possible. Check out these top five tips to improve your experience: 1. Recognize that the Hyperblock has not…
Having more than three dimensions in the pivoting of modules
Hello, Is there a way to have more than three dimensions as rows or columns when pivoting a module? Maybe it is easier with an example, I have to create a report that requires 3 categories on top of the line items, but I am only able to add 2 categories, because the pivoting cannot exceed three dimensions in rows and…
can we have a multi select filter as a page selector in Anaplan?
similar to what we have in excel filtering…can we use page selectors to select multiple boolean formatted line items. Snapshot attached
Ability to Comment Code
The ability to put comment blocks and indents within your formulas, so as to allow model builders to better document and format their code within the models for readability and understanding purposes. This will help align Anaplan's language back to the basic features all other development languages used in an enterprise…
The Key to Aligning Missions at Academic Medical Centers
Disjointed manual spreadsheets are common pain points expressed by our higher ed clients. You may be able to consolidate all academic departments using the same templates on separate tabs, but what if you have a completely separate operating unit with an entirely different model? Or perhaps you have a legacy system in…
3.3.5.5 Update Inventory Ordering to Allow Override of Shipping Method
Hi All, I need some help here regarding the Final Shipping Time in Weeks and Final Shipping Method Graphics attached. When I run this using the default position of Road and a 2 week delivery time it works fin, irrespective of the week I place the order. However, when I choose to Override Shipping Method, pick, say, Air…
Line Item Subset Filter not working in New UX?
Hi All: I am attempting to filter in the NewUX by way of a line item subset. Goal is to hide line items based upon the selection of the user. In the traditional UX I can apply the filter without issue. When I go to apply the filter to my grid in the worksheet (NewUX), it does not allow me to select the line item I wish to…
Planning Gross Margin % and other Ratio metrics at levels above the bottom level
Pretty much everyone would agree that Gross Margin % (GM%) is a REALLY important metric when planning your business. It’s a key performance indicator for healthy past performance, and a key driver for future investment decisions and performance management. Employees are frequently bonused on revenue and margin goals – so…
Community perspective: How to vary model inputs using optionality
Sandi Duffy is a Certified Master Anaplanner and Senior Finance Manager at Challenger Limited. With Anaplan, it is easy to run multiple scenarios within the same model by using optionality. A common use for this would be during the budget setting process. Say, for example, you have a budget model but would like to see what…
Filter not working in UX
I added a time filter for this module expecting the card to populate in the UX. I only want FY23 and 24 as options for selection. It works on the model builder side but the card keeps populating FY22 in the UX despite me saving the view.
Ability to Apply Filters before downloading Model History
Currently, If I want to check history to view some activity on a specific module or list, but I am not aware of the dates when that change took place, It takes forever for me to extract the history for downloading 'ALL' change history and locate that change. I face issues especially when the changes are too many and file…

Modeling

Discussion List