Modeling

DYK S2 - WEEK 6 (Dimension Ordering)
Dimension Ordering. Learn how to order dimensions in the modules, watch this video to know more https://www.youtube.com/watch?v=Zz7zz_g_7gU Thanks, Misbah Miz Logix
3.4.4 Activity: Create Stock Exceptions Review UX Page
Is this right?
Multiple information columns prior to Time Periods columns
Hi, Asking for some general advice on how best to manage this. We have several schedules in Excel which show mutliple information columns prior to the Time Period Columns. Eg. Project Name | Project Type | Product | Start Date | End Date | Jan 22 | Feb 22 | Mar 22 | Apr 22| etc..... There are several tables like this that…
Filer Q and Year, to Calculate line items
Hi All, My issue is that I'm using a graph to show the P&L, but my 3-year trendline is spiking, when set to Q and Years. So I have P&L line items calculations and they are connected to different module views, so I created time filters modules to calculate the Periodic, Yearly, and Quarters. So, if I change in the line…
Anaplan count function
Hello Anaplan Community, I am stuck in counting the items in a line item. I have a line item called 'Status' and it is List formatted. Now I want to count the number of Particular items in the line items. Like 'Completed' occurs four times, so it should count completed as 4.Like wise 'In Progress' occurred four times, so…
Stress Testing on Anaplan ICAAP/ICARA
Hey Everyone, I'm just wondering if anyone has tried to use Anaplan for stress testing? How did you go about it and was it advantageous to use Anaplan over something more flexible like excel? If it was advantageous how so? Thank you, Padraig
Data Hub to Spoke Model Performance Question
We are building a budgeting and reporting model based on transactions incorporating our chart of accounts. We have built a Data Hub to house the lowest level transactions. Currently we budget using 6 categories with several layers of hierarchy totaling a count of 6,475 items. Summarizing monthly transactions we are looking…
Level 2 Sprint 1 1.3.10.4
Can anyone explain why I'm not getting the view as displayed in the instruction? There is no check in my view? Thanks,
How to add boolean as true above intersection of same month
Hi Everyone, I have a module with 2 dimension & 1 Line item. Dimension 1 - Anaplan Month time (In columns) Dimension 2 - Time List ( In Rows : Similar to Anaplan time month) Line item name - Boolean up true. In Time List , I have 5 months: Jan 22 Feb 22 Mar 22 Apr 22 May 22 Now , please see the attached Image. The way you…
Time Range replaced by Model Time in Pivot View
Hello Everyone, We have applied a time range of "Current Year" to a module. However when I open pivot view of the same module, we do not see this, instead we see the full model timescale applied. (Consequently, a filter applied to a NUX grid based off this module is now asking for a time selection. The filter line item has…
3.3.5.2 Inventory Ordering Module Formulas - Shipping Method
Hi everyone, I appreciate any help that can be provided, I was very stuck on the formula for Shipping Method. I was trying the formula below and getting error "Format of mapping used for lookup doesn't match any dimension of the source". I believe I am using the correct module line items, but am struggling to understand…
Model builder keeps clearing cookies in Chrome
Is anyone else experiencing issues with Google Chrome constantly reverting to the classic model building UX whenever you open a new Anaplan tab? I don't have any specific cookies settings for Anaplan in my Chrome settings, and I've noticed other model builders experiencing the same issue while on screenshares. Seems that…
Saved view different in Dev & Deployed - same revision tag
Hello model builders! I'm running into something I don't understand; it appears to be a bug though I'm not sure. We've got a specific saved view that does not match between our dev. & prod. models. I've tried to override the saved view, then pushed a new revision tag (it contained no changes). Dev. Model Saved View:…
Send Email alter or show alert on screen remind
I'm working on a cycle that will end when the end date is specified. I'd like to send the email 10 days before the deadline. Also necessary to display an alert on pages in order to check the end date and next cycle data. Is there a way to do this in Anaplan? @Sravan @prabhu
Formula help on finding a % of a Calculated LI
Hi, I'm trying to create a formula where it will create a % based on taking my States List parent by each individual state. The formula I have so far is Total Collections / Total Collections[SELECT: State.North America] . I feel like this is correct but my percentages are not looking right. Please advise. want to take this…
Combining the count of two list items.
Hi All, So we have a list say Project phase with three list items in it: Project phase> ALL - Design - Implementation - Done This is how page selector in dashboard looks like and the data tables also represent the values when we based on the list item we have selected. But now the business has requested to combine two list…
ALM - How to LOOKUP native Versions
Currently, using SELECT statements in formulas for native versions - Actual/Forecast. But, this will not work with ALM, so what should be an alternate approach for looking up native versions in formulas with ALM implementation?
Filter on line items that contain a specific text
Hello, I have a module with many line items, and I want to filter on all line items that contain a specific word (e.g., "home"). How can I do that? Thanks a lot!
Anaplan Level 2 sprint 3 INV03 formula showing up as blank
Hello, For the line item "Stock Exception", here's the formula I wrote: 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center] However, if I select "All Products", it is showing up as blank. Is there an error in my formula? How should I…
When Adding A New Line Item - No Data Format
I would like to request that when a new line item is added into a module, rather than defaulting the format to Number as is standard, it defaults to "No Data". Immediate ROI: - Automatically won't toast the model if you write a formula without changing the format * In another post, someone asked what do you "always forget…
Relabel the time dimension
As a model builder I want to have the ability to relabel the time dimension using a specific property/alias so that I don't need to create extra complexity and I can use all the benefits/functions of the time dimension to meet the users's requirements. I will know this is successful if I could rename FY18 to YearXX and…
Subsidiary view Data
hi Team, I have text lineItem (Role change from ASN) and second linitem (Role ID for ASN Role) applies to subset, I have a boolen value (Bu role?) that need to be true if text value is present in subset. adding my three fields below. formula written not working as expected. Any help appreciated. Thanks Jerin
Unable to load special characters using .CSV file
I am unable to load special characters in Anaplan using an import where file is the source. Kindly note the following: 1) Import is setup with text encoding set as UTF-8 2) The format of file that is being loaded is .CSV Following is the text i am trying to import and the text that is getting loaded in Anaplan: To…
Table Card
Can this table card functionality that was released recently be brought to the UX as well? Similar to text cards and how that feature was brought over from Management Reporting to UX...feel like this would be equally as awesome in the UX too! One of our clients requested something just like this and we wish we could…
Planning whole units by a curve
Hi. We have a requirement, in which the customer wants to plan a given number of units to be sold by a monthly curve, in which you only have to plan whole units, i.e I have 45 units and the % of the curve in Jan 23 is 3.45%, so the units to be planned in Jan 23 should be 2 instead of 1.55 (the result of multiplying 45 *…
Product/Country Hierarchy list
Hi I have a list of Products that has its own Parent (Product Brand). Also I have a Country list with Region as Parent. Some of the Products correspond to certain countries, and some of them to more than one country: Product A (Brand A) -> Country 1 Product B (Brand A) -> Country 1 Product C (Brand B) -> Country 1 Product…
Anaplan Optimizer across time v2
Dear Community, I want to use the Anaplan Optimizer to optimize planning/capacity utilization across our supply chain. Got inspired by this link which shows that the Optimizer can in fact take time into account: https://community.anaplan.com/t5/On-Demand-Courses/Optimizer-Dynamic-Time-Setup/ta-p/74604 My challenge is that…
Community perspective: Version switchover management from UX Page with API
The Anaplan API offers many improvements to model management, which can help improve the data quality and make work more efficient by eliminating repetitive tasks, which are error prone. One area where I have found myself doing repetitive tasks is switchover management. Especially when dealing with multiple models it…
Need help for the logical formula of having a running balance
So basically I need help in the formula for arriving in the 'Final' line item. I tried using Previous formula but I am missing something in the logic. Thank you!
In 2.3.10 of Spring2use an intermediate module to align the source with the target
In Sprint 2, Create Demand Forecast, "Remember that Anaplan can automatically aggregate data upwards (from lower to higher levels) in the hierarchy, but in this case you will It is necessary to use an intermediate module to align the source with the target", for the second half, how to achieve it?

Modeling

Discussion List