Modeling

Evolve your Anaplan ecosystem with enterprise governance
Center of Excellence Model Governance Workspace Architecture Data Hubs Data Integration Build & Manage Security In this article, you'll find resources to support evolving your Anaplan ecosystem with enterprise governance. This broad topic was covered in depth during Anaplan Live! 2022 — including focused discussion on…
12 .4 .6 Level 1 activity Hierarchy level issue in Line items
After properly following and completing activity 12.4.6 Departments are coming together,and employees are coming together.But in screenshot of training employees are visible according to their departments.I have attached the document with message.Let me know where I am going to complete the activity
Ability to mask or sanitize all of the Production Data within a model
I would like to be able to easily mask all Production Data within a model. Currently, this involves a lot of manual effort. For example, replacing all names with fake names, and all numbers with fake numbers. Being able to do this is useful for a couple of different purposes: * If I need to have Anaplan Support take a copy…
Simplifying a formula with multiple checks for User Input
Hi, I have a grid in which there are multiple line items (approx. 25). These line items are user inputs and when the user enters these either manually or through file upload, he sees a validation message that checks his input related to multiple conditions (e.g. Invalid Date, Mandatory Field Blank, Duplicate Entry etc.) .…
DYK - WEEK 9
WEEK 9: Start of Section Did You Know what “Start of Section” in Anaplan is used for? Let us understand it here. For example, there is a P&L module for all the countries, as you can see in the video. Now let’s say the requirement is to show the P&L values at an aggregated level (for all Countries) in the same module. Here…
Architecture and Modeling Mistakes: Deep Dive
In today’s post, we’re doing a deep dive on the Anaplan Live! session: Top 10 Anaplan Implementation Mistakes and How to Avoid Them. Focusing on the Architecture and Modeling section, we’ll review a few best practices discussed and illustrate how we can leverage them in our daily model-building activities. Why You Need a…
Calculate Cashflow on the basis of IRR set by the user
In Excel we have Goal Seek function to set Target value of a calculated cell and based on that target value, excel performs reverse calculations and gives source value needed to achieve the target. Now, in Anaplan I want to achieve this similar functionality. IRR is an Anaplan function resulting in value calculated from…
Is there a way to turn off the calculations done on Summary Methods in Snapshots?
Is there a way to turn off the calculations done on Summary Methods in Snapshots? Currently I am having an issue with the rollups on the snapshots because of the Summary Methods on the Snapshot module. For example: a line on a module has summary method of 'Formula' but the Snapshot has a method of 'SUM' so this is causing…
Formula and Ability to Edit
Hello, is it possible to have a formula that is formulated for a certain version or from an IF, but then allows you to hard code if that is not true? For example if we were to say "IF ISACTUALVERSION() THEN 0 ELSE {Ability to hardcode here}" Thanks in advance
Create product Replenishment Page
Hi, I am trying to create UX page for this. Time does not show as expected and also Shipping Method line do not show anything although my INV01 module looks good. Please guide me. Screenshot of my INV01: Regards, Mark
7.2.2 formula error
When I try to enter the formula for Product Family I am getting this error. If I change the format for Product Family to "P2 Products" the formula will work, but I am aware that activity 6 states to label the format for product family as "P1 product family". I do not know what I am doing wrong.
3.4.4 Activity: Create Stock Exceptions Review UX Page
As per instructions, UX page for stock exception review, time period are monthly , half yearly and yearly. Where my time drop down shows the weeks too. Is it not managed well till now? Regards
formula revision for QTR last year
Hi Community, I would like to ask advice on formula revision of my clients report. Below is the target module. The column of last year is where we are encountering a problem. Requirement: it is supposed to pick up the value from the source module but the total QTR of last year. Target module: OUT007 In the target module if…
Level 1 Exam Question 5
I did all the formulas correct for Bonus, Car, Medical but when it ask me total for Sales department for December 2020 and I entered XXXXXX for phone cost. It gives me incorrect answer. No sure were I went wrong. How do I trace back?
Level 1 Exam Activity 5
For last hour I am trying to figure out the formula and what I am doing wrong on Bonus formula. I am not sure if the formula is correct and 'Role' is not rolling up. Any help will be great. Thank you in advance.
3.3.12 Activity: Create Product Replenishment UX Page
A quick suggestion please , we have created a INV01 Inventory Ordering module and chart for UX as well but my quick feeling is none of them matches with view in terms of line items and sequencing of line items. We can simply ignore it ?
level 1 model building lesson 7.2.1
Any help here would be appreciated. I tried importing the product.csv into the product details module and it did not come out right. It looks like I'm missing something
Anaplan Level 1 Model Builder question 1
Hello, First question on Anaplan level 1 exam is 'what are the steps for building a model'. DISCO is not an option, some of the options were as follows: 1. Create User permissions and roles 2. Create Module 3. Create System dimension for Modules 4. Import Data 5. I do not remember 5th option. I revised the whole lesson 1…
10.2.6
seen this error , during putting formula in bonus , car costs, phone costs, medical costs
L1MB 9.2.6
GETING THIS ERROR WHEN FORMULATING THE UNIT COST GROWTH%.
6.8.6 Activity
Can you please help I got stuck in an activity (Level1 6.8.6) Please see the screenshots Expected Mine
Lists and Roll-ups in New Modeling Experience
I love the new Model Experience, but I miss the classic model experience in terms of viewing Lists and Modules on the same page. It would be great if we could add the Lists and Roll-ups functionality in the new Modeling Experience. As a model builder, we could see the Lists and Modules on the page together as we had in the…
Level 2 - Sprint 1 - 1.3.6.4 - Why Is Default Shipping on the "Location Flat" Tab for Filtering?
Hi everyone, thank you for any help! I am on Level 2 - Sprint 1 - 1.3.6.4 - Where I need to filter to only show locations with a Distribution Centers. I was able to complete this successfully, but I am confused as to why the "Distribution Center?" subset is available on the "Location Flat" tab of the filtering window…
L2 Sprint 3 INV01 Shipping Time Weeks
Hi, It shows just zero in Shipping Time Weeks line of my INV01 Modules although the formula is correct. On the other hand, TRA01 Shipping Metrics by Week do not have data yet. I don't know where I am doing wrong. Here is my screenshot with the formula for Shipping Time Weeks line : Expexted: All helping efforts are…
INV01 - Shipping Time Weeks
Hi, I am trying to add a formula for Shipping Time weeks in the INV01. I have tried these formulas but they don't work: 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'LOOKUP: 'SYS08 SKU…
8.5.3 Activity: Import Data into Volume Inputs Module
Hi - I am trying to map an import into a model and my results are calculated as zero. I attached my mapping and the results. Can anyone help me what is the issue with the mapping please? Thank you so much!
Anaplan Model Builder Level 1 7.2.2 Help
Hello, I imported data into the SYS06 Product Detail module and it went through smoothly while also aligning with the picture show in the "Check Work" section of the Lesson Plan. I tried to enter the formulas for the same module and I keep receiving an error. The error suggest that I have no hierarchy attached to the lists…
Level2 - 2.4.4.2 Check Your Work
Hi, I am working on 2.4.4.2 Check Your Work , i want the result like below But i am getting Override forecast value as zero please help Regards, Srini
Multiple data write actions per button press
Hi all, I have a button that updates a boolean line item in order to change the status of something. Is there a way to have it so when I press the button, it sets multiple line items boolean's? Ideally I'd like it to update multiple line items from one button press. Thanks, Sam
Can you take a Copy of a model at a point in time without having to restore it?
Hey team, I want to take a copy of a model at a point in time and see the data in it without restoring the current version model to that point. Is this possible and if so how do I do it? Regards Padraig

Modeling

Discussion List