-
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
-
OEG Best Practice: Implementation best practices: Leveraging personas
If you are transitioning from Classic to the UX, you may have read this article about our recommended methodology: U.S.E.R. (Understand, Sketch, Execute, and Repeat). One of the key concepts during the Understand phase is to really get to know your users. For this, we recommend a classic UX tool: Personas. Personas What…
-
Formula Help
Hi, Need help creating a formula that will look at LI for a rolling 5 day forecast and return back the max number of those 5 days. I set up a systems module that looks at the forecast for 5 days, and then tried to use it in the formula below.
-
New — Get inspired with UX Designer Quick Tips
Introducing the latest way to learn and develop Anaplan skills — UX Designer Quick Tips! Hear from a variety of Anaplanners as they share actionable tips designed to optimize the UX experience. Visit the UX Designer hub to view a new featured tip each week. The complete list of Quick Tips is also available to view at any…
-
Fastest way to replicate changes in SYS Property modules
Hi Everyone, I need your help to replicate same changes from one SYS module to some of the SYS modules. Let's say I add some line items in one SYS module and there are 30+ similar SYS modules. Is there a quick way to replicate these changes in other modules so that name, format, formula and summary settings can be updated…
-
Detect CRLF character in a text line item
I have to replace CRLF (carriage return / line feed) characteres form a text line item. How can I use the FIND function or more better the SUBSTITUE function to replace such a CRLF char. Result = SUBSTITUE(line item to replace, CRLF character, " ")