Modeling

Building a Long Range Planning Model
Hi, I'm a new Anaplan user (completed L1 model builder). I'm starting a project to get our current Long Range Planning model from excel into Anaplan. This is my first project and I'm wondering whether other group members have any similar experiences. There is a template LRP model in the App Hub which I'm considering using…
Level 1 Modeling Activity #5
Hello - I have been having similar issues with the formula updates to the Bonus%, Car Costs, Phone Costs and Medical Costs in the EMP02 Module - when I try to update the formula as below I receive the error message. I am seeing posts about removing the Role List and reimporting without the Parent Column and the reimporting…
SKU to Format, Flavour, etc
Hi Guys. I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3. The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore…
Retrieving user selective access in module
Hi, I have an issue in my Workforce Planning model I can't quite get my head around. The scenario is the following: I have an organisational hierarchy with Cost Centers and then Individuals as childs. I have selective access enabled to my cost center list and only certain users have access to certain cost centers (and…
Is it possible to have a "Create" Action on a list with no parent?
Is it possible to have a "Create" Action on a list with no parent? If not then is there a workaround?
Schedules Mapped by Entity Name in Anaplan
In Anaplan, I have a schedule that needs to have the name of an entity name change to the English version. I was put on notice recently, that the schedule is being mapped by the entity name. Can anyone provide guidance on how I would be able to see in Anaplan exactly how that schedule is being mapped by entity name and…
Sum based on Parent in Hierarchical List
Hi, I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item. How can I calculate this sum, as it is the sum of all items in L3 under L2 a…
Level 2 - Sprint 1 - 1.5.2
Review DAT01 Beginning Inventory Module * Module Name: DAT01 Beginning Inventory * Dimensions: SKU Flat list, s Location Flat: Distribution Center? list * Category: Master Data Line Item Format Purpose Beginning InventoryNumberBeginning inventory count (opening stock) for each product SKU by Distribution…
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?

Modeling

Discussion List