-
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…
-
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,…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Tell us what your teammates need from your dashboards
As an Anaplan user tasked with helping your teams better understand their data through your Anaplan UX dashboards, we want to hear more about what your end users tell you. What kinds of visualizations are they are asking you for, what do they struggle with in accessing and understanding your data, and how you resolve those…
-
2.4.7.1 conditional formatting add new rule option is not avaliable
Hello Can i know why I cant able to apply conditional formatting? why there is no new rule icon available when i select conditional formatting icon ? I have selected even a line item row or column and selected conditional formarting icon but still i there is no New rule option avaliable
-
Mission NOT impossible: Org hierarchy redesign for production deployed models
Author: Tiffany Rice, Certified Master Anaplanner and Tech Lead at Prudential. In a dynamic and ever changing business environment, it is inevitable that business requirements for forecasting and planning shift over time. Particularly in times of economic volatility we see companies leaning into transformation projects to…
-
Chart Data Labels - Show only one, and make font bigger
Hello - Is there a way to show only one of the data labels in a combo chart in the New UX? a lot of data labels are overlapping each other and it looks like a mess. I tried manually updating the scale, but then the scale doesn't look right when I make different selections. Being able to only have one data label would be…
-
Custom Date Format while exporting
Anaplanners Currently I have a grid at a day wise granularity. While exporting the grid the day is shown as follows: 1) As row header [here time is pivoted at a rows] - format comes as '1-Apr-2024' 2) When i bring it as a line item [with formula- ITEM(Time)] format comes as '4/1/2024' I would like to get a custom format of…
-
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…
-
Allow User to Enter Comments at Parent Level?
We have a text-formatted line-item where we want users to enter comments at both the child and parent levels. The current solution works fine for the bottom level, but Anaplan won't allow comments at the parent level (Marketing - Corporate Memberships). Is there a simple fix to this issue?
-
Charts & Graphs - The ability to set axis/axes as a Log Scale/Logarithmic Scale
There is currently limited functionality in terms of setting axes formats in Anaplan. As part of increased functionality, it would be great to be able to set an axis as a log scale as in the example attached.
-
Rolling Forecast Chart
Hello, Is there a way I can create a line chart that connects the Actual data and the Forecast? Attached is the screenshot from Excel that I plan to create in Anaplan. Thanks, Tom
-
NMX - Open App in new window
As a model builder and UX designer I would like to be able to open an App directly from the pages section of the NMX When I want to create new pages or review their order it is useful to review the current app(s) before proceeding. If a link to the relevant app for each page could be added to the NMX pages section this…