Modeling

Need help with better approach
Hi, I am facing issue with the below senario. If someone can help me out with what is the best possible approach I have hierarchy with lists from L1 to L6 levels and a flat list D with list items from D1 to D5 Current setup: There are several hundreds of modules with combination of flat list D with one of the hierarchy…
Boolean Filter for Salary Rank function
Hi, I want to only show the top 10 earners in each department (List hierachy E1 Department is top and E2 Employee below). I have created a RANK that will give organize numbers lowest to highest based on each department, But the numbers do not "start over" for each department. So there is only one department, that has RANK…
dependent dropdown multiple condition
Hi, Is there a way to make a line item( dropdown list format) to have multiple conditions? example : I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? GL account is dependent on both the cost center selected and the account type…
Conditional Formatting on Line Items based on values from other modules with same dimensions
Hi, It would be great if it was possible to format line items based on line items from other modules with the same dimension without having to bring in that line item into the same module. Thanks, Usman
TEXTLIST- multiple dimensions
Hi Could any Anaplan pros please assist with a TEXTLIST aggregation? I am not sure how I would do this over multiple dimensions. It is basically concatenating all the applicable pages numbers into one text based line item for each employee / report version / user. I have attached the blueprint. The line item I am trying to…
Formula for calculating Time Coverage
Hi everyone! I'm having trouble in resolving these request in Anaplan. Basically I've got 2 line items in a module with Time Scale Weeks: Expected Sales Quantity = Qty of Product that is expected to sell in every week Final Stock Quantity = Qty of Product in Stock in every week The request is to calculate for each week of…
Level 1 Model Building- combining modules through formula
Hello I am building a model in Level 1. I need to know how can I fixt the problem when the Data type mismatch: format other than LIST or DATE being reference as a relation. I am trying to update the update the formula on EMP02 to refer it to EMP03 Line items. Thanks!
Completed lessons
I have completed lessons and it's showing that I only completed up to lesson 3....how do I confirm that I have completed lessons? without having to go back to every single one
L@ Model Building UX pg's
Hi, Not Understanding how to choose which Context Selectors levels are needed for certain List. It is on the Exam and I have watch the recommended videos and just need more explanation. Thank you
Breakback with rounded integer numbers
Hi, Is it possible to set a Breakback function with auto-rounding? We're working on a project where exploiting breakback is useful. Product units should be integer, never fractional, but we can't find how to auto round numbers derived from breakback function without setting a process. Is there a way to let user insert a…
Level 3 Commission Forecast
I'm currently struggling with the calculation of the monthly commissions FC. Issue: Quarterly commission Forecast: Unable to get quarter values by sales rep. How to bring down Annual sales target into Quarterly? Kindly help me on this.
Sprint 3 - 3.5.4.2 Create Distribution Center Capacity Module
Hi, In activity 3.5.4.2 Create Distribution Center Capacity Module formula I gave for Percentage Full is Total Beginning Inventory / Distribution center capacity. But result is greater than 100%. I'm attaching the screenshot. Please help. Thank you very much
5 Steps to Connected Planning Health Check
This article describes how to use health check audit on Anaplan models to identify gaps, deal with data quality, manage user experience, connecting models and user adoption. Based on experience in maintaining and deploying new models across FP&A and operational business functions as the Enterprise Connected Planning…
Event recording available! Modeling tips and tricks
Last month we hosted a challenge inviting Community members to share their thoughts on modeling best practices — over 30 tips were shared! Yesterday, we held an event highlighting that guidance every model builder should know. Jason Blinn (@jasonblinn), Principal Solution Architect and Employee Community Boss at Anaplan,…
How can I permanently HOLD the TOTAL figure and let the Breakback happen?
Hi Community, Need your help if you have a smart solution to HOLD / LOCK the Top/Total of certain dimensions of a line item which is Breakback enabled! Example screens is given below: So, all I want is to HOLD the yellow circle i.e. 1849 amount and let the below gets change which is 4 levels hierarchy.. We know the HOLD…
Multiple Models | One Page
We have multiple models, Model A is where user inputs the data, Model B is where the submitted data would eventually sit. Model B receives data from Model A via an action. So once input is done as a user can i press a button (from model B) to technically import data from Model A to Model B. Can we have the action in one…
Level 2 Model Building Conclusion - DEM04 Demand Export Demand values
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? My DEM04 blueprintview: Baseline Forecast: Thanks in advance!
Anaplan Level 2 Conclusion - Create Demand Export Module and Create a Saved View
Can someone help me why I am getting different demand number pulled up? Instruction: My Anaplan Blueprint Mode: My data Check your Work:
3.4.3 Activity: Create Country Summary Module formula is wrong ?
hello I have put the formula for Safety Stock Flag Count but in the exam it says wrong when i pasted it . i dont why couple of times it got rejected ? any advice will be helpful
Filtering a subset
Anaplanners, Is there a way i can filter a subset ? So, we have Projects module, where each project can be either active, inactive or done. This is a list formatted line item. However, the option to select done should be based on another line item in the module, actuals uploaded : Yes/No ? If the boolean is true only the…
Organizing templates for data imports
Author: Vinay Varadaraj Mirajkar is a Certified Master Anaplanner and Senior Solution Architect at Anaplan. I am sure many of us have seen the below message many times in our experience, and at times it may be very time consuming to retrieve the file which was used to create the import action. And there are also chances…
Alternatives to Rank in Polaris engine
Hi Community members, I am looking for some alternatives to assign sequential ordering in Polaris model as the default "Rank" function is unavailable there. Thank you!
3.2.11.1 Create Planning Period Filters
Confused on which Line Item I'm building a formula for, I'm assuming both. Also this is the formula I used to so that the weeks in that month are selected as well when you select the month are as follows. Please advise. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter), Kind of confused why would not want…
Source Model and moving model between workspaces
Hi All, In one of my workspaces (Workspace1), I have two models HubModel1 and HubModel2 where some of the lists in HubModel2 are created based off saved views in HubModel1 (meaning the imports in HubModel2 are pointing to HubModel1. Say, I want to move the models to a different workspace (Workspace2). Looking for options.…
Show whether a line item is used in an action
I'd like ability to see, in blueprint mode for a module, whether a line item is used in an action. This, along with an existing Idea requesting to see if a line item is used as a filter for a Saved View, would significantly speed up model clean-up time
Easily Get Current Date Using CloudWorks
Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using python for getting today's date. But this approach has some cons: * You must learn to code or involve someone who can do it.…
How to convert text to date
Hi , I have a text formatted line item which is a date .I want to convert it to Date format . I tried to break it into three Year ,Month and day using Value(RIGHT(Line item,4)) Value(Mid(Line item,4,2)) Value(LEFT(line Item,2)) It works for 12/10/2012 but what about 2/3/2012 ?? Note -- Can't change source text to date…
Access Driver Behavior - Workspace Admin vs Regular User
I have a module X, that has two Line item Line item A which is Boolean Formatted and Line Item B which is Number formatted but has Write Access Driver set to Line item A. I have a process that Import data from Module Y to Module X. I am noticing a unique behavior depending on who is running the process on UX screen. If…
Level 3 4.6.5 Sale Planning Model: DAT02 module
For the "4.6.5 Sale Planning Model: DAT02 module" step under Level 3, the data of Previous year is in a module having account flat and product flat. however, it needs to be imported in DAT02 PY Revenue to CY module, which will have A2 Account>Product# list which is a numbered list. Any clue on how to do move data between…
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?

Modeling

Discussion List