-
Anaplan Time Range Limitation
I was very surprised recently when I discovered a limitation to Anaplan's permitted time range. It may surprise others to know that Anaplan is limited to supporting only 70 Years (20 past and 50 future) and the maximum number of years possible is 90 (using a time range set, as of writing, to 1981 with 90 periods). I did…
-
Avoiding circular reference using daily workaround to simulate PREVIOUSITEM() function
I'm working on a tops down attrition allocation model. We want to be able to input an annual attrition number and allocate that down to the lowest level (Month, Country, Segment, Attrition Type, and Tenure). Given that attritions have to be whole numbers I've been using MOD() to carry forward the probability of an…
-
How to pull the data from module to list
Is it possible to get the data from module to list? I need to pull the SYS C4.Code to Sales list in order for me to use in lookup for SYS Sales.New Region.
-
Refresh data hub to Spoke model
Hello, I have two lists on my Datahub. On the Spoke Model, I import these lists through a saved view, and on Apps I have a spoke model refresh page that should import me the changes made on the Datahub app. On the Data Hub App: I can add a line to the list and I can delete it. The problem is that when I refresh my spoke…
-
Dashboard to show occupied space by building blocks
Anaplan must have an option to show actual occupied space in MBs by objects e.g. line-items (rolled up by modules), list items, versions etc. This is area which needs extra calcs OR sometimes builders (including SA) struggle to find the reason of actual model size.. A leap in this direction will help the builder community…
-
List to module, most efficient way?
Hi Do anyone know what the best way to link a module to a list is? Cause in our models we keep databases in lists, to be able to keep track of the history. The end useres are uploading a data file, which is then stored in the list, with needed column data saved as properties. My question then goes on what is the best way…
-
I need to add new item to Tree View (General List)
There is no option to enter a name to 4060 item line. Can someone help please?
-
Data in List Properties Clearing Mysteriously
Has anyone ever had mysterious issues with a very large set of Model to Model actions in one big process? We have issue where data is being cleared out of list properties and it's totally mysterious as to why (have double checked 100 things, all the imports, the data sources, the saved views etc. there is literally nothing…
-
Select the level or levels at which the summary can be applied in
When dealing with an extensive hierarchical list and aiming to generate a summary, it would be advantageous to have the flexibility to select the desired summary level (or choose all levels) This flexibility can greatly optimize the process.
-
Community Perspective: Introducing PlanaPY - A Python library for simplified Anaplan API integration
Author: Erik Schau, Senior Business Analyst, The Duckhorn Portfolio. Introduction As data-driven decision-making becomes increasingly essential for businesses, the demand for seamless integration with enterprise planning platforms is on the rise. Anaplan offers powerful APIs for developers to interact with its platform,…
-
Top 25 Anaplan features released in 2023
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Boss, and CEO/Founder at Miz Logix. Within this fast-pacing world it is important for technologies to move even more faster. Anaplan — being a leader in the Connected Planning world — released a plethora of changes and/or updates in 2023 to almost…
-
link text-formatted line item
Hi All, I have a question from a partner.., Can you please confirm that it is not possible to link to a file destination in Anaplan using a link text-formatted line item. The link text-formatted line-item defaults to http// and the file destination our client uses has a different prefix using backslashes (\\). The links…
-
Drive dimension selectors from undimensioned module
Hi, Is there a way to drive dimension selectors from a module that has no dimensionality? I have 2 modules: Select Dimensions no dimensionality, just line items that are formatted by dimensions entity and department, etc Income Statement dimensioned by entity and department. End-users would like to make entity and dept…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
Equation of a Trendline in a Scatter Plot
Can we somehow get the equation of the trendline from the scatter plot? We can use the equation then for further forecast.
-
How to bridge the 2 modules with different dimension?
The end goal is to capture the new region from the source module [SYS C4]. However, the source and target module [SYS Sales] have different dimension. In the source module, the code line item automatically updates whenever there is new region plotted. In the target module, the target line item is the new region - the…
-
anaplan level 2 sprint 1 activity 1.5.6.1
Hi all, I have problem while importing data into Historic Volumes Module. The csv source file contains data (image 1), but when I run importing into modules (image2&3), there's no data at all (image 4). What should I do to fix this problem? And by the way, I do not get why we select "Column Headers" for "Volumes". I got…
-
Why is there a round at the end of a number converted from text?
Hello, I am converting a text into a number to do a complex sort. It adds code from several different dimensions to create a large text. Then I convert it using value. When I do this, the final 3 digits are being rounded unnecessarily. Does anyone know how to get past this? Original text: 23921101010004270452 Converted to…
-
Refresh failed due to an unexpected error - Excel Add in reports for some of the users.
Hi, There are some Financial reports that has been created using Excel add in functionality. Some users are having issues while refreshing it and getting error message. Whereas others are fine with it. A few users are getting this error for some of the reports, but they are able to refresh other add in reports. Could…
-
How to manage Workflow-Approve/Reject
Hi, I am trying to create workflow for my project. My module has product(10 prod), customer(10 customers), channel, & version dimension Product, customer & version list has selective access enabled. I want to create workflow for single quarter, Step 1) Assigner workflow to planner , he will plan everything in top grid and…
-
February 2024 Community Member Spotlight: Alessio Pagliano
Join us in celebrating @Alessio_Pagliano as our featured Community Member Spotlight for February! Alessio's inspiring journey in the Anaplan ecosystem spans seven years, marked by notable achievements such as becoming a Certified Master Anaplanner and a Community Boss. Explore Alessio's impressive Anaplan journey and…
-
SOS : A modeling question
Hello Everybody , I have two lists in Anaplan , let's name them countries with all the countries in it and a second list called products with all the products that a company have. I want to give the possibilty for the user if he check a country , he will see only the products in his country. So my question how we can do…
-
Multiple revision tags
Hi All, We can create multiple revision tags in the dev model for specific changes & while performing sync with PROD, these revision tags gets highlighted, however if I select the latest revision tag "add6" - all changes incl. changes specified under "add4" also gets updated. I believe revision tags works cumulatively, if…
-
Summary Calculations With the User List
Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…
-
Convert date to time format
I want to calculate the # of days in a month without using the PERIOD function. No time scale for this module. E.g. 10/15/2015
-
Variable Rounding
It would be helpful to allow the use of variables for the rounding direction and method, instead of only permitting hard-coded value. I'm working on a use case where for a certain planning scenario, there is a need to round up for certain product/country intersections, but round down elsewhere. I have a workaround, but…
-
Left margins on rows headers
Hello everyone, Does anyone have a good trick to get the left indent on the rows in UX grids to go all the way to the left. I just can't get it to move over there, especially when I use a hierarchy. It's taking up a lot of space and makes the whole dashboard look bad. I've tried: I Show/ Hide only the level I want to see.…
-
Alternative to SELECT:TIME.ALL PERIODS?
Hi, Is there an alternative to SELECT:Time.All Periods which will allow us to query whether a line containing time contains data not equal to zero across all time periods. The target line item does not contain time. I would usually just use SELECT but I would like to get the same outcome without having to use All Periods…
-
Move Excel Worksheet with Anaplan connection to new workbook - Excel Add in
Hi, is it possible to move a worksheet with an existing Anaplan connection to a new workbook without the connection disappearing. Thank you
-
Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file
When i am trying for 2.3.9.1 getting error as "Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file map to the correct dimensions in your module, then run the import again."