-
Why does it take Anaplan so long to reject a formula?
I make mistakes when entering Anaplan formulas. If rejected the message "Closing" comes up, and it then takes Anaplan between 1 and 5 minutes to finalise the rejection and come up with an error message. Why does it take so long?
-
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…
-
Import 2 number list with identic Parent and Code
Hello, In Model 1: I have 2 Number List: Payer Sold to, with parent Payer Every line in organization, also exist in Sold to list. As example: Name: Parent: Code: Aushan _______ 12 - Payer Aushan Aushan 12 - Sold to Aushan Aushan 15 - Sold to In Model 2: I have 2 Number List, as well: Payer Sold to, with parent Payer I copy…
-
Can a parent numbered list and child numbered list have the same code?
Hi All, I have a parent hierarchy in numbered list.Both are uniquely identified by code. Parent List : Program Child List : Project So When I am importing into child list(Project), it is ignoring some of the records. After the analysis, I found that the records that are being ignored have their codes already present in…
-
Anaplan Power BI connector - not refreshed from Power BI
Hi all, I am working with Power BI connector for the first time and have a problem with the Refresh part. The first time data from an export action is imported into Power BI by Power BI dev team, everything is OK. When numbers are changed in Anaplan and a manual Refresh is done in Power BI, data is not refreshed. If I test…
-
Show Total in Module even after applying filters
Hi All, In one of my moduel having a column "Rebate Payment Amount" which has values, and also we set the show TOTAL on Above for giving total aggregated values as single value, it works only if we didn't apply any filters on the remaining columns in the module. How to show the 'Total' i.e. sum of all rows for the column…
-
Data validation overview
Author: Audrey Neet is a Certified Master Anaplanner and Director at Tru Consulting. Data validation is the process in which business users ensure that the data in Anaplan ties to their source system. It's an important step in preparing a model for go-live as it ensures the data in the model is accurate and the end users…
-
Drill to Transaction Functionality in the New UX
Drill to Transaction Functionality is considered critical for some partners/clients as it's functionality that has no alternate solution. I have heard specifically from FP&A implementations regarding allocations, as well as ICM use cases, but would love anyone giving kudos to leave comments with additional examples of it's…
-
2.3.10 Activity: Create Demand Forecast
Hi all, I'm stuck on this activity, I'm pulling through a 0 value for Default Forecast on Week 6 FY21 and the answer is suppose to be 73.48.. I'm not sure where I'm going wrong, I may have used the wrong formulas in DEM03. Can someone please point me in the direction
-
Help with L1MB lesson 8.5.3 Activity: Import Data into Volume Inputs Module; Import not working?
Hello — I have been trying to import the data file Volume+Inputs into the REV02 Volume Inputs module with no success. Just a couple of disclaimers: I am in grid view when I try to import I have refreshed both the lesson view and the example view I have re-downloaded the file I have updated the grid view for the time being…
-
TimeSum for a specific line item
First Module List: SKU's Dimension : weeks Line item: Volume Second Module List: 1- 100 ( a list of the numbers 1 to 100) Line items: Start week, End week, SKU, Item I want a timesum in the second Module from the first module TIMESUM('Volume Module'.'Volume', Start Week[LOOKUP: Item], End Week[LOOKUP: Item]) This works for…
-
PREVIOUSITEM() - PREVIOUS() on a list
Referring to the previous item in a list is a nightmare: You can write a lookup to find the previous item, but as soon as you try to use it you get a circular reference. Sometimes you can get round this with creative use of the CUMULATE() function on your list, but sometimes you can't and you need to map your calculation…
-
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…
-
Black Box Timesum Drilldown
One of the best things about anaplan is the ability to drill through the model to see where values come from. sadly, anaplan is now quite limited in how you aggregate over time. at some point changes were made that more else require you to use the timesum function to aggregate over time specifically (SUM: does not work).…
-
Source model switches automatically on changing page in NUX
We are facing a issue where user selects a new source model on a page and then when he moves to different page the source model changes. There is 1 model for each country. The user wants to do the planning for first country and then move to another country. What really is happening is that the planner make some changes in…
-
New UX - column's width for grids / worksheets
It would be great if it's possible to define the column's width by numbers (% or px). It's a very time-consuming exercise to match it manually if you have similar columns in the same module or similar modules on a page: or
-
Updation of forecast data in one grid in a UX page updates the same data in another grid & UXpage
I have two different UX page sourced from 2 different models. The requirement is that in one UX page there is a grid where the users can update forecast data month-wise for various cost centers , like wise in the second UX page also the users can also update the forecast data. Now the requirement is that in both the grids…
-
2.3.8.4 Create DEM02 Volume Growth Rates by Week module
This is my data on monthly basis what I am doing wrong?
-
2.3.10 Activity: Create Demand Forecast - Nothing happens
Hi there, for Baseline forecast: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET (Default Forecast, -52, 0) This formula seems right and it's the same thing I've seen from the solutions offered in the forum. But nothing happens. Also,…
-
Boolean check after certain time period
Can somebody help me if a boolean is true for a particular month and if we need to make the boolean true for all the months coming in future how can be do that? Also, after few months if I want to make that boolean false, how can we do that?
-
How I Built It: Creating functional P&Ls using line item subsets without COLLECT formula
Author: Austin van der Linden is a Certified Master Anaplanner and Senior Model Builder at Hubspot. Hello Anaplan Community! In this 'How I Built It' Tutorial, I show how you can build functional P&Ls using line item subsets as a mapping tool. One of the cool functionalities provided with line item subsets is that you can…
-
Can we create actions from one prod model to the other prod model?
In my organization, we have two prod models and one dev for both of them. Can we create an action in this case? The user asks to reflect the data from one UI page to another, but they are from two different models and a common dev. Is this doable?
-
Enable API or Save as Action for Exporting Dashboards to PDF
Currently, there is no direct way to export Management Reports, NUX Dashboards, or Classic Dashboards in PDF format via API or through an automated process. This limitation impacts reporting workflows, as users often need to manually export dashboards, which is time-consuming and inefficient. The ideal solution would be to…
-
Level 2 Sprint -2:2.3.10 Activity: Create Demand Forecast Baseline Forecast FY21 data as zero.
Data03 having data of FY20. But DEM03 Demand Forecast Module FY21 not having data . Can anyone suggest what need to be done?
-
Stop a process in CloudWorks
I kindly ask to add a "stop" option in CloudWorks Integrations Menu, because I have a process which is stuck and I need to spent a lot of time to delete and re-create it every time a process doesn't work. Thanks in advance!
-
Ability to add Folder structure to Lists, Modules, Actions etc
Being able to keep a model clean and well organised is really important in allowing model builders to understand and work with the model going forward. Often we find that as a model grows, the number of lists, modules, actions etc grows quite large and can start to become difficult to manage. This enhancement idea is to…
-
BULK COPY - How to choose the SOURCE member and the TARGET member from a page in the app?
Hello Anaplan Community! Does anyone know how to choose the SOURCE member and the TARGET member from a page in the app? Thanks in advance. #NewFeature #UX #Dashboards #BulkCopy #Data #AnaplanRelease
-
Designed behaviour of updates in "Start Date and Time(UTC)" of a process.
What is the designed behaviour of updates in "Start Date and Time(UTC)" of a process i.e. whether it is updated at the beginning of the first action of the process or at the end of the last action of the process?
-
Level 3 Model Building
Hi… how much time does it take to finish level 3 model building??
-
Make Grid Line Color Editable/ Invisible
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Currently, there is no option to edit grid lines. I want to be able to make grid lines invisible or chaange the color of the grid…