Model Builder
Discussion List
-
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…
-
LIS INDENTION
Hi Team, Is there a way to fix the LIS Indention of those identified as Parents, other than unticking the parent button in the source module, please? Please see screenshot for the sample indention being mentioned. Appreciate your assistance. Thank you, Elaine
-
Build Dynamic YTD/YTG with Non-Native Time
Hey Builders, I'm working on a project which requests a report that requires non-native time due to needing YTD/YTG at the end of each year to track variance on last year's YTD vs current year's YTD. The period to reference in the YTD is to dynamically change as the Current Period is updated within every year, regardless…
-
Level 3 sprint 1 8.4
Hi Everyone, I am trying to validate my data for the "Final sales target" after applying the "Factor". However, looks like my Factor is off. I have confirmed that "previous year actual revenue" and" initial account sales targets" are correct. so not sure where it is off.... Mine: Anaplan: needed formula concept : Thanks…
-
Summing values for a year
Hi, I have a line item which is equal to (Monthly income)/(yearly income). How can I reference the yearly income (or calculate it), I have the monthly income as input. Thanks
-
Production Data - Top level Can be Changed?
I have a scenario as follows: I have a List named "Product L1" which has been marked as production data. While I understand that structural changes can still be made to a list that has been marked as production data, I have noticed that the top level, which cannot be changed if the list has been marked as production data,…
-
Hello,
I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…
-
In blueprint view, show if a line item is used in a filter
In blueprint view, we can see if a line item is referenced by a formula, but not if it's used in a filter. When cleaning models, we can end up deleting items used in filters and breaking filters with no warning.
-
Model building checklist
Author: Nicole Johnson, Senior Anaplan Model Builder at Autodesk. I love a good checklist. Naturally, that passion comes through when I plan and build enhancements for an Anaplan model. I've created a model building checklist that I use to think through and document changes I need to make to a model, and I'm sharing my…
-
Lag Function without Time Demensions
Hi Anaplanners, I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principle is to add the queue from the previous segment and add to the current segment, however the model does not have any time…
-
Calculating line item based on diffferent values in the list
Hi Anaplanners, I have a module dimensioned with 2 lists, loc1 and sample. Sample has two line items Sample 1 and Sample 2. There is a line item called Transportation. I want to add another line item called Transportation Sample1 vs Transportation Sample2 which should be Transportation for Sample 1 - Transportation for…
-
Turn off suggested list/line item names in new modeling experiance
Is there any way to turn off this feature? I often just want add a simple correction to a formula, hit enter and move on. Instead of just the minor edit when I hit enter to close the formula editing it grabs the first suggested line item or list name. For example I just need to add an apostrophe and want be able to just…
-
Ability to indent line items in a module
Besides for the Style on a line, it would be great to have some more control over the indent of various line items, so it can be manually styled to suit various users needs. As some organisations have multiple levels and the default Styles only offer a few limited options.
-
What causes the Change workspace/model to disappear in the Manage model screens of the App?
When I open the app contents screen and select Manage this app button, I click on the Manage models button. In some of the Page rows I can see the drop down for Change worksheet and Change model but not all. I am a WSA and a PB. Both of the Pages belong to the same Workspace and Model. What causes some to display the…
-
13.3.1 Level 1 - Unable to create Margin Summary page
While creating Margin Summary page, I am getting error as "A page with this name already exists" and unable to create the page. Please help, thank you!! However, I am creating this page for the first time. (I am on 90 days Free trial)
-
Create a New Development model from Production to make changes test and sync to Production
Hi All, I want to create a copy of my Production Model from Workspace 1 to Workspace 2 and do some changes request by Biz and test the same. Once confirmed in the copy want to sync back the changes with help of ALM to the production model. Kindly suggest a the best way to do the same.
-
How to merge two models into one?
Hello Team, Would like to check on the following : There is Product standalone report exists in two models. I would like to merge into one model for space optimization. what are the steps to be followed? An leads or advise on how to proceed this? Thanks in advance.
-
Import Challenge
Summary: Practice the importing skills you learned in Level 1 Model Building by completing this challenge. In this activity, you will be modifying to your Level 1 Financial Planning and Analysis model to support a new planning initiative at Unicorn Candy Company. Audience: Completed Level 1 Model Building, Preparing for…
-
Instructions for the Anaplan Academy Learning Center
Follow the instructions below or click the link at right to download these instructions.
-
Level 2 Model Building
Audience: Model Builders Summary: The Level 2 Model Building training program continues on with Unicorn Candy's Connected Planning journey. You will build out two different models, a Data Hub and a Supply Chain Model. This course is supported with over 40 micro-lessons (5-10 minutes in length) on a variety of just-in-time…
Upcoming Events
-
Unlocking the Value of Community with Anaplan Community Bosses
Join us for an exclusive professional development roundtable designed to celebrate, connect, and elevate our premier platform advocates: the Anaplan Community Bosses. The Community Boss program stands at the very heart of our ecosystem, highlighting leaders who dedicate their time to guiding peer model builders and…
-
Designing for Fit, Utility, and Practical Guardrails with AnaplanXL
Join Anaplan experts for a practical introduction to AnaplanXL (AXL), the Excel add-in that connects Excel grids directly to governed Anaplan data. As the first session in our technical series, this event is designed to help: Model Builders understand the fundamental purpose of AXL: what AXL does, the basic guardrails for…