Modeling

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…
From Native Versions to Fake Version List?
Hi All, As it is not possible to SUM down native versions is there a simple mechanism to take data out of versions and restate it within a fake version list? I know this is achievable via a series of nested IF THEN ELSE queries but this approach is not sustainable as it needs to be updated every time a new native version…
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…
Conditional Formatting on Booleans
As a model Builder I would like to use Booleans as a Basis for Conditional formatting. For example. I have a Boolean/ Checkbox which indicates that not all fields in a new Item/ setting has been filled. I would like to be able to use that boolean directly instead of reverting to a number. The advantage would be to save on…
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…
The ability to add a dynamic sub total to a grid
I would like the ability to add a dynamic subtotal to a grid, so when rows are filtered out the total is updated on the fly
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:…
New Function To Convert Date Format to Text Format
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function. Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.
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 !
Easily Get Current Date Using CloudWorks
Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using python for getting today's date. But this approach has some cons: * You must learn to code or involve someone who can do it.…
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.
Level 2 Model Building Conclusion - DEM04 Demand Export Demand values
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? My DEM04 blueprintview: Baseline Forecast: Thanks in advance!
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…
[First Look] Create page
Feature: Create PageRelease Date: 02/28/23 Impact Assessment: Tighter link with UX What is changing? A new button is available in the Pages interface called “Create page” that gives you the ability to create a page in an existing app. Once the button is clicked, a new tab will open that will allow you to setup and design…
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
How can I get PY Sales Revenue from Sales Revenue in a module without a time dimension?
I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for a particular territory? I tried the following and got errors: Sales_Revenue[lookup: territory_id, lookup: PY ar_date] Sales…
Modelling using users properties
As a model builder, i d like to be able to model aroynd users properties that are found in "users" panel in order to bring new functionalities to functional admin users, granting them in dedicated modules or actions within a model the following - ability to check users selective accesses rights (read / write permissions)…

Modeling

Discussion List