-
Retrieving Anaplan’s Optimizer logs step-by-step
Getting Optimier logs helps to understand how to tweak the model to speed up the solving time. Workspace administrators can download the Anaplan Optimizer log via an API. Links: - Optimizer logs for debugging - https://anaplan.docs.apiary.io/#/reference/logging Users can use Postman or perform this action directly in the…
-
LOOKUP and FIRSTNONBLANK used in the same formula
I have two modules in Anaplan: Module 1: Name: dat_Fund Composite Dimension (List): ad_Fund Composite ID Module 2: Name: dat_Segment Dimension (List): ad_Segment ID There is no direct relationship or mapping between the two list dimensions. I'm trying to understand how the following formula works: Line Item: L0 Segment ID…
-
Unlock Your Next Level Model Building Potential with Improved Anaplan DX
Hi Anaplan Community! I’m excited to present you Improved Anaplan DX by valantic, a Chrome extension, that also works seamlessly on Edge. This tool is designed to make your Anaplan model building experience smoother, more efficient and supercharge your productivity. Download the Improved Anaplan DX today to bring your…
-
Managing Anaplan maintenance windows: A comprehensive guide for enterprise planning teams
Author: James Cannon is a Certified Master Anaplaner, Solution Architect, and Senior Manager at Ernst & Young. In any enterprise Anaplan implementation, regular maintenance windows are essential for model stability, performance optimization, and ongoing business value. However, without proper structure, communication, and…
-
Introducing New Resources for Anaplan Polaris: Benchmarking Performance
I'm very excited to share two new comprehensive technical resources that showcase the exceptional performance capabilities of Anaplan’s Polaris calculation engine. These documents provide detailed benchmarks and real-world performance metrics that demonstrate how Polaris delivers the scale, speed, and interactivity…
-
What's the impact of using SA for a child list for getting filtered list items in dropdown?
I have a 3-level hierarchy, where the parent top 2 parent list is selective access enabled. I want the bottom-most list to also have filtered dropdown based on its parent's selective accesses. One way I was able to do it is by enabling selective access for the child list and enable Selective Access Boolean in the Line-Item…
-
How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
-
Process Run time Duration has Doubled - Trying to Identify the root cause
Our company recently underwent a merger and we took over a company, this means our model now has become bigger overall - New SKUs, New Customers , new Production lines etc. The size of the model: before go-live with merged entity: ~50GB After go-live with merged entity: 79 GB Agree and understand that the model size…
-
Melhores Práticas para Configurações de Tempo em Modelos Anaplan de Grande Escala
As configurações de tempo no Anaplan vão muito além de uma etapa inicial de configuração, elas representam uma das principais dimensões em um modelo padrão. Com exceção dos modelos do tipo Data Hub, a maioria dos módulos utiliza a dimensão de tempo, e qualquer alteração nas configurações de tempo impacta diretamente o…
-
Modeling Performance
Hi Team, I would like to get the next year summary value into previous year’s month. If we need current year summary, then we can use YEARVALUE function to achieve but we need to bring data from next year so we can use either LOOKUP or TIMESUM . I would like to know which function is effective between LOOKUP and TIMESUM.
-
Line Item Sums per applied dimension
It would save a lot of space if you could specify the sum option in the Line Item based on the applied dimensions. Especially on hierarchical dimensions this would have effect. Sometimes a sum is only needed for one of three dimensions. This would safe space consumption a lot. This feature could added in the sum options:
-
Order in SUM agregation parameters for performance
Hi hive mind, I have a tricky question. Here we go : I have a target module with 3 custom dimension (A,B,C) + Time (Month) I have a source transaction module containing line Items with A, B, C list formarted and a date column and an amount column In my Target Module, I need to agregate the Source amount with A,B,C and…
-
Dynamic Subtotalling for List item subset based on user selection - Module Size Optimization
Hello, Apologies for the long post, I tried to be descriptive enough! I've a module in production which has close to ~3 billion cells, (this module alone occupies 25GB of space). I'm trying to optimise this module for space and make it scalable. The reason for the size **** up is multidimensionality and extreme sparsity of…
-
Are all models slow to open in the morning?
Our model takes about 10 minutes to open every morning. Our implementation partner told us that is not uncommon for the first person to open it in the morning. Is this something other users have experienced or is it a performance issue?
-
How does the Model Open Analysis Report change without any changes to model?
We've come into performance issues on our model and requested a Model Open Analysis (MOA) report from Anaplan support. This was very helpful in identifying modules and, in particular, line items that were using up a lot of processing power. The metric they used was Total Calculation Time, measured in milliseconds. After we…
-
Faster method for SUM from multiple sources
Hi Everyone, Can anyone confirm which of the below is faster? Final Line Item = Module A. Line Item A [SUM: A, SUM: B, SUM:C] + Module B. Line Item B [SUM: A, SUM: B, SUM:C ] Line Item 1 = Module A. Line Item A [SUM: A, SUM: B, SUM:C] , Line Item 2 = Module B. Line Item B [SUM: A, SUM: B, SUM:C ] , Final Line Item = Line…
-
Anaplan Add-In Grids Upgrade
Being able to pivot/filter the add in grid without references to that grid getting removed. When I create a retrieve using the add-in and link to another excel tab (formatted for distributions to our leaders) and then alter a dimension using the pivot/filter function it will remove the references on the summary page. In…
-
Does having multiple models in a single workspace (standard or hypermodel) affects performance?
Hi All, I have a query where currently we have 3 models in 3 different workspaces(standard). In all the 3 models we have intergrations running at different times(5-6 times a day for each model) to update Actuals/Forecast from other sources. We are looking into getting a hypermodel workspace for future enhancements &…
-
Need help with better approach
Hi, I am facing issue with the below senario. If someone can help me out with what is the best possible approach I have hierarchy with lists from L1 to L6 levels and a flat list D with list items from D1 to D5 Current setup: There are several hundreds of modules with combination of flat list D with one of the hierarchy…
-
Average Duration for process to be run or Line items to reflect the changes
Hello Community members. Hope you are doing all well. Currently I am optimizing a model for a client that was having troubles with the duration of processes being run or the duration which it takes for line item to reflect manual change by users in a line item . Model has been optimized now. I know that for sure different…
-
Anaplan add list API timeout.
Currently we are running an integration which we are inserting values into list through Mulesoft. However sporadically through out the day, we would get time out errors inserting into Anaplan. If we are inserting batches of 500+ records from the API, Anaplan endpoint seems to either timeout or extremely slow. This has been…
-
How to stop calculation for a line item based on time selection
I have a module set up with weeks as the time dimension and covers a two-year timeframe. However, calculations are only needed for the user-selected quarter. To optimize performance, I'm looking for ways to avoid processing the entire two years. Currently, I'm using an If-Else statement, but I doubt it makes a significant…
-
Sum on dynamic filter selections
Looking for a way to sum off a data module based on dynamic user selections. My dashboard has a filter(dimensioned by user). Users select any combination of these dimensions(except amount and account). Sometimes fields are blank so a simple SUM wouldn't work. Ultimately the summation would live in a P&L statement so also…
-
Performance tuning in Anaplan’s Optimizer
Author: Mike Henderson is a Principal Solution Architect at Anaplan. A question recently came up from a customer regarding Anaplan Optimizer, and I thought it would be useful to share the answer with the broader Community. For background, Optimizer uses linear programming to quickly solve complex problems involving…
-
"Applies to order" in formulae
Does the order that we list LOOKUP: \ SUM: arguments also need to be consistent with the "applies to" ordering? Logically it would as I believe the reason behind this is to do with how Indexes are built in the background but am uncertain and would love confirmation.
-
Formula Break-Down Without Space Penalty
Currently, to adhere to best practices it is beneficial to break out parts of a complex calculation into separate line items for logic traceability and audit-ability. However, in many models we're constrained by space and can effectively reduce space (especially in large multi-dimensioned modules) by combining logic in…
-
No of sums in a single line item
Hi, Need to know that how many number of sums we can use in a single line item so that its performance will also won't downgraded. Thanks, Vicky
-
Repeated 'Illegal Argument' ERROR when pushing data through to a DataHub
I've been having an issue pushing large quantities of transactional data from an externally uploaded .csv file into a data module within a DataHub model. The .csv file is generated directly from an internal operational data store that queries data by client. I can populate its referential list with no issues which is the…
-
what would be the formula for referring Previous year value in current year ?
For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I achieve that?
-
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…