-
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:…
-
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?
-
Total number of Archived models in Workspace
Hi team, Is there any limit of archived models that can exists in the workspace? Any links/articles will be appreciated..!! Thank you, Shraddha
-
Count line items
Hi, I am looking for a way to count the number of TRUE items for a Boolean formatted line item. As per above image, since 3 of the Booleans are selected, I need a mechanism where I can get 3 as the output (it could be in different module as well)
-
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…
-
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!
-
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
-
Model Size
Hi, Where can I see the exact model size in Anaplan? I am aware that model size is available as per below image. I am wishing to see the size at a granular level (MB/KB) Thank you.
-
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…
-
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…
-
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…
-
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?
-
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!
-
Is it possible to bring back the model that was deleted by mistake?
Is it possible to bring back the model that was deleted by mistake from the Manage models screen. Is there a way to restore it?
-
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…
-
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…
-
How can I make this LI go over time
Hi, I'm having trouble making this LI be spread over time. What is the best way to go about this? Thank you
-
IF statement with different hierarchies
Below, I have this module dimensioned by O2 Department (Level 2 in the hierarchy) and another list. My IF statement always returns FALSE when I have some start dates that do match the first day of the month. DAT03 New Hire Details is dimensioned by New Hires (Level 4 in the hierarchy). I believe I have a hierarchy issue…
-
Dynamically show list items in drop down based on a condition
Hi Team, Please refer the image below. The above image shows two grids on the page. Both have same list dimension. I need to build a logic that dynamically changes the items in drop down in the right grid's line item(list formatted called 'Stage') based in the status shown in the left grid item(list formatted called…
-
Level mismatch on common dimension
I know this question has been asked many times already but I'm not following the solutions without my own example. I'm getting this error with the following modules and dimensions. TARGET: To add "Total Hires" to the Headcount and Expenses module dimensioned by Employee and Pay Type SOURCE: Total Future Hires in the New…