Modeling

Retrieving last non zero value for daily exchange rates
Hi, I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 2021 but none for 2nd and 3rd of Jan 2021, so the daily exchange rates for 3 Jan 2021 should display the rates of 1 Jan 2021…
CloudWorks
Hi, I have just started using CloudWorks, it's a great Anaplan in-built tool for integrations and processes but does anyone have any idea how can we run subsequent process in it. for ex. I have a process A and process B in my model and I want to run in a manner that as soon as process A is complete, Process B should start…
Mouseover Hover Text for Model Builders
I think it would be helpful to model builders if there was a hover over option to display the text of a particular element. There are instances where the description is cut off for certain display elements and there is no option to resize columns for that element (I see this most frequently in the Module Blueprint and Data…
Talent Builder Workspace Extension
Hi Community, Currently we are using talent builder workspace for all learnings and have exceeded 90 days trail period. Is there any way to get an extension of the time limit? If we reapply for new workspace will the old model stays as it is or do we have to create the model from scratch? Thanks & Regards Badam
Allow column Formatting on Lists Grid View
Lists with multiple subsets (having long SS names) become confusing in grid view where columns only show partial names in headers. There should be an option to format columns similar to modules to increase column width etc.
Can you link to a specific record on a new UX page
I have a list of projects and i have a line item that is a link to the project page, but would like to go to the specific project they are clicking on. The html for the page is the same no matter what the item, but can you add a tag to the html at all, like you can in other apps?
Expand "Tree View" for Lists beyond 1,000 items
Lists automatically convert from "Tree View" to "Grid View" once the 1,000 item limitation is reached. In my opinion, the Tree View is much more aesthetically pleasing and easier to navigate, particularly as the data set gets larger. It would be great if the Tree View was maintained for an infinite amount of items (or at…
Add List Search Option while create module and Import from Existing Model
Hi Team, If we provide a search option to select a list when creating a new module, it helps model builders select the required list. Similarly, if we provide a search option to select the source for any import from existing model views or lists, it also helps model builders.
Add List Search Option while create module and Import from Existing Model
Hi Team, If we provide a search option to select a list when creating a new module, it helps model builders select the required list. Similarly, if we provide a search option to select the source for any import from existing model views or lists, it also helps model builders.
Planual
I am proud to announce the launch of the Planual, the first-ever collection of global best practices for Anaplan model building. Created by Anaplan experts, customers, and partners, the Planual collects a wide-ranging set of guidelines, techniques, tips, and tricks organised to help model builders avoid common problems and…
New to Forum
Hey everyone! My name is Chad Pyke. I just started my Anaplan journey and am excited to learn from each of you! I'm hoping to transition into a career in Anaplan/EPM by EOY and would love any advice or counsel you have on the customer vs partner track. Thanks!
How to calculate Anaplan model size?
Hi Guys I am using below calculation to find model size 1000000000 cells = 9.3 GB 1 cell = 9.3/1000000000 Total cells exported from module export = 6206436639 which gives me 57.71986074 GB's problem is Anaplan shows model size as 39.29 Gb's ?. I have used this calculation on 8 models and all of these comes close to model…
from where to get cotton candy data
Hey Team, From where to get cotton candy data for model building. I recently started learning can anyone tell me.
Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?
Drag & Drop Manage Views
The current process for managing saved views for modules is a bit time consuming. If you have a lot of saved views for a module and you need to sort them out. You need to click each saved view and either click "Move Up" or "Move Down", then it would still take time for the system to refresh. So imagine if you have 10 or…
Level 1 MB Exam - Error in Activity 4 - Please upload the correct .CSV file
Hi Community, I faced an issue while attending my Level 1 exam in Activity 4. while importing the file. the .csv file (in the column headings it is showing " comas in first and last columns which is crating error while running export the file) itself showing is an error. however i resolved by editing the file then run the…
How to know a parent is selected
Greetings, We have a model where a Employee have territories assigned, each territory have accounts assigned. At the moment if we edit the end date of a territory the end date of the accounts stay the same. So i want to make a formula where if we mark the territory for edition , a boolean on the accounts gets active as…
Uses for TEXTLIST
Hi All, I am unsure where I might use TEXTLIST function. There has never been a need for me to use this but I would like to understand where, when and how this might be useful. Your insights are much appreciated!!
More descriptive history entries for Blank Model Changes
Model history can contain entries saying "Blank Model Change", which can occur for example when changing the SSO access of a user. These could be more informative so we can understand what the change was. Another example - if you are setting a users access, it is usual to copy another users access by selecting an entire…
Waking up the model with Cloudworks
Hi everyone, As you know, initializing the model (moving it from disk to memory) can take a while, especially for the larges ones. This can be quite painful for the first users of the day, or for the first one to connect after lunchbreak. I don't find precise or recent informations about it, so here are my two questions:…
Additional modes for Formula Scope
Whilst the current method for formula scope encompasses the existing options (Actual, All Versions, All Versions Except Actual and Current), there is sometimes a need for formula scope to be applicable to specific versions outside of this scope - For instance, side loading of a budget. Whilst Add Version Formula covers…
2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Hello, I have followed the instructions in "2.3.8.4 Create DEM02 Volume Growth Rates by Week module "and used the formula WEEKVALUE('DEM01 Volume Growth Rates'.Growth %) but the values are zero after using the formula. Not sure whether I am right or wrong !
Flat list module to module with key made from the flat lists
I have a module dimensioned by 4 flat lists. A line item in this module creates a key using 3 of these flat lists. I have another module dimensioned by the key and the 4th flat list. How can I map data from first module to the second module?
unable to click from model search
Not sure if anyone has raised this bug already, but when I do a model search in the new modeling experience (which is now the default setting), I get the results but can not click into any of them. Weirdly I noticed that it doesn't open the list/module/db etc. if you click on the name (text area) but works if you click…
Referenced by for filters
I would like to see details of whether a module or line item is actively in use as a filter. When a line item is referenced by a formula elsewhere the target line item is displayed in the reference by column. Can this be replicated for line items which are used in all types of filter? This will help significant when…
Variance module using item subsets
Good morning team. I have a labour model that I am looking to add a variance module to and need some assistance understanding my options. As we have a number of different versions, using native versions for the variance is inefficient and will cause the model to grow much larger than required. The planning module currently…
Offline mode marker to be visible in NMX
In NMX I cannot differentiate whether my model is online or offline. In Classic we had this marker when it's offline Idea is to add the same marker to NMX.
Different formats for one line item
Hi all, A user can input data in the following way: Event type Event Date of the event Is there a way to define different formats for the line item "Date of the Event" on the basis of the other line item "Event Type"? As an example, when I input "Event type 1", the "Date of the event" is Time Period Format, (Type 1, Event…
Shipping time weeks
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] After applying this i am not getting data populated in shipping time week line item
Copy data from one month of Current Year to all the months of Future Year
Hi , i would like to copy the data from sept 2020 to jan2021 -dec,2021 for Budget version and take May,2021 data and copy to Jun,2021 -Dec, 2021 for forecast version. Any suggestions to achieve this.Sept 2020 Jan 2021.....March 2021....Dec 2021 20 -- 20 20 20 Thanks Sri Nitya

Modeling

Discussion List