Modeling

Designing models that scale
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. One of the aspects which determine whether a model will meet the need of the business is how well it can scale. Whether the constraint is balancing numerous concurrent users, or having dimensions with high indices, or both and…
Dependent Dropdown Issue
Hi, I have built a dependent dropdown but its not functioning properly. I have a hierarchy which follows the certain order: Entity>Segment>Product Below is my segment hierarchy Below are my line items which are list formatted When I am selecting the top level of Entity, my segment dropdown is showing entity list and on…
how to pull values from one module to another module with no common dimension?
I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
The ability to add a dynamic sub total to a grid
I would like the ability to add a dynamic subtotal to a grid, so when rows are filtered out the total is updated on the fly
Sync on Selection - Multiple dimension Cell based
I understand how synchronization on selecting a list on grid works, I am trying to see if I can make it work on multiple dimension. eg, if I have a grid with list on my row as well as column. Is it possible to select a intersection cell and be able to synchronize select both list? Any tricks for that.
Model Sparsity - Combination of Dimensions
I have a question about reducing sparsity in a model by using numbered lists to combine a series of dimensions. I am using ledger data that has information by supplier and by department over time. If I create a module that is dimensioned by these I end up with a huge amount of sparsity as most suppliers are just used by 1…
Create Demand Export Module and Create a Saved View - DEM04
Let me know, if it is right! Is the time scale right?
Please change the layout of blueprint view!
The New UX is great and has drastically improved the end-user experience however, the model builder experience has really lagged behind. Anaplan models should be as easy to build as they are to use. There are some really easy wins to be had that will drastically improve the experience for model builders, in this…
Modelling Ideas
Hi All, Is it possible it have a view like this in Anaplan? (Q1-Q4- Time range - how to fit in GAP in the same row). Revenue, GM, OPEX, EBIT will be line items and ASI,PMO,PPT will be list. Please give suggestions on how this can be implemented. Thanks in Advance.
Export Action
Hi Members, Can someone please guide me, how can I create an export action? As Export Action is not displaying.
2.3.10 Activity: Create Demand Forecast
Can anyone help what's wrong here? Not getting the required values.
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest valued cell in a given line item?
Anaplan error: Line item not recognized
Dear Community, I encountered an issue during the build of some of our projects and would appreciate further clarification if possible. Brief description of the case: I have two modules, A and B, that contain the same line item names "Adjustment" (module1.Adjustment, module2.Adjustment). When I tried using the same formula…
Dynamic Aliases for Line Items (and other objects)
We are currently experiencing considerable product complaints from key stakeholders and project owners that need dynamic aliases, and for them to be dynamic (formula driven). The closest Idea exchange in the community can be found here. Competitor tools like IBM and Oracle, have this capability. An example of a specific…
how can we decide the order of data while displaying them in grid in a reporting slide
so if I want to compare line item values for A,B,C,D,E but i select them in order of BCDAE for displaying in grid in the management reporting slide feature of Anaplan. How can that be worked out?
Creating QUARTILE function within Anaplan
This is a method of building the Excel “Quartile” function within Anaplan – it requires 11 Line items, requires that the Data dimension has a ‘top level’ value, and uses the RANK function which has an upper limit of 50 million cells. To start, create a module (or use an existing calc module) dimensioned by your base data…
How to re-distribute or retain a value that is linked with a product, even product is deleted?
Hi there, I've situation where the Customer wants to keep the Overhead Values associated with a product, even though the product is being deleted from the hierarchy. I think of it as a manual entry for the value to be retained to that it can be re-distributed among the rest of the products or add to the total in the end. I…
Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Hello everyone, I get an error when I try to add this formula to the Beginning Inventory Line Item. I'm not sure why I get the error. Can someone help me out with this? FORMULA: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning…
Pivoting with more than 3 rows
Description of the enhancement required: Need to be able to pivot more than 3 rows How would it help their business process: Reporting many cases of views needed with multiple dimensions with more than 3 lists in rows. Most recent case 1) A module with many dimensions 2) Need to be imported to a flat list 3) Filtering…
Model Builder Level 1
Hi, I am new to Anaplan and have just started the Level 1 Model Builder course. I am in the Activity 7.2.3 section and have been stuck for a few hours now. Need some help to find out what I am doing incorrectly. I have attached a few screenshots Appreciate help from the community. Thanks Jacob
Using List Properties
Hi All, Why is it best practice to avoid using list properties? As a central location to hold all the data relevant to that list that does not require the user to update it seems like a perfect option. I am referring to properties such as all items of the hierarchy and permanent mappings that will never change. My question…
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
Replenishment modeling with circular reference
Dear Anaplan Community, I am facing a circular reference issue modeling replenishment calculation. For this specific client, their trigger condition to place an order is to evaluate below condition: If I do not place an order today, will my projected end on hand (EOH) on this Item's ETA date fall below this item's safety…
Use fake week to replace default week calendar
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Some businesses run their planning or operations by weeks. However, setting the Anaplan model default Calendar Type to Week format can be inconvenient. For example, converting dates to monthly format can sometimes be…
Level 2, Sprint 1, 1.7.3.1 Import into P3 SKU list
Hi all, I'm trying to import data into the list P3 SKU, and faced some problem. Please attached the screenshots of the step-by-step of what i did and the problem. Kindly need help to resolve this issue. Thank you so much!
Summary Method for Lookup function
Hi, What is the best workaround when using the Lookup Function and you need a Formula Summary Method? Currently, Anaplan does not allow this and for some cases, especially using % accounts, it is best to use the Formula aggregation in order to get the right math at top level hierarchies and Time Summaries (i.e, All…
Formula Summary for reporting
Have to run a variance reporting for 3 Line items. In the source, the line items have dimensions and Time(Quarter). The variance Reporting module is run by the same dimensions, the source line items act as a dimension(by line-item subset) and looksup the Year selection by the user. The challenge is that one line item has…
I NEED HELP ASAP
Hello, I need your help please!! I wanna import this file CSV in a list on Anaplan without edit the file. should i import the file in a module and create a code for each line then import the view in the list ? and how to do it ? thank you RGDS
L2 INV03 Distribution Summary - Stock Exceptions
I wanted to get some help with my formula for the Stock Exceptions line item. Previously my formula for this line item was: INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product] This worked, but was giving me large stock exceptions and was unsure if it was correct or not because the…
Prior Year YTD total option for Time Ranges
Hi, We have a large reporting requirement for reporting versus prior year for reporting month and Year to date. The month is easily achievable but if we want to create views that compare Prior year to date versus current year to date its a lot more fiddly. Alot of our monthly reporting is done through the Excel Add in and…

Modeling

Discussion List