-
Custom waterfall methodology
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose: There is more than one way to tackle the waterfall calculations. I’d like to share one custom variety that proved to be especially handy for use cases of new asset depreciation and revenue recognition. Customers seems to like the…
-
Set up custom time scale
Hi My current model is using a fiscal calendar e.g. FY23: 1 Jul 2022 – 30 Jun 2023. However, I have a specific use case, where I need to build a module that uses a calendar year e.g. FY23: 1 Jan 2022 – 31 Dec 2022. Is there a way to resolve this use case? Based on current research, I would need to create a fake time…
-
Level 3 Commission Forecast
I'm currently struggling with the calculation of the monthly commissions FC. Issue: Quarterly commission Forecast: Unable to get quarter values by sales rep. How to bring down Annual sales target into Quarterly? Kindly help me on this.
-
Set one column of source data as "Not Applicable" for this import
Dear Anaplan Community I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module. Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type…
-
NEW UX: Insights and Quick Links on Board Views
After sitting with @monica_girel and fully realizing how powerful / useful "Insights" and "Quick Links" panels can be in the Worksheet pages, it fully baffles me why this isn't part of Board views. Adding these to board views makes for a serious improvement in user navigation / experience by de-cluttering the main screen…
-
Dynamic List
I have two list: Target Center and Table Type: When a user selects target center I would like only the centers that are in the table type that is selected. For example if table type "FTE" is selected then Target Center list should be only "Board of Directors, Office of the President, and Legal" and if table type "SqFt" is…
-
From Native Versions to Fake Version List?
Hi All, As it is not possible to SUM down native versions is there a simple mechanism to take data out of versions and restate it within a fake version list? I know this is achievable via a series of nested IF THEN ELSE queries but this approach is not sustainable as it needs to be updated every time a new native version…
-
Consolidating recursive modules
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Employee ssL3Employee Employee 1 Y Employee 2 Y Employee 3 Y Employee 4 Y Employee 5 Y Employee 6 Y Employee 7 Y Employee 8 Y…
-
Line Priority Allocation
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority. If the production priority for a SKU is 1…
-
Level 2 Sprint 2 2.4.8 Activity: Create Detailed Demand Review UX Page
I understand that little instructions in the said section is intentional, but I am hoping someone help me out break it to me, maybe rephrase to include a little more detailed, if possible. Thank you,
-
Show "Used in Page" reference in Modules Settings
As a model builder, it would be extremely helpful to have a "Used in Page" reference in the Module Settings to show where a module is used in a page, similar to the Used in Dashboard feature. This would allow for much more efficient auditing and help tremendously with model cleanup. This is especially important since we an…
-
Level 2 Sprint 3 Exam
I have tried to take this exam. There are two formula questions where I provide answers that work based on the information provided. However, the system will not accept these formulas as valid answers. (Questions 3 and 9) How do I either have these formulas accepted as value or understand why they are rejected.
-
Apply DCA by User Group/Role
The ability to have user specific DCA is great as it allows fine grain control of line items/modules without add dimensions to them, but... As we are dealing with large models with increasing number of users the DCA modules themselves can become very large thousands of users by thousands of CC plus maybe a few other…
-
How can I make a YTD average?
Hello, I am looking to get a YTD calc but I cannot use the YEARTODATE function because I need an average, not a SUM. And previous years should calculate according to their months (i.e. I would see a full 12 month avg for 2023, 5 month average for 2024). My initial thought is to use TIMESUM but am having trouble setting it…
-
Alias Names for Time, Versions, Modules, Line Items and Dashboards
Hi Anaplan, It would be great for Anaplan to allow users to create alias names for: time, versions, modules, dashboard, list and lineitems. Thanks, Usman
-
Experimenting with automated documenting
Author: Taichi Amaya, Certified Master Anaplanner, and Financial Planning and Analysis Specialist at Pasona Group, Inc. When I first started model building, I looked at the model map and was impressed by how easy it was to understand the logic of the model. Even now that we are dealing with larger models, we can look at…
-
Did you know? Line item references across dimensions
Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Hello Anaplan Community! I'm excited to bring you the first video in Community's 'Did You Know?' series! This new series will dive into aspects of Anaplan that are often misunderstood or users have requested more…
-
Alternate Solution for RANKCUMULATE Function
Hi All, I have a solution using the Rankcumulate function but I want so avoid using it due to the performance issues. So I would like to know if there can be an alternante solution using other function Logic : First I'm ranking the Sales data Weighted distribution is calculated for ex: 95/3220 = 3% Cumulate distribution is…
-
Need Set Global Default Format Grid function in New UX
My users want to make it possible to set Format Grid - Small for all grids in the New UX. This function exists in Classic UX to set all dashboards to Striped, Ruled, etc. We would like to have this opportunity to set all grids of one App in New UX to one style, e.g. Small which will improve screen space utilization.
-
Running Actions in a Loop (Conditionally)
I have a use case to simplify let take an example. Assume we have product that can be bundled. Product A is single SKU. Product B is bundle of Product A plus some extra cost (eg packing cost). Product C is bundle of Product B plus some extra cost. User has option to either modify the price of Product A or Modify the extra…
-
How to pull together values from multiple modules
Looking to pull together values from multiple modules, which have started, as shown in the right hand screenshot. The difficulty I have is trying to pull the values across from a module such as INP08, shown on left hand side of screenshot below. Ideally I want to be able to pick up individual lines from this module into…
-
Control while syncing changes using ALM
At this moment, we (model builders) cannot control what changes should be synced with models in deployed mode. This is quite a challenge & honestly a concern especially when multiple model builders are working on a model and want to sync changes with testing models and poses sometimes a risk of unauthorised data exposures…
-
Anaplan Data - Real Time Access
Hi All, We are trying to access Anaplan Module level data using Python. I just wanted to access Anaplan data (Module Level Data) in real time by using Python or Java without getting data from Anaplan with flat file. Also wanted to establish Connectivity between python & Anaplan in the real time. So we can get updated data…
-
Formula Question
Hi, I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you need more information on the topic please let me know. 'D01 Funding Ratios'.Average of Fund * '01S03 Weekday count by…
-
Can a List be Copied similar like Modules?
Dear Community, I have a basic question, many will feel it might be silly but still need to ask whether we can create a copy of the lists available in the General list sections like modules? If NO then why & if YES then how can we do it? Hoping to get answered by anyone of you soon!!! Regards,
-
Cell history not being captured correctly
Hi All, I have come across a weird scenario where cell history of a Boolean formatted line item is not getting captured properly. For e.g. : In the attached snippet of a cell history of a module below are updates 1 - Data got updated after a bulk import to TRUE (History ID - 3994882) 2 - In the next update (ID -3996409 )…
-
Automatically Sort List Dimensions in "Applies To"
The Planual 2.01-11 states that dimension order should remain consistent among modules to ensure faster calculations so that common dimensions are in the same order as the applies to. I know I am able to click into the Applies To section for a module or line item and then click "OK", and that this will re-sort the list…
-
Summing a percentage of a list amount from one module to another
Here is my situation: I have a module that contains a $ amount for a list of accounts , I am then mapping those $ amounts to another module that contains line items that I have in a List. In my screenshot you can see in Line item Mapto contains values of the list as well as Line Item Mapto2 contains values of the same…
-
Better solution for a nested IF... but I can't think of one
I am working through many many modules and removing 'bad' data or process and have come across a nested If formula, and cannot think of a better way to replace it. Have a module with 2 sources MATERIAL and LABEL TYPE. Within the material list we have several labels (FRONT, REAR, DECAL + 6 others) In the module i need to…
-
Avoid the roll back every time the formula is wrong
Every time we create a wrong formula the system runs a roll back that takes about 8 minutes!! We would like to avoid this roll back... it takes so much time during the development phase! They could just send a warning message!