-
Adjusting Statistical Forecasts: Utilizing different Methods for varying time horizons
Hello Anaplan Community, currently we have a very simple statistical forecast tool in Anaplan. We can select between 15 forecast methods for a forecast category. We generate the statistical forecast using a single method for the next 5 years. We aim to introduce a logic that enables selecting two distinct forecasting…
-
Model Building
Hello, I have one requirement where line items should be filtered based on the Year(FY24, FY25) Dimension. For eg: there are 12 line items, which contains both text and number formats. If User selects FY 24, The first 6 line items should be shown in the page and if user selects FY25, last 6 line items should be shown . Any…
-
Multiple Selection like Excel Pivot
I want publish this below list on ux pages and give end user option to select multiple item from list like we have option in Excel Pivot table. Is this function available in Anaplan or can anyone suggest me alternative function can be used. There are multiple line item in the list. The final goal is to sum the number from…
-
Filtered Picklist / Dependent Dropdown using values
Hi all Is it possible to set up a dependent dropdown based on a value? The scenario is that we have a list of orders with an order quantity, with a line item for the user to select the destination. However, we have a capacity constraint in the destinations, so we want the line item to only display the destinations with the…
-
Dynamic Line Item Label
One recent scenario was where the Line Item Labels are shown as CY, CY-1,CY-2,CY-3 and users wants this name to be dynamic like 2024,2023,2022,2021, I want this label to change in all modules each year as the current period changes. There were many occasions where there were requirements to change Line Item Label, which…
-
Summary values according to two list/line items
I have a module "details" dimensioned by a list 'orders' which is a hierarchal list . Structure of module looks like this :- one of the line items is 'Amount' and one is 'Plant location' in another module "Summary" i want to summarize the figures of this module according to plant, this module is also dimensioned by same…
-
Use Custom Fixed position pattern for 13 periods of 4 weeks
On loading data into a module, the Time dimension Custom patterns are based around a true calendar month, 1-12. There isn't a custom mapping pattern for periods which where the system time is set to 13 periods of 4 weeks. For instance, using custom YYYY_MM or YYYY?MM for the below data, would allow to load the data…
-
Models - Blank Screen
Hi Folks, I am getting this blank white screen which has been loading forever. I have cleared my cache, used different browsers, verified my access with administrator but still issue persists. Is anyone facing the same issue? And found solution?
-
Reference of numbered list via display name
I have a numbered list where code property is an index like 1,2,3,…… which i cannot use to pull the properties from the list. In this list i have 3 other columns p1, p2, p3 and in another module i have a line item which has similar values like p3. In this same module i am trying to get the values from p2 & p1 in another…
-
Capture Current Date Time Stamp in a cell
Hello, I want to capture Current Date Time Stamp in a cell when there is a change in line item? Is it possible with out implementing something too fancy?
-
4.6.5 Sale Planning Model: DAT02 module
In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data forward a year Hello, I am trying to…
-
NEED HELP ON LOOKUP
Hello, Good Day! Need some professional help on how I can replicate the weeknum function from Excel to Anaplan. I am relatively new to this platform. I have a module where I should be able to get the Peak Week from a date value (Peak Date). » So it's like the Weeknum function using the 'Peak Date Mid" value. I have another…
-
Issue on getting the values from the source module : Month (TIME) to Quarter (LIST) Concern
Hi, I am facing an issue in relation to getting the sales per quarter.Target Module : Account (List), Product (List), Quarter (List), Year (List) Source Module : Account (List), Product (List), Month (Time) I keep on getting zero value whenever I tried to lookup the sales from the source Module. I have already mapped the…
-
Custom Calendars
Is there a way to create custom calendars in Anaplan? Our customers work out of different calendars and we would like to be able to enter and report data according to each specific customer's calendar, while at the same time being able to enter and report data according to our corporate calendar. Any advice or links to…
-
Round Function
It would be great when using the Number of Decimal Places in the Round function if Anaplan rounded to the number of decimal places asked and it stayed rounded when going up the hierarchy. The summary is set to "SUM". For example, I have five children members with a formula ROUND(Value $ * value %, 2) function. Each of the…
-
Is there anyway to provide a notification to the user
Hi team, I want to create an automatic notification system. as you can see in below screen, there is a module with week time dimension and delta line item (difference of actual data vs forecast data). so, I want to notify the user via email whenever the delta Boolean is true ? How to create this in anaplan?
-
Export data source as a new tab
Unless the model builder names the saved views appropriately, it's often difficult to trace the source object of an export action. It currently indicates only the list name or the module name, but if we can have a tab for 'Exports' similar to 'Imports', to indicate if the source of export action is a module default view or…
-
Assistance with Locating the Level 2 Exam
I hope this message finds you well. Could you kindly assist me in locating the Level 2 Exam? Since the Anaplan Academy training platform update on December 3, I have been unable to find the exam for Level 2. If you could share the URL or provide guidance, it would be greatly appreciated. Thank you in advance for your help.
-
Share your feedback: modeling experience (deadline extended!!)
The product and UX team at Anaplan is looking for your feedback on your current modeling experience, specifically focused on building an appreciation for the challenges you face as a model builder in Anaplan. This survey is designed to capture this detail, so that we can explore how to simplify and accelerate the modeling…
-
DCA - How to lock/unlock checkboxes based on selection? [No Dimension]
I have a module (no Dimension) with 5 -line items labeled 'Custom 1' through 'Custom 5'. When any 'Custom' checkbox is selected, all other checkboxes should be locked but the selected (example: Custom 1) one should remain editable. If the selected checkbox is unchecked, all other checkboxes should become unlocked again.…
-
Certified Model builder Page
Hi, One of my friend, having difficulty to get 2024 recertificate. He has completed workflow but not able to access the link to issue certificate. I am also getting difficulty to find the link as there is new update for Academy. Can anyone have idea or link. Please do share. Thanks Ashutosh
-
Send an Email Notification if a Line Item Doesn't Equal 0
Is there a way to send a notification to specific users if a variance/line item is not equal to zero?
-
Calling all model builders: Share your feedback and impact our future plans!
The product and UX team at Anaplan is looking for your feedback on your current modeling experience, specifically focused on building an appreciation for the challenges you face as a model builder in Anaplan. This survey is designed to capture this detail, so that we can explore how to simplify and accelerate the modeling…
-
Share your model design best practices – November 2024 Community Challenge
We’re excited to announce our second Best Practices Challenge of the year! This Challenge series is open for Community members to share their expertise and tips on a specific topic. Join us to spotlight your knowledge and explore fresh ideas from other members in Community! For our second Best Practices challenge, we’re…
-
Returning same value from same Line Item but different items
Hi all, Is it possible to return a value from an item on the same line item? For example, picture this as my module: I want to be able to calculate a delta between S1 and S2 or S3 and S1, like this: Here I'm using SELECT but this will be a lookup since I want the user to be able to select which scenarios he want to…
-
Relative Model Map
When i open the Model map in bigger Models, Anaplan explodes… I need a smaller relative model map related to the Module im working right now. And just a few levels (1-2) of offsprings would be enough. //GP
-
Definitive Current User in a formula
Hi, I have a list of invoices with an approver selected from the user list for each line item, what I want to do is check if the 'current user' is the same as the 'approver' and if so then allow them to write to the item. I have a fake users list, and i can have a module with users with show all set to off, but none of…
-
Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers. Please find below details of my modules I…
-
how can i do it ?
Module dimensions : time , lines , zone Goal : display lines following this rule