-
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…
-
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…
-
OEG Best Practice: Performance issues with CUMULATE over lists
Problem statement When using CUMULATE over a list—this is when using the format CUMULATE (x, y, z)—the performance can be poor with anything that exceeds a few million cells. This is because the function is running on a single CPU thread, which differs from nearly all Anaplan functions. Anaplan gets its efficiency from…
-
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
-
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…
-
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…
-
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…
-
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…
-
How I Built It: YTD values using a fake calendar
Author: Jared Dolich is a Certified Master Anaplanner with 8 years architecting Anaplan models. Anaplan Champions! A colleague asked me recently how I might obtain a YTD value using a fake calendar. Yeah, I know — I should have asked why they couldn’t use the normal time hierarchy, but there are occasions where you are…
-
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…
-
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.
-
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…
-
Import error (parent item has a child item that is in a different list)
Hi all, I'm getting the following error in one of my import: Import into Hub_0_Product_Group Marketing L8 # list failed: Parent item has a child item that is in a different list: You can only add a child to a parent item, if any existing children of that parent item belong to the same list. Do you have any tip/advice 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!
-
Dynamic Cell Access by Role
I am looking for suggestions / alternative approaches for managing DCA by the user's assigned Role. Ideally, there would be an easy way to maintain this going forward. 1) I have heard a rumor that there is a trick wherein you somehow create a filtering module, then use the normal Roles>>Modules access assignments. Access…
-
Dynamic filter on a hierarchy
Hi, I built a dynamic filter on a dashboard so users can select multiple criteria. On the department filter, the end-user can only select the bottom level of the hierarchy and not a parent. This is because the filter is dimensioned by the lowest level of the department hierarchy. What's the solution to get around this…
-
Time text format?
Hello everyone, I hope you are all doing well. I am writing today to inquire about the best formula to transform text from the format DD/MM/YYYY to DDMMYYYY. For example: 02/04/2024 should be transformed to 02042024. Thank you!