Modeling

model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
Level2 sprint 3
My figures in Inv 01 ordering is not matching with one given in training module I have attached both figures and formulas used please guide whta I am doing wrong
Level 2 Sprint 3 Module INV01 : Formula for Shipping Method
HI I am using the above formula but getting an error. I understand I have to look into SYS07 Module(Distribution Center Details) for Default Shipping Line item looking up SYS08 SKU Details'.Code and SYS08 SKU Details'.Supplied By ..pls guide
INV01 - Beginning Inventory off by 2
Hi all, I've been wracking my brain on INV01 and just when i think i have it, I notice that my numbers starting in Week 3 for beginning Inventory are off by 2. See screen shot attached from my module - in Week 3 FY 20 i'm showing 8,904 and in the example 3.3.5.3 Check Your Work it's showing 8,902. I'm also seeing my…
Custom Timescale Filter instead of Time Period Drop Down
Current Timescale Selection * Current UX: Selecting a year (e.g. FY20) in the page filter will will sync any worksheets to January - December. There's no native way to show something custom like the trailing 24 months. * Modules/Classic dashboards: manually show/hide dates, or apply a filter which you'll have to do for…
Monthvalue in Anapedia
Hi I'm confused by the guidance in Anapedia on Monthvalue and Yearvalue functions whilst doing the Level 2 Model building. Having been advised to use these as part of the training to result in a boolean (which works) I was baffled by the Anapedia guidance that states it must result in a number. Is it a platform change…
Default Export File Type to CSV
This one is simple. Anaplan's recommended export file type is CSV, yet the export dialog defaults to Excel / XLS. Yesterday we had an integration mysteriously run for 7 hours, later realizing it was because the export file type wasn't changed to CSV. Please allow model admin to set the default export file type to CSV. This…
How to post a Month from current year to previous year
Hi, I have a scenario where I have to post a line item which is month formatted from current year and post it in previous year . Module is by Year dimension . for example - I select FY 20 as dimension Line item -entry is jan 19 , Result - Want to post jan 19 in Jan 19 (though I input in FY 20 as dimension) Post /lag works…
show summary with Selective access enabled
Hi All, Can I show Summary when selective access is enabled at children level? there are lists in a hierarchy say A(PARENT) B(Children of A) C(Children of B) Selective access is enables at C but want to show the summary at B(at parent of C) , attached the screenshot for reference Please suggest if this approach is not…
Hierarchy Management
There are peculiar scenarios like mergers or acquisitions when the Master Data of the company changes. Name and/or Code gets changed in the source system, and we want to update the hierarchy with these new details in Anaplan without creating new entries —which will increase the model size exponentially. We also want to…
Mapping issue - only populate Manager that is from that Department
Hi, I'm wondering how to only get the name of a person who is part of a department in a module that has department as one if the dimensions. SYSTEM Module for Users: Dimensions: Users Line Item: Departments (List-format with department which is populated based on a formula using the lookup function). Module Mapping:…
OEG Best Practice: The importance of building and maintaining a clean model
During a typical implementation, it’s common to have multiple model builders build use cases and accomplish tasks simultaneously. During this critical time in the project, it’s important to plan for a key component that may be overlooked—keeping the model clean and tidy. Keeping a model clean has multiple benefits,…
Sort list
Hi everyone, I have a list of selective access for users. Due to the dynamic maintenance of that list from various sources, a sorting of the list items is missing. For readability, I want the list items to be sorted in the modules and on dashboards. I use a line item with formula CODE (ITEM ()), on which I set sorting. Due…
Role assignment level2 sprint 2
HI Not sure what I am doing wrong in Activity 2.4.11 create role and test as end user. Did following steps 1.Create new role : Product Family Manager, 2.Assign Role > Modules like DEM01 Volume Growth - Write , DEM02 Volume Growth weeks - Read, DEM03 Demand Forecast - Read SYS 00 Time settings-Read SYS02 Time settings-Read…
INV01 - Final Shipping Time Weeks and Final Shipping Amount
Hi all, In 3.3.5.1 while creating the INV01 Inventory Ordering module, we are asked to create 13 line items, none of which are "Final Shipping Time Weeks" or "Final Shipping Amount". Maybe i missed something, but where is the instrux to create these two line items? Here is the screen shot from the training: I moved ahead…
Sort a flat list with a composite hierarchy
For those of you who have touched HC or resources planning might be able to relate to the example below. Composite hierarchy is very useful, however, in some cases it is significantly easier for end users to managing data with a flat list. In those scenarios, sorting using a hierarchy can be helpful. Example: When…
Alphabetically ordered list
Hello all, I have a list of employees without alphabetical order in my model. On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when displaying for example. Would it be possible to help me ? Regards,
New UX: Send Notification to Anaplan Roles/AD Groups
With the introduction of the new Notificaiton capability in the New UX (which works great when tested), it would be great to expand it to include 'Anaplan Roles' instead of Specific People in the email selection. Another far fetched expansion would be to integrate this with AD groups etc. to send notifications across the…
Formula help
Hi, I need some help with a formula/modelling. I have a module dimensioned by Products and returns (row) and measurement periods (columns) (1 yr, 3 yrs etc). My line items are actual performance and benchmark performance (see screenshot below). Products may track performance against more than one metric (e.g. Returns A and…
SUM of a Line Item
Hi all, I am trying to calculate the total of a Line Item to use in a formula (for example: totals are listed at top or bottom but I need to use this total amount in a formula). I have tried to use a 'SUM' formula for the line item but have not been able to get the formula to correctly work. Is there a simplified way to do…
Can Anaplan APP source pages from workspaces across data centers?
Hi all, I want to understand, can an Anaplan APP source pages from workspaces across data centers?
Model couldnot be restored
Hi team, I have problem about restore data in production model, first i sync form dev to prod but after sync i want to restored data before i sync and i have pop up like this How to fix it? regards, Panji
Display Name selection from the drop down - only filtering text and list formatted properties
Is it possible to provide a Display Name selection in the form of a drop-down for a Numbered list in the configure tab of a list? This addition would actually complete the configure tab in totality.
Input Module as Quarters to apply to Months in Calculation Modules
Looking for a way to have a data input module of 1Q, 2Q, 3Q, 4Q as one axis and years as the second axis (2020-2025). This grid would be the input module for end-users within Anaplan. The calculation module uses a monthly time scale. I want the formula to retrieve the value from the input module for the quarter/year which…
HyperModels Group
Hi All We have created a group for all things HyperModels https://community.anaplan.com/t5/HyperModels/gh-p/HyperModels This is an open forum for you to ask questions, post experiences, migration paths, best practices, etc. David
Cross-workspace data link
Hi, need some explanation as what is "cross-workspace data link" which is eligible at enterprise level edition ? Tried a few search, but nothing relevant showed up. * Could you please enlight me and what use cases you believe this has the most value for you ?
Calculation Month Mapping MODULE change???
Hello. Dear Anaplan Community. Anybody who can help with the Calculation Month Mapping? I got a task to change the calendar matrix and do some changes. In particular month, I have to delete the final run and move it to somewhere else. Or change the final run to 3rd run. If anybody is familiar with this module setting,…
Drill To Transaction Details on Dashboards
Allowing end-users to have visibility into source transactional data is very important for many Anaplan customers. There is always the ability to Drill-Down into source data, but at times, this may not be intuitive or may take several drill-downs to get back to the raw data. There is another option that can be easily…
Adding new people to a numbered list with code auto-generated?
Hi, My client is wondering if they can add new employees to the Employee numbered list and having Anaplan create a unique code for them, so that the user does not have to do this part themselves. The code should be relevant to the process (i.e. budget, forecast, ad hoc) so might have name FC123 or BU123 etc. What is the…
Matrix Grid Help
Hi, I currently have 2 entity lists (identical), and a module which maps the entity 1 list to entity 2 list. What I'm trying to do is to create a matrix with entity 1 as rows, and entity 2 in the columns (i.e. an entity matrix). 1. How do I create a formula which states if Entity in row = Entity in the column, select…

Modeling

Discussion List