Modeling

Workspace access
Hi, I am unable to login to workspace and can anyone please assist me on the same. Akshay Mail I'd:- akshayanaplan@gmail.com
Best Practise Recommendation
HIya, I am currently pulling various modules out from a large model to provide better user security, I then plan to pull the data from the top level module back into the main business model. Is this something you recommend doing via a monthly import?
Time filter for current FY
Hi, I have an issue related to time filters. I have a module dedicated to time filter which I use for my other modules to show the relevant years/months. My fiscal year is from jun-may, and I want a filter showing only the current FY, that is from jun 2021-may 2022. I hence want to have booleans ticked for those months but…
List Subset
Does Anaplan treat List Subset as a different List? Because when we changed a module dimension from "Product list" to a subset of "Salable Product list", all the filters got removed.
Thank you, Modelers Forum!
Thank you to all our forum members who attended yesterday's session with @Paul and I - we hope you enjoyed it and took away some food for thought. Special thanks also to Stephen Brook from the Product Team for leading the discussion and providing insight on the current and future potential state of Model Management. Watch…
Can you pull line items into a modual from USERS list, fore example First Name, Model Role?
I am trying to set up some dynamic access within a model using read / write access drivers within certain moduales. I plan to do this by setting up a modual to set the access at user level using the user list as one of planning keys, but would be good if could pull in the assigned Roles, first and last name as would mean i…
Conditional Formatting on Parent Level only
Hi, I've been building a module with a list composed of several children and one parent. The children can be associated with positive or negative numbers (rate of change). As a parent, the amount associated to it is the sum of all its children. I'd like to add conditional format ONLY to the parent to check whether the…
New Line Item Text Format Type - SmallText
First, I would like to address that I do not know how the back end of Anaplan is built, so I am unsure as to the possibility or ease of implementation of this idea. The idea is taking a concept from SQL Server. SQL Server has the following data types for storing integer values: bigint, int, smallint, and tinyint. The below…
Level 2 Sprint 3 Safety Stock Exception DB
Hi Team, @Misbah @einas.ibrahim I am Struggling with the data not auto refreshed in Safety stock exception DB. eg. If I select FY21 page selector then it is not auto-refreshing the data and even when I refreshed it manually then also I am seeing FY20 data. I have made show selection in my INV02 module for months as in…
Summing a line item based on time period in another line item
I'm attempting to come up with a total amount per period. However, the module I'm working with is not dimensioned. I have a month formatted line item called 'Period' and am hoping to sum up the 'Amount (LC)' line items that correspond with each Period entered. For instance, I'd like to see a total sum of the individual…
Different Time Scale problem
hi! I want to display the values from a module with a Time Scale of Half Year to a module with a Time Scale of Month. Can i do it? Please help me.
Circular References
Hi All, This is a pretty usual issue that I have seen others encounter as well but wanted to check if you have an elegant way of making it work. I am trying to calculate the available inventory at hand on a particular day using the closing stock on the previous day. So Day 1 would pick closing stock of Day 0 and calculate…
L2 Certification
How many Exams are there in L2 certification. Is it 3 or 4 and how many attempts are allowed per exam as well as per Questions?
Deafult Forecast Errors
i m trying for Default Forecast and also with Round formula..I m confused about the formula. Can somebody help for this ?? I got the Baseline Forecast and Growth Rate%
Question in L1 Modelbuilding exam has same Role name as Department name.
Hi, Please can some one help me on how to do this as Department as well as Role name have same name Executive and same code Ex in them. How will data flow in to the module correctly in this case. Roles list data is RoleParentCode ExecutiveAll RolesEX Senior DirectorAll RolesSD DirectorAll RolesD Senior ManagerAll…
Anaplan - tracking upload status
Hello, I need to create a module in Anaplan to track the status of data loading. 1. Users are loading data using Excel Add-In. 2. Then, they need to check a checkbox (Boolean) that the data has been loaded Is there any way to know when the user has loaded the data/checked the checkbox? This functionality is need to inform…
COLLECT() function issue
Hi Community, Please see attachment for the details of the issue. Any feedback is appreciated Regards,
Level 2 Sprint 3.3.5.5 Final Shipping Method and 3.4.3 Country Made in
No matter how hard I try I am not able to the right formula for Final Shipping Method, so far my formula is "IF NOT Override Shipping Method OR ISBLANK(Override Method) THEN Shipping Method... Another query is do I have to give a formula for Country Made In line item...if so can anyone give me a hint?! Thank you in Advance…
3.3.5.3
I have configured the hierarchies properly but the parent Hierarchy is not visible in my INV01 Inventory Ordering module
Automated email notifications
Hi, we have requirement in our anaplan model that we need to send an notifications before due date to multiple users which belongs to different business segments .
2.3.9 Activity: Historic Volumes to Baseline Forecast
Hello, When comparing my DEM03 Demand Forecast numbers to the Anaplan example, my Default Forecast seems off. The DAT03 Historic Volumes appear to match. Anaplan example: what I see on my DEM03 module: The Default Forecast matches the Baseline Forecast for FY20 and the Growth Rate % doesn't apply until Week1 FY21.…
DEM03 Demand Forecast
Hi, My DEM03 Demand Forecast is not matching with the Check your work data. When i select All accounts for a product SKU, my data is different from the training material. I am not sure how i arrive at 2024 in Default Forecast & 2004 in Final Forecast. Please help me sort this out. I have attached the screenshots for…
L1M1 13.9.3 Activity: Add Primary Grid to Volume Entry Page
Hi, In this section Allow editing tab is greyed out for me. Am I missing something here or I need additional permissions to have this. Also this section is not visible to me. Please can someone help me with this. Thanks, Balarama Krishna
Level 2, 3.3.5.3
Under INV module the JAN 20 beginning inv is matching Week 4 Beginning INV. Shouldn't the Beginning inv for a month be the same as Week 1? I keyed in some forecast values in DEM03* module. WIll this affect my results in SPrint 3? Hope someone can answer my queries THanks THomas
Activity 6 model building exam
The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = 'EMP02 Employee Expenses'. Salary[Lookup: 'SYS08 Employee Details'. Region, Lookup:'SYS08 Employee Details'. Role] The name 'SYS08 Employee Details'. Region used in the LOOKUP clause is not recognized as a line item in the model this error i m…
Activity: Add Formulas to Margin Calculation Module
why my unit price growth % didn't change even adding 5% in price growth rate plz help
Delete from List using Selection: Do not see my delete/boolean line item in the picklist
I'm trying to create a delete action utilizing the action option "Delete from List using Selection." However from the setup box, in the picklist "Select using", I do not see my boolean line item. Are there parameters published somewhere as to what would prevent a line item being visible in the picklist? Here are my module…
Level 1 Model Building Exam
Hi, I downloaded the model to be used for the exam. The EMP03 Employee Drivers has nothing to put the data from; i.e. 0% bonus, 0 allowances. Does that sound right? As I could not go back to the previous page to see if I missed anything. Appreciate your help!
Can I select two different child list with same parent in single module?
Hi All, I have two different list with same parent. I want that two lists in one module but currently I am not able to select because it clashes with each other. For e.g: 1) I have one list called Employee & Parent of that list is Group. 2) And Have another list called Branch & also parent of that list same i.e Group. I…
Lookup not working - dimension used for lookup doesn't match any dimension of the source
HI I have 2 line items in the same module which are both in list format using the same subset list. I would like 1 of the line items to be completed based on the entry made in the other. I have created a mapping module using the same subset list as for the module and the line item (see attached screen shots). But when I…

Modeling

Discussion List