Modeling

Manual Entry
Hi all, Is there any possibility for manually entering and using formula in same line item... Knowing its not possible still is there any possibility for the same .... Regards, JEEVAK
Disaggregation
Hi Experts I want to Learn About Disaggregation can You Please Guide From Where I can Learn . Thanks In Advance .
How to link a property/line item on modules with different dimension
Hi, I need to get data from a line item from one module with a different dimension with my target module, I cannot do a lookup because the 2 dimensions are not totally related. See details below ; I need to get the Position value from the source to the target, as you can see in the target module, not all Position list is…
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
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

Modeling

Discussion List