Modeling

I've entered the formula for the beginning inventory but it doesn't seem to work completely.
Can anybody please help with what is wrong in the formula? IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
When deleting a formula from a module I would like the data in the module to also be deleted.
When deleting a formula from a module I would like the data to also be deleted/removed from the module. I realise the data can be removed manually by selecting the data in the module and pressing delete, but in a module with many thousands this is a time consuming process, particularly as Anaplan only allows deletion of…
How to illustrate historical sales and forecast departing from last point in graph with history
Hello All! I am trying to make a graph in which I have Historical Data and Forecast all within a same line. In the above example I would need that my green forecast start at the point in which I have historical data and more from there the same for all colors Thanks for your help
Input Modules
Hi, How can we identify the number of manual input forms that can be built in Anaplan? Is there any way by which we can reach to a ball park number for a client on the number of input forms to be created in Anaplan. Thanks in advance!
data tags
what is the use of data tags in anaplan
Help in tracing an error message when removing parent hierarchy from a list
Due to a change in functionality, I have to de-connect one list (Sub-Regions L5) from its current parent list (Org L4 - Region). I have gone through every module that has this list in its "applied to" and removed any references to its current parent list. When I try to remove the current parent list I get an error message…
SCIM APIs: A Use Case to enhance your Central Identity Management (CIM) Process
Need a refresher on SCIM? Read our [Start Here] article! What is User Provisioning? Let's start with a reminder; User Provisioning is a process by which an individual is granted access to the Anaplan platform and assigned the model role that allows them to interact with the information that they are authorized to use. We…
[Start Here] User Access Management - Part 1: Get Started
A foundational design element of any Anaplan model is User Management. This includes creating the design within the Anaplan model and app, as well as establishing the process for managing and maintaining access once users are active. The table below contains questions that are typically asked as part of the Foundations…
Model Builder 3 Training 5.5.1 Data Hub Model
Hi All! I am working on Model Builder 3 and am on step 5.5.1 which says: "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data Hub module". In my starter model, there is already a SYS09 Employee Details module with all of the information…
DAT03 Historic Volumes module
I'm working on the Level2 modeling and I'm stuck with this step: 2.3.9.1 Import data into DAT03 Historic Volumes module * Run Process 9 Import Data from the Hub. * This will pull the data into the Supply Chain model from the Data Hub model. * Make adjustments in order to avoid errors in the import process. When I run the…
Add List Subsets to Model Search (new modeling experience)
Please add List Subsets to the Model Search of the new modeling experience, with a link to the parent list. List subsets are currently very difficult to identify if they were not initially created with a good naming convention. I end up having to export all General Lists and using Excel to search for the list subset in…
Unable to download copy of Level 1 Model Building 2.0 (New UX)
Hi Sir/Mdm, I am not able to download a copy of the Level 1 Model Building 2.0 (New UX) model as part of the model builder training. Could anyone kindly assist.
parent hierarchy properties
hi! I want to view the properties of an item in the parent hierarchy from the child hierarchy. How can I do this?
Add “Open” button in line items subset menu
There is an "Open" button in any settings menu: "Modules", "Dashboards". Please see screenshot for the "General Lists" menu: But there is no such button for the "Line Items Subsets" menu:
Sort Modules and Line Items Alphabetically in Filter pop up
Please sort Module names and Line Item Names alphabetically in the Filter pop-up window. In modules where there are a lot of a lot of Line Items, it can be very difficult and time consuming to scroll through and locate the correct line item for a filter. This makes for a very frustrating experience as a model builder.
Question on how I set up my List
Hi, I need advice on how to set up something in my Model. I need to pull into my Modules a Time Setting that excludes Bank Holidays. I have created a List of all the Bank Holidays and plan to use this as a filter in my Module's. I want to know if this is the correct way to approach this task? A screen shot is attached.…
Bulk Copy Action - Details
Anaplan has released two major updates to its platform during 6th Nov 2021 release updates. 1. New Action for Bulk Copy 2. Optimizer Updates Here are some of the details around Bulk Copy that I observed. * This Action/Process will work only on Non Production Lists/Structural Lists * This Action/Process can only be run by…
YTD and YTG returning zero
Hi, I'm trying to calculate YTD actual revenue, and YTG budget revenue but they are returning zero. For example: this returns zero - module.Revenue'[SELECT: VERSIONS.Actual, SELECT: TIME.YTD, SELECT: Products.X] This statement works when I replace TIME.YTD with TIME.'current period', so the issue just relates to TIME.YTD.…
Importing Data at multiple level
Hi, I am trying to build a model which contains 7 different levels of product from the region, country, .., brand, to SKU level. The problem is whenever a user adds an SKU for a perticular city it is also automatically added to every other city and occupies a lot of space. How do I solve the space issue and give users…
Child elements belonging to the same list
I'm talking about a list with no parent hierarchy other than the top level, why is it that each item in this list can have an item belonging to the same list as a child element? ---------- I understand that this cannot be completely forbidden for compatibility reasons. However, I think that there should be an option to…
Incentive Compensation Management (ICM) back up best practice
Hi All, I have a question for Anaplanners running ICM. My company uses Anaplan for calculating commissions. We run into the issue of needing to compare the current month to a prior month. Currently I copy the entire model at the end of the commission cycle each month and archive it as a backup so I have a point in time…
Max value in a time dimension
Hello! I'm trying to get the maximum value of the item test1 in the time range FY19-FY30 and then use that value in an operation in item2. Any idea? In the example screenshot I attached, the maximum value of item 1 is 10 (FY30). In item2, I would like to do the operation 10*line item3. Any suggestions to obtain the max…
Consolidation of P&L
Hi, I am sure this is very basic but much appreciate any advice. I need to consolidate 2 P&L say Entity A and Entity B. Assuming both P&Ls are in 2 different modules (Module A and B) and both have different P&L line items. Module C is the consolidated module. I need to bring A and B onto C's P&L (assuming all 3 P&L line…
November 6th Updates - Examples? Documentation?
Great updates over the weekend. Bulk copy is huge. Anyone see any documentation on the optimizer and what changed? I'm anxious to learn more about what "solve more complex problems" means. https://community.anaplan.com/t5/Releases/What-s-New-November-6-2021/ba-p/124249
Formula Help Required :-)
Hi, I've recently been contact by our finance team with the below query - I wondered if someone could help point out where in the existing formula I can tweak to resolve. OLD Formula: NEW Formula: This has resulted in incorrect output in the field known as 'B6', please could you help me work out what i need to amend in the…
Searh Bar Location within the Formula Area in the New Modelling Experience UI
As a user in the New Modelling Experience, I would like the formula search bar to not cover the body of the formula, so that it is easier for me to navigate my formula while performing a search action within the formula area. Currently the search bar will cover part of the formula upon its invocation, which is not user…
New UX and New builder UI join links
I see a big advantage of newly came updated builder UI which has a direct link to a tab in the URL. Using it builders and users could open classic UX with not just a main page of the model, but the specific module mentioned in a card or at a worksheet in UX. Or maybe even to open the specific Module view (if it's not a…
open a list and keep it open
Hi Team, Would to be able to open a List as a new tab as with opening a module. Then it stays open until I close it. I appreciate best practice is to create property modules but we don't need property modules on all other lists and we have enough to build already. So before I go building formulae I can first of all open…
New Modeling Experience: Object Base Research for Saved Views
I can't use new Object based search (SAVED VIEWS, Line Item Subsets) for Saved views because I don't see module name anywhere. Would be nice to have either Module as a separate column or [module].[view] combination. ('Module A'.'Import Snapshot')
New Model Experience: Allow all users to use Model Search
We have a contents list that is huge, and finding a dashboard can be a pain as there is no search option. In the new experience there is a MODEL SEARCH, but only for workspace admin it seems. Can this be made available to non workspace admin?

Modeling

Discussion List