-
Model Optimization
Hi Experts, I am trying to optimize the model size. Can you please suggest me the main ways to reduce the size. Thanks and regards, Mahesh
-
WARNING: App availability depends on referenced model existing
Yesterday, I refreshed our Dev and Test models from Prod to start a new development cycle. The Dev and Test models were actually brand new (only about a week old -- no in-model development, only App development) and didn't think I had any actual need to keep the previous versions since I was just looking to refresh data. I…
-
3.3.7.2 Add DCA to INV01 Inventory Ordering - first step
Hi there, In Level 2, Sprint 3, activity 3.3.7.2 Add DCA to INV01 Inventory Ordering we're asked to add Read and Write Access Drivers to INV01 - but in the previous activity we are only asked to to create three Write? line items: So should my first step after creating AD02 be to create three Read Only line items by putting…
-
Accuracy of calculations
Hello everyone 🙂 , we have two model builders who applied the same formula but with a different order, but since it's multiplication and division, the order doesn't matter. Unfortunately, I come across two different numbers. How accurate is Anaplan in calculations? Here an article i found Precision differences and large…
-
Create Shipping Export Module and Create a Saved View
Hello Community!! I am stuck at the above activity, can anybody please guide me what the mistake is?
-
Create Shipping Export Module and Create a Saved View
Hi, I need help regarding this activity. 1) When I pivoted the view during Module creation - INV05 , I have an error regarding the G3 'location - saying " No Items" 2) The formula for Code is 'SYS06 Location Details'. Code' , but my SYS06 module seems to be unuploded Can anybody verify and let me know the exact mistakes.…
-
Change default message process completion message to an error message/ LOCK button
Anaplanners, I have a process which stores the end user's inputs in the system. Currently users press the button without completing ALL their inputs thereby storing incomplete data. 1) I wanted to figure a way to lock the button when they have not completed their inputs AND/OR 2) At least throw an error message when they…
-
NPV Calculations
is there a way to calculation the NPV on a rolling basis? So basically I would want the NPV to be calculated on a quarterly basis for the current quarter and forecasted quarters. per the screenshot below, for Q4 2019, i want the NPV from the current quarter to Q2 21.
-
Version Formula in Module
Hi, Is there a step by step guide on how to use the Add version formulas to line item subsets in module blueprint ? I don't see any line item in the left box. Thanks, Tom
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi - I'm sorry, I'm really sure sure what the section is asking me to do?
-
Error Message
Hi, I have an error message that keeps on popping up when I'm trying to create a formula. I'm trying to multiply the two line items together. Please advice. Image is attached. Thank you
-
Boolean check box
Hi team , Can anybody let me know why can't my Boolean item have a check box ? Attaching the snapshot Guidance please!
-
Time Spread (Reverse Count from point in time)
Hi, I have a problem I am finding difficult to solve. Hopefully, someone in the community has encountered this before and can provide some clever solutions to this. First of all, the modules I am showing here are just to explain the problem I am trying to solve. The actual modules are on a very large data set so I need to…
-
Boolean format not showing check boxes
Hi All, As the title explains the issue, I am unable to see the check boxes in my grid view for a boolean formatted line item, can someone please help and identify what am I missing ? Please see the screen shots Any help will be appreciated. Thanks JH
-
Boolean check box
Anybody available to clear my query regarding why my Boolean Line Item does not have the required checkbox?
-
LVL 3: 4.6.3 Data Hub Model: SYS14 module
Dear Team, I got stuck in one place while building SYS 14 module, i don't have my old Data Hub model bcz of which i downloaded from training. 1) If it was DH model - then Data? has a simple formula to see whether SKU Filter system module has data and if yes then check if any Product is their 2) If DH is downloaded from…
-
L2 2.3.10 Wrong Value
Hi - I am at the L2 training segment 2.3.10. While my formulas are all correct (I think), I am somehow still seeing an unexpected value as an answer. Screenshots below on my formulas. I'm not really sure what's wrong here. Any help?
-
Create Demand Export Module and Create a Saved View - DEM04
Let me know, if it is right! Is the time scale right?
-
Formula
Hello, Quick question: How can I calculate the Volume between FY17 and F21 in the other module? For example, the difference between two years. Note: Just Volume is a line item. Please see the attached. Thanks, Mark
-
Behaviour of SEQUENTIAL parameter in RANK function
Hi All, We have a requirement to sequence items in a export and we've been using the RANK function to achieve that in a similar way that is listed in several posts in the community…
-
How to change date format DD MMM YYYY
Hi, I have a date formatted line item (example: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?
-
model performance
Hey People, Which option is better while applying a formula: 1 list (4 items) & 1 Line-item or 4 Line items? In terms of time-saving/performance.
-
LEVEL 1 EXAM MODEL BUILDER ACTIVITY 5
Hello everybody. i´ve been stuck in this activity since yesterday, a create a Role list, With a top level of all roles, then i import the new data in the SY08 EMPLOYEE DETAILS with the extra role line and i don´t get any issue with the data. The thing is that when i try to change my formula for the BONUS, CAR COSTS, PHONE…
-
Profile Function for Revenue Recognition
Hi everyone, My company uses Anaplan for all budgeting and forecasting and we recently discovered an issues as this is only our second year. We have 2 metrics "Bookings" which are sales associated with contracted revenue, and "Installs" which are when the booking begins being recognized as revenue (as the product is…
-
POST formula in SPRINT 3
Hello, Can someone help me to understand why for "Confirm Purchase Order Receipt" line Item, "POST(IF NOT Submit Purchase Order Request? THEN 0 ELSE Final Shipment Amount, Final Shipping Time Weeks) " is not a correct answer for the formula to use? Regards
-
Setting up dynamic list of values
Hi We have a requirment as below. We are setting up a General List to track the consumption of hardwares at different sites in the world. There are two columns in this general list. One is Combination which can have three values (Region/Country/Site). The next column is Combination_Name. The idea is based on the value…
-
Restriction line item based on another line item
HI all, I have a module Fnem00, here we have to Select the Account and program. Based on that we have provided the DCA to enter the values in Fnem01. Now if I delete the Account and program in Fnem00 the Values in Fnem01 is Values are not getting erased. How can i fix this?
-
How to keep the input value after switchover
Hi All, i have a question about switchover Currently the forecast period is started from Jan 23 and i have input a $10 in this period however after i have switchover to Feb 23, the input value will gone. how can i resolve this issue? thanks Before switchover After switchover Blueprint
-
Anaplan natural rollup is not equal to sum of values from its children
Hi, fellow Anaplaners I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values). I have 2 line items here: 1. Commercial input is number formatted; no formula, is for planners to manual input forecast…
-
UX dashboard filter not defaulting to current user
In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled. I then used FINDITEM to link the Users list to the subset. The linking worked successfully. However I ran into an issue when I…