Model Builder

2.4.4 circular reference error
Hello Everyone can I know why there is a circular reference error when I try to enter this formula ?
Cant able to open Sprint 1 course in Level 2
Hello Everyone I have finished Level 1 and got the certification and continued to Level 2 introduction class, and I have finished it . but when I opened the sprint 1 class, the cursor was not changing to the input method ( hand symbol ) to click and start the course. the course open button remains like the text Can I know…
Used in Pages (Apps) column
On the Actions and Modules tab, similar to the 'Used in Dashboard' column it would be useful to have a 'Used in Pages' column which shows where action or module in used.
Edit default column width in maximized view
The ability to edit and set the default column width in maximized view would improve the user experience immensely. Now users need to adjust column width every time they open a maximized view which is very inconvenient.
How can we create action to load Existing items line item to Applicable Products line item.
This is the screenshot of the module containing both boolean line items.
Editable nature of cells within grid is inconsistent over time, not due to version
Hi Anaplan Community! I am working within an Operating Expense financial model, I have a module to allow for manual adjustments by department. This module contains a line item "Amount" with no formula, to facilitate the manual input of adjustment amounts by spend category. The Model's Time frame is 2022 - 2028, and I am…
Drag and Drop functionnality (Line Items - Modules)
Hello It's will be helpful to have the drag and drop functionnality directly on each line item in order to rearrange easily on purpose Regards Patrick
Data loss issue
I've encountered a strange issue in our model. To give you the context - We run a scheduled process through REST API to copy data from one version to another version. We tried running this using cloudworks, it did not work (I'm assuming because once of the action in the process has filter based on User Write Access). So we…
Drag and Drop Actions (Process - Imports - Exports - Others)
Hello It's will be helpful to have drag and drop functionnality in the Actions page in order to rearrange them inside their respective bloc (Process, Import, Export or Other Actions) so it will be easier to group them if need include actions into a process using the drag an drop dunctionality Regards, Patrick
Issue in LIS where one line item is shown as a parent of another.
Hi, I have created a LIS from two different modules with a total of 3 line items. The two line items I selected from the first module however are having a parent child relationship when I use the LIS as a dimension in another Module. This should not be the case as all the line items are independent. The First Image is the…
Preview Window before creating Revision Tag (Preview of the result in the target environment)
It would be useful to have a preview window of the results of development done in a model before creating a revision tag (for synchronization). This involves setting up the ALM. This mode exists in the new UX in page builder mode Thank you Patrick
Import action failed while running through Cloudworks
According to the given screenshot, error thrown by Cloudworks is - "Hierarchy import has both Name and Code unmapped". Although, manually the import action is running fine. Need some help. Thanks,
How to count the number of times a month shows up minus 1?
Hi, I'm trying to create a logic into the line item "End". My goal is to count the number of times a specific month appears without including the first occurrence. If November appears 4 times, I would like the "end" line item to display 3. Similarly, if December appears 5 times, I want "end" to show as 4. I want to use the…
Assigning List item based on Text line items and looking up - COMPLEX
Hi Community, To give the backstory of this - I have a module, where I first import one data file into, with Loan-Hedge ID List) and line items as the dimensions. The second file I import is a similar one, also with Loan-Hedge ID (List) and line items as the dimensions. When importing the first file, these Loan-Hedge IDs…
Calculation based on variable selection from a user
Hi team, Got a problem I am trying to work through and have hit a roadblock. I am working on a forecasting tool and having trouble with dynamic selection of variables for basing my calculations on. For the purposes of this I have a list of accounts which is 62 members long. I have a driver module it is dimensioned by time,…
Level 3 Model Building Sprint 1: TAR01 Detailed Sales Target module
I'm working on my L3 Model Building, It has been paused for quite sometimes due to my confusion in how to fill The TAR01 Detailed Sales Target module. I can't even create a module to verify the The TAR01 Detailed Sales Target data. Here is the TAR01 Detailed Sales Target module that have been filled Here are the formulas I…
Hi Everyone, I am reaching out to the community for some help with a formula.
I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!
LiS for Export module
Hello Comunity, I am trying to build a LiS on order to have a selection of the Forecast and the Type of the FTE. The problem I have is that when I try to build my LiS on my Forecast Model, the FTE Type is a subset List put in pages. So I won't be able, in my LiS to have the Forecast by each FTE Type(the selection is not…
Model change best practices (Sept 2023 Community Challenge recap)
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. There were so many detailed answers to the September Community Challenge — it was a challenge just to sort through all the great information! To help the Community, I thought it would be helpful to…
Filter multiple dimensions as rows
Hi team, Im working on a rolling forecast module and have the following dimensions Versions (page), Time (columns) and Cost Centre, Gl and line items as rows. one of the line items is an input called temporary variance and a requirements is that across all time that the temporary variance sums to 0. My problem is, I cannot…
How to convert an annual amount to a monthly amount
I have 2 modules, both dimensionalized by the same list and time (1 is by year and the other by month). I need to take the annual amount in module 1 and spread it over the monthly amount. I've tried spread(Annual Amount, 12) but I'm not able to get anything to populate in the monthly spread module. Any guidance would by…
Dimension Help for Equity Waterfall
I am new to Anaplan and am currently doing a project for fun. I am trying to recreate a equity waterfall that is commonly used in Private Equity. I am currently stuck on an issue on setting up dimensions that will be used for the waterfall calculation. Attached are screen shots of what I am trying to recreate in Anaplan.…
How to hide line items in UX avoiding repetitive hide UX command
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, responsible, employee name, labor cost line items only for the first project (1-Av-Bc - Argus V1); in short, I need to go…
Excel Add-In - Option to Switch to design view
Please could you create a new button/feature in the Excel Add in to allow switching to design view. Excel is a great tool for presenting and autosizing column widths and for working on Module layouts and for sorting and filtering relevant columns and rows during a module build. When I do a rebuild a module. I often need to…
Delete from list using selection
Hello Everyone, I have a module dimensionned by two lists, in which I added a boolean "Delete" which is codded by true, and I wanted to create a delete from one of the two lists using selection in the "Action" table, based on that boolean, but when I look for it I don't find it in the droplist of "selected using", which is…
Role list Model builder L1 exam
Hello are you able to explain why I have a situation like that? The parent is there but in the general list the field is not populated and I cant populate. I dont have any list member named All Roles. Thanks
Use ChatGPT's API to produce commentary and send it back into Anaplan
I've love to see some more native API's to connect Anaplan into ChatGPT API to be able to generate commentary. This would be an application similar to CloudWorks or PlanIQ that allows you to configure certain fields to be selected and then a certain style or questions can be asked to ChatGPT to produce the commentary based…
Remembering to keep the F.I.T in your model retrofit
Author: Taryn Townsend is a Certified Master Anaplanner and Senior Manager at Deloitte Consulting. As technologists and planners, our reflex is to look to the future. We strive to keep up-to-date on the newest and most optimized solutions for our clients and users. This can often lead us to opportunities to give our legacy…
IMPRESSIVE! Community Q&A Challenge recap
Earlier this month we launched our inaugural Community Q&A Challenge, where we presented an Anaplan-related question to our Community to answer and share their perspective. We asked, “As an Anaplan model builder, what steps do you take to ensure that changes you make to an existing module don't create unexpected results in…
Replicate A+ for Anaplan Functionality in New UX
Hello, With the New UX, A+ for Anaplan Chrome extension no longer works. I am wondering if there is any current extension developed that can replicate any of the functionality of the former A+ for Anaplan Model Builder Edition Chrome Extension? Specifically, I am wondering if there is the ability for "Improved Colors" that…

Model Builder

Discussion List