-
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 )…
-
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…
-
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…
-
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!
-
Order list action not working.
For example, Module A has SKU list and line item POS which has certain data in it. Need to reorder the SKU list with respect to POS line item data in descending order (Highest to lowest). Used Order list action to sort the SKU list. The hierarchy of list goes by Organization > Model > SKU. Order list action. Module A…
-
Introducing Improved Anaplan DX: a browser extension for Anaplan Modelers
We at valantic are excited to share our latest development: Improved Anaplan DX, a browser extension designed to enhance your modeling experience and increase efficiency. Please see below for more details. The extension is now available in the Chrome Web Store (can be installed on Chrome and Edge): For any feedback,…
-
Data Loss with Inroducing Time Range
So in the current setup, a module is dimensioned by Model- calendar time dimension and the horzion is from 2021 to 2026, the granularity being weeks. This setup is used in prod since go live for 2 years now. We realised the span of time for data in that particular module can be reduced. Idea now is to introduce a time…
-
Recording now available! April 30 quarterly customer platform release event
If you missed our April 30 platform release event, the recording is now available! In this webinar, we highlight the most recent feature releases and how to take advantage of these in your environment. Our Operational Excellence Group (OEG) goes through a demonstration of the most recent platform features, provides a…
-
New UX Idea - Apply one more model source to all pages of the app at once
One of our model a dev and multiple prod models linked to a single dev via ALM. We have developed New UX App based on dev with a lot of pages in it. My aim now is to apply all prod models we have to this app, but the existing procedure is not effective for this idea. I want to have ability to add new source to the excising…
-
Allow the end-user to set their own language preference for a model within their settings.
Description of the enhancement required: Allow for Workspace Admins to configure the Platform in English but support alias tables that allow end-users to switch between different languages (i.e. English to French, etc.) An example of the enhancement: Allow the end-user to set their own language preference within their…
-
Is there any way to see if a line item subset has been used in a version formula?
We're looking to do some tidy ups in the line-item subsets and couldn't see a way of easily identifying if the LIS has been used in a version formula only. Nothing shows up in the "Referenced in Applies To" and "Referenced as Format" columns. Apart from going into each module and checking, is there any other place/method…
-
Level 3 - Ask the Stakeholders - Designating Sales Reps to Accounts Process Questions
Level 3 - Ask the Stakeholders Designating Sales Reps to Accounts Process Questions This forum is for asking the stakeholders of the Unicorn Candy Company questions about the Designating Sales Reps to Accounts Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please…
-
Planual Explained - Day 5
Rule "1.05-03": Article 1, Chapter 5, and Rule 3 – “Avoid using List Properties” List Properties are same as line items but have many limitations, so keep it simple and have one place for calculations i.e., Module line items. This goes against P and A of PLANS if you wish to create list properties. Here is how it was done…
-
Optimizer Problem: Line Production Allocation by Production Plan
Hi All , 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…
-
Generating the sequential number with formula
Hello everyone . I have a module with 2 dimensions and only one line item . I want to generate the sequential numbers with formula like the numbers shown in the picture. I would be glad if someone could help me with this. Thanks
-
Level 3 - Ask the Stakeholders - Establishing Sales Targets
Level 3 - Ask the Stakeholders Establishing Sales Targets Process Questions This forum is for asking the stakeholders of the Unicorn Candy Company questions about the Establishing Sales Targets Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please allow up to 3…
-
Tracking import date
Hello, I'm having a little difficulty with something in Anaplan. I want to set up a system (module) where every time the end user try to import a new file in a page, we can note down the date it happened. We have different files, and I'd like to keep track of the last date data was brought in for each file separately. i…
-
Configure Default Number format for an Anaplan Model
As a Model Builder, I would like to select a Number format for an entire model ("Global Default Number Format" ?). This could be very helpful for us to save time. This can work like the selection of the "Global Default Gride Style" in the Dashboard Settings.
-
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…
-
Model design process
Can anyone help in guiding me whether my order of front-to-back model design process? 1. Document the business process 2. Determine the modules needed in the model 3. Identify the dimensions needed for each module 4. Design the user experience 5. Map the user and data workflow
-
Conditional Formatting Help
Hi All, Checking the possibility of conditional formatting for FY 24 -GAP as shown below. I don't want the BP or Fcst to be formatted. 2. Is it possible to extend the Color formatting to only certain line items label (like net revenue, GM and GM %) needs color formatting 3. Is it possible to have spacing between Forecast…
-
Summary method for time
I have a reporting module that shows me gross and net revenue totals by month, with line items for each member of a hierarchy as well as the period. I can select each period to see each month's data, but I'm wondering if there's a summary method I would need to be able to see all of the months when I have the whole fiscal…
-
Level 3 TAR03 Country Account Calculation- is my Factor logic and values correct? Please help
I've been stuck on this part for some time now. I have followed the instructions carefully and when I calculate the Factor line item in TAR03 I am getting negative values. I did a SUM by Country on the Target line item in TAR03. Are these negative values correct or is something wrong in my TAR02 line items? I'm also not…
-
Data Display in a UX page
Hello everyone, I have a table displayed on a UX page (a worksheet) containing multiple line items in the columns and a list of months also as a column (where each month is a child of a quarter, which is a child of a year). I need to address two challenges: Filtering Data by Months or Quarters: I aim to enable users to…
-
Search Icon missing in the beta version of new module inventory
Hello Everyone, I see that in the beta version of new module inventory, there are two issues: 1) The Search icon is missing, which is there in the earlier version. 2) When we use the find option (Ctrl +F), it only searches the module names present in the current screen and not from the entire list of modules. Attached the…
-
Aggregation Functions Other Than SUM
There are several types of functions in Anaplan: aggregation, numeric, financial, time and date, logical, text, call center planning, and miscellaneous functions. As a model contributor, you are probably already aware of the SUM function in Anaplan, which is an aggregation function, but how many other aggregation functions…
-
Referenced by feature for DCA Driver Line items
When you choose a line item as read or write access driver, there's no way to know that the line item is actually being used besides knowing/searching for it as an active driver in line item information. Can we have a 'referenced by' feature for when a line item is an active driver?
-
Including Text within a Number Formatted Line Item?
Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0. However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item? Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA
-
Update Codes in a numbered list
Hi there, the model has been in use for a very long time. However, it is full of dummy codes instead of the correct ones. Certainly, there is a lot of data associated with these elements. So I can't export change, delete the old elements and import the new ones. Is it possible to mass update the codes in a numbered lists…
-
Usage of First Occurrence formula with conditionals
Hello, I'm using the ISFIRSTOCCURRENCE formula to assist in creating hierarchies so the processes don't return a bunch of errors when generating the hierarchy, but now I'm facing a little issue, I want the first occurrence formula to return true only if other columns match some condition, but I can't find the correct…