-
Straight Line Depreciation spread issue
Dear Model Builders, As per attached screenshot of my Straight Line Depreciation code, I am not able to get depreciation to calculate and spread for all subsequent months from Date in Use to Useful Life of the asset. All I am getting is a depreciation for a month of Date in Use but not for subsequent months. I have even…
-
Reducing calculation effort
Currently looking to make use of the feature where can now see the calculation effort entailed in certain line items and I've already been able to eliminate or refine a number of elements in various modules but just wanted to check in terms of best approach to take to this next one. I have included a copy of the formula…
-
Opening Capex Code not referencing Closing Capex correctly
Dear Model Builders, Please refer my attachd Opening Capex code which I believe not referring to the previous month's closing capex correctly. Appreciate your help on finding the cause of error and possible solutions. Thanks
-
Summary Calculation for Hidden amounts (DCA)
Anaplanners, I have got a question: I have a module with the following setup:Dimensions: Scenarios, Category, Time (Month)Line Items: Operational Metrics (e.g., Maintenance Costs, Revenue Earned, etc.) Another Module: Controls whether specific months (e.g., April, May) should be marked as "Inactive". When months are marked…
-
Data integration and scalability: A framework for model assessment and optimization
Author: Avnish Goel is a Certified Master Anaplanner and Founder at ScriptStory. Recently, I led a model assessment initiative to identify suboptimal design elements in the data architecture for a leading investment banking firm. The project involved analyzing source systems and Anaplan models, leveraging both Anaplan best…
-
Dependant dropdown in Polaris
Have you encountered the problem during building that the Dependent dropdown does not work in Polaris the way it does in Classis? I somehow see the Dependent dropdown Check greyed out for the lists I want it on. Am I missing anything here?
-
Flexible time options - for instance on weekly time horizons
Many countries' business planners think in calendar week numbers, and there are a few different week numbering systems used globally. Customers request that Anaplan enhance the platform's native Time options flexibility to add more possibilities: To define weekly time horizons start/ end, Naming the periods, Options on…
-
Renaming the line item - Best Practices
Hello all, I need to rename a line item in a large model, I am wondering what are the best practices to do this? What should I consider before renaming to avoid destroying the model? Thank you in advance for your help!
-
Renaming a Line Item: Don't Break Import Actions
When a solution uses a line item as a source within an import action, whether model-to-model or external source-to-model, the renaming the line item will break the action. This issue impacts the model builders who need to do a rebuild of the action every time they make a change (if the model builder forgets to rebuild the…
-
Multi-layer sort
Would be very useful to have a multi-layer sort (not filter) like in Excel i.e. Sort by column A alphabetically, then by column B, then by C. Acknowledging the workaround to concatenate the desired fields into a text line item and sort by that, but to me a publicised workaround is always a pointer to a needed/desired…
-
How to get value from time dimensioned module to non-time?
Hello, I have a module DEM03.1 Mapping (CV&ADI) with Time dimension and LIST03 SKU with the same List but without time. I'd like to get first non blank value from Date of introduction Line Item in DEM03.1 (1 pic) to Date of Introducton in LIST03 SKU (Pic 2). How can I do it?
-
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…
-
Question about Boolean line items
Scenario My rows include 3 items - REC1, REC2, and REC3 my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25 Line item - 'Select' which is formatted as Boolean. Desired Output - If I check any one Boolean among REC1, REC2 and REC3 for a particular quarter, the remaining two rows should automatically be disabled.…
-
Dynamic Average Calculation
I want to create a functionality where the end user will select a start and end month from a pick list and based upon the difference in months Anaplan will calculate the average revenue. Revenue data is already available in the module in one of the line item. Can this be achieved through MOVINGSUM() ? If yes, how do it…
-
NUX - Add several entries at one time in a module dimensioned on a list
Hi in the classic interface, when a module is dimensioned on a list, it's easy to add several entries at the same time with the action of creating items as showed below (which eases also the fact to copy-paste information which can be the same on several lines created): In the NUX, it seems that the only way is to create a…
-
Variance reporting - not using native versions
Just to give context we do not use the native versions in Anaplan, rather we use a list name forecast versions and then have a subset of these that we have of these that are marked as those we wish to do variances on, which seems to work well. We predominantly look at variances at a certain level in our cost centre…
-
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…
-
Ability for Non-WSA users to update Switchovers and do Copyovers
Hello, I'm looking at giving certain users access to update switchover for Native versions, and copy over activities, reducing reliance on the Tech team. It looks like it's these types of actions are only accessible to WSA users. Is there another way around this? I initially thought that these can only be accessed by a…
-
Balanced vs. unbalanced hierarchies
One of the foundational elements of any Anaplan model is hierarchical lists. When creating hierarchies there are two basic choices: balanced or unbalanced. In this article, we'll look at the differences between balanced and unbalanced hierarchies, areas where they behave differently in Anaplan, and some questions to…
-
filter time periods in list drop down
I'm attempting to show the 'remaining' months eg everything after the current period in the time settings - is this possible ? or would I need to create a fake period list?
-
[UPDATED] Summary Calculations with the User List
Author: Rob Marshall, Director of Architecture and Performance at Anaplan, Operational Excellence Group (OEG). Prior to the February 2024, users were not allowed to use aggregation functions (SUM, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK) when having the Users list in a module because the system could…
-
How to reference a Time Period in an IF statement please?
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until…
-
How to Aggregate Monthly Data to Yearly When Time Summary is Set to None
Hello Anaplanners. I have a module dimensioned by Month, but the Time Summary for my key line item is set to None to optimize space. However, I need to bring this data into another module that is dimensioned by Year. Since the time summary is disabled, the values don't automatically roll up to the yearly level. Would…
-
Model Integration details
Hi Anaplanners, I would like to know what are the different ways to fetch information about the integrations (versions, type of integration etc) that are present in my model? Are there any direct API calls using postman or I can find this information somewhere in the model itself? Regards
-
Unexpected Model Size Increase After Updating Custom Time Range
Hi Anaplan Community, I recently updated a custom time range in my model and noticed an unexpected increase in model size. Previously, my custom time range started in FY22 with 4 periods, and the total model size was 78 GB. After updating the start period to FY23 (keeping the number of periods at 4), the model size…
-
Conditional Formatting for User-Based Search Functionality
Hello Anaplanners, I have created a search functionality in Anaplan that allows users to search for specific text within the project descriptions, Project one liner, Project StoryBoard line items within a module where Projects are a dimension. The search functionality is user-based, meaning each user can input their search…
-
Axis for Charts
Hello all, Does the auto-axis functionality not work for waterfall when you have negative numbers? Case 1 - Positive numbers Case 2 - Negative Numbers The numbers are exactly the same & its the same chart with the auto axis turned on. In case of positive, the variances can be observed very well with visible bars for the…
-
Most efficient way to apply bandings to employee list
Looking to apply the bandings below to employee list depending on what salary is and whilst I know could do this by using combination of IF and AND statements I'm thinking there must be a more efficient way to do this calculation wise - any tips or suggestions would be much appreciated.
-
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…
-
Many to Many Sum in a single step?
I am in the middle of a model build and am running into a situation where I feel like there should be an efficient option to do a calculation, but I can't figure out a way to do it without a 'staging' line item that bloats the model. As the title says, I have a 'Many to Many' relationship - a single Deal can be tagged to…