Model Builder

Show process Id into actions window
it's would be useful to display process Id into actions window (in a dedicated column)
February 23rd Model Builder Forum Follow Up
Hi everybody, Following the Model builder forum on Friday February 23rd, I wanted to provide a build along example that is more specific to higher education. I have put together an example of position planning as it relates to budget development and split funded positions and recorded a video walking through it (here is…
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
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…
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…
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…
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
How to select only one Boolean line item at a time by disabling all other Boolean options?
I want the user to select only one boolean line item at a time. When the user selects one boolean, other booleans should not be selected, and once the user unchecks the selected boolean, all booleans should be available for selection.
How to set automatic refresh when filter is updated to new value
Hi All, As I was building the UX Pages and came across on roadblock wherein each time when I change country and segment in field card I had to refresh the page again to get new country and segment values. Please requesting for inputs on how to set automatic refresh when I change the filter to new country and segment Below…
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
Filters for lists
Filter options for lists e.g. users lists So we can filter on model role, single sign on …. etc Reason Easier to manage large users list
Anaplan for career growth
Author: David Edwards is a Certified Master Anaplanner and Principal at Columbus Consulting. Anaplan has long been a tool for driving growth and transformation within the companies that utilize its technology. However, it is also helpful to understand how being well-versed in Anaplan implementation and development is a…
Designing models that scale
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. One of the aspects which determine whether a model will meet the need of the business is how well it can scale. Whether the constraint is balancing numerous concurrent users, or having dimensions with high indices, or both and…
L3 Sprint 2 building the list: G4 Territory > Account#
Hi Community, I started L3 wherein we have to build G4 Territory > Account# list in Sales Planning model I followed below steps as per training Firstly, loaded the Download: Territory Data.csv into Data Hub model into Territory Flat List system and built system module below is the image attached of both list and sys module…
Adding instructions to Line items
Hi Community, Curios to learn on how to add instructions to line items of module on UX Page. Kindly requesting for your inputs on how to setup on UX. Please refer to below screenshot for more information
Model Search enhancement
Just an idea, it would be great if we could add in 'Model Search' ability to search module+line item. For example instead of searching module name and then line item or searching line item and trying to find correct module, we could just pate in the 'Model search' a 'module name'.'line item name' so it would give us…
How to Delete a column data if data is imported action
Hi Community, Requesting for your inputs wherein, I need to delete a column data wherein to create a empty staging module which in turn will be used a import action to main module in L3. Requirement : to delete Override Sales Target column data Below is the attached screenshot for more reference Thanks.
Modelling Ideas
Hi All, Is it possible it have a view like this in Anaplan? (Q1-Q4- Time range - how to fit in GAP in the same row). Revenue, GM, OPEX, EBIT will be line items and ASI,PMO,PPT will be list. Please give suggestions on how this can be implemented. Thanks in Advance.
Tips on role communication and building Anaplan models
Author: Chad Frantz is a Certified Master Anaplanner and Senior Consultant at Lionpoint Group. It can be tempting when developing a new model in Anaplan to jump right into the technical aspects and start building to get all the benefits as quickly as possible. But one aspect of optimizing the modeling experience that can…
Aggregation Formula not working
Hello, I am having a hard time trying to make a formula work in a summary output module: The dimensions are: time, r&d cost voice (list items: reticles, moves, licenses, services, labor, depreciation, general expenses, other) and cost center. What I expect the formula to do is to get the values from the calculation modules…
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest valued cell in a given line item?
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…
Anaplan error: Line item not recognized
Dear Community, I encountered an issue during the build of some of our projects and would appreciate further clarification if possible. Brief description of the case: I have two modules, A and B, that contain the same line item names "Adjustment" (module1.Adjustment, module2.Adjustment). When I tried using the same formula…
how can we decide the order of data while displaying them in grid in a reporting slide
so if I want to compare line item values for A,B,C,D,E but i select them in order of BCDAE for displaying in grid in the management reporting slide feature of Anaplan. How can that be worked out?
Referencing a line item that has formula summary method, not displaying correct number
Hello, In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement IF XXXX THEN XXXX.'TV Programming (Final)' ELSE 0 However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are…
How many hours of work would you estimate it takes to obtain "Certified Anaplan Model Builder"?
Specifically referring to the timeline from the beginning of level 1 trainings, through "Intro to Polaris". If you could also provide an hour estimate to becoming a certified solution architect. I understand there should be 9-12 months of real-world project experience. For this I'm just concerned about the hourly…
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
Revision tags with multiple builders
My client is asking what is the best way to allow multiple model builders in Anaplan independently? In the current system there is no way to isolate what changes should be moved to other environments, i.e., revision tags are cumulative. How do you all handle this?
Use fake week to replace default week calendar
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Some businesses run their planning or operations by weeks. However, setting the Anaplan model default Calendar Type to Week format can be inconvenient. For example, converting dates to monthly format can sometimes be…
Formula Summary for reporting
Have to run a variance reporting for 3 Line items. In the source, the line items have dimensions and Time(Quarter). The variance Reporting module is run by the same dimensions, the source line items act as a dimension(by line-item subset) and looksup the Year selection by the user. The challenge is that one line item has…

Model Builder

Discussion List