-
Filtering/Formula based Complexity
Anaplanners, Had a query that i have been stuck on: - I have a module dimensioned by Projects, a List with serial numbers 1-10, list formatted Line item (Project Phase). Ask is, Projects dimensioned as row headers, Serial Numbers 1-10 as columns, Project phase/ Line Item as selector. End User can select a particular phase…
-
Switchover and Current Month change
Hi, It would be great to have functionality for automatic update of cheking out the Current version as well as changing the Switchover month during the period shift. I was informed that it's no possibility to do it not manually. It can be done e.g. by the switch button or the opportunity to trigger it when the month…
-
Switch Statement Formula
Adding a switch statement formula to Anaplan to get rid of long nested IFs! This would assist in readability (and therefore maintenance) of complex formulae. Switch statements allow you to test a condition, and assign an outcome to each condition. For instance you may have want to test what mode of transport is being used:…
-
"Model Health" / Performance Dashboard
As an external Anaplan partner, we get regularly the question to look into the performance and structure of customer models to assess the health of a model and to find opportunities for improvements. I built for this a model that allows me to upload f.e. line items and gives direct insights on key areas like size, usage of…
-
New Model Experience - formula editing field improvement
I am sharing here one idea that would make the New Model Experience even better than it is now: Automatic formula indentation / keeping white spaces and new line hits in formula text It would be quite nice to be able to keep the formulas more friendly-looking and let devs to work with them easier. Colours in formulas made…
-
Standardise Zero Formatting between Modules (& Classic UX) and New UX
When setting number formats, the formatting should be consistent across Modules/Classic/New UX. Below, see an example where a material zero balance is formatted as a hyphen as selected. In the New UX, this appears as a non-zero value. The workaround is to round the output to zero, but Anaplan should format consistently…
-
Be able to navigate/refresh dashboards while processes are running by other users
It will be a lot more efficient for users to be able to navigate and refresh through the dashboards so at least be able to view the information even if other users are running actions or entering inputs. At the moment, the whole model freezes while other users are processing action or entering inputs. This sometimes may…
-
Job Aid: How to Use the New Model Search
Retail Team!! @VickiA posted all the New Modeling UX features in this post. Just wanted to show you where the "Model Search" magnifying glass is located. Took me a while to find it. It's terrific! Already used it to clean up one of my models - used it to search for line items used for filters that I want to change,…
-
Level 2, Sprint 3- 3.3.6 Activity: Test the Shipping Cost Formulas
Hi, I am struggling with updating the formulas of Confirmed PO Delivery and Confirmed Purchase order receipt. Regarding "Confirmed PO Delivery", I understand to replace OFFSET by POST, to push the data to future periods instead of pulling: POST(PO Submitted, -Final Shipping Time Weeks, 0). But I don't get what is wrong…
-
Level 2 Activity 1.3.4.2
I'm unsure of where I am going wrong. The task here is to populate the missing Regions columns with the parent line item from the 'Countries' file. I am mapping the following; column 2: country name to Target: Country Flat column 3: Parent to Target: SYS06 Country Details Line Items Perhaps, i'm not understanding the…
-
Cloudworks export date format timestamp
I would like to have the possibility to define the date format for exports to cloud storages. When you currently export files through Cloudworks you have the choice to tick/untick the overwrite file option. If overwrite is unticked Anaplan adds a timestamp in a worse machine reading format (e.g. <action…
-
How to find no of strings in a concatenated string
Hi Everyone, I have line items which is the concatenated string ex - 123,435,234,678,567,987 I would like to find no of strings present ie 6 Could you please help me with this. Thanks Tejaswini
-
Grid on dashboard
* Hi, in a module saved view, I created a grid with weekly time buckets filtered on about two years history and two years future.. On the NUX dashboard view, the grid starts from the first week, so 104 weeks in the past, and we need to scroll to the current week if we want to make changes in the future. I would like the…
-
Display Line Item GUID in Blueprint
I would like to have a unique identifier for every line item in a blueprint displayed either on screen or when I do an export as this will enable me to do more straightforward comparisons between models where the line item name may have changed but not the use of the line item itself. Currently I either have to a code…
-
Create a Roles List That Can Be Referenced in Modules
Having a Roles list that is auto-generated and able to be leveraged in modules would be very helpful. For example, in certain system/admin modules we assign read/write drivers on partiucular line items. Currently, the users list is leveraged to dynamically change the access via a formula and an import. However, having the…
-
Level 2 Sprint 2 2.3.10-Baseline Forecast for FY21
Hi, I checked the answers related to this topic but I couldn't find the answers. In the DEM03 Demand Forecast module, I have the Baseline forecast values for FY20 which is coming DAT03 Historic Volumes module. However, I don't have baseline forecast values for FY21. I tried to write if/else formula for it but it didn't…
-
"Average" is close to useless. Need to be able to automatically only average non-zeros
The average summary method and aggregation function [Average:] both include zero values when calculating an average. This makes sense but sadly means that in almost all scenarios the irritating workaround of counting non-zeros and then dividing is required. This costs line items (and therefore space), increases calculation…
-
Add ability to easily step through / run until X in a Process
I would like the ability to more easily step through the actions in a given Process. Often when trying to debug an issue with a given process, I need to step through the actions in the process to see how the data or views change mid-process. Currently, I need to search for and run each action independently in order to do…
-
Selective Access
Hello, My model consists of hierarchical lists, E1 Expense category, E2 Expenses. I created an input module with E2 expenses, time(months), Money spent (line item) as dimensions. I have applied filters such that user shall select E1 expense category(in user filters module) and input module shows E2 expenses of selected E1…
-
How to get Formula to display the time it is pulling
Hi, Need to know how to get a date to show for a line item that is dimensioned by time, but the module is not dimensioned by time. The formula is working correctly, but can only see the result in a subsidiary view. Need to know if possible how to get the result to show when the LI is not in subsidiary view. If this is not…
-
2.3.9.1 Import data into DAT03 Historic Volumes module - 9.3 Import Shipping Metrics
I am having issues with 9.3 Import Shipping Metrics. I'm not seeing why I keep getting this error. Please see attached.
-
Polaris Engine and Calculation Memory Consumption
Exciting news on the new calculation engine. I saw the memory consumption on data https://help.anaplan.com/616ee341-8a5f-4718-8c90-c82e34eca86c-Understand-sparsity-and-density , however how do calculations compare in consumption of memory? There is a 3x usage for data, but if I increase my number of cells, how does this…
-
Applying DISCO labels to Model Map
I would like to apply the DISCO-methodology to the Model Map. The most efficient way would be to label the Functional Areas to the DISCO. The model map could then be visually sequenced based on the DISCO steps: https://us.v-cdn.net/6037036/img/PLANS_DISCO_33530.jpg?small?v=1.0&px=200 This could improve the value of the…
-
Manage List Subset in Module
Hi, I want to use List Subset. We can import Boolean item to List Subset. But we can not input the formula in List Subset and can not make a refference in module. How can I manage it in module and List? And Can we filter original List by List Subset?
-
Using Boolean Field to Filter
Hi. Currently the Retention (B8) field is returning the sum of all values. I've introduced a boolean field but i'm unsure how to update the formula so that it only returns the value we want (which is always the most recently added). There maybe a smarter way to achieve this?
-
Formula Help
Hi, Currently I'm trying to make it so if a end user puts in a number from a inputs model I created, then it will override whatever is there in the current month. The formula below is what I created so far but need help getting the input to override whatever was there for that current month. Formula IF End User…
-
select
when we should use select function . can anybody tell me with an example or scenario .
-
Decimal control for multi currency
Gurus, In some line item, currency will be different and depends on company to be selected. For example, if subsidiary is Japanese company, currency will be JPY which is no decimal point, And if subsidiary is US companym currency will be USD with 2 decimal points. So, how these are managed in Anaplan? In case of…
-
Process not running correctly
Hi, currently have a process that is supposed to take data from one module and put it into another. But currently the process is not working. Screen shots of error are below. Thank you
-
L2 conclusion INV05 export - import is wrong
Hello. Please help me for settings of exports. I've changed many variants, but it still wrong. The pivot Filter - Months Only Summarize - none I try to export grid or table, but it gives mistake for import. Please, help me for solve.