Modeling

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?
The Truth About Sparsity: Part 1
Throughout my five-plus years at Anaplan the conventional wisdom has been that we should eliminate sparsity in order to model efficiently. Throughout the last year, as part of the PLANS standards initiative, we have been critically re-evaluating all of the existing best practices and techniques and sparsity was included as…
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.
Nithyashree_ Level 2 sprint 3 exams attempts
Nithyashree nithyashree@matasma.com. Hi, I have taken two attempts in the level 2 sprint 3 exams. And all the other attempts are loaded with the same score as in the second attempt. Suggest me any ideas please and also suggest to me is there any possibility for another attempt. Thanks and Regards Nithyashree.
Change Management: The Achilles Heel of Progress
Overview The scope of the solution is aligned among the project sponsor, key stakeholders, and the architect. The solution addresses all the concerns of the current business process and will drive the expected results once implemented. The project rests on a “Big ****” implementation: a swap out of tools and processes that…
time formula to show the first 1 -5 weeks of the beginning of a time period in SYS01
Hi! Is there a boolean line item to add to SYS01 so it only shows the first 1-5 weeks in the SYS01 module? it's annoying to see 100 weeks when all I need to see is 10 or so
Idea Exchange item that deserves some attention! Please support!
Hello fellow Anaplanners! I have a scenario that is captured exactly in the following Idea Exchange and I'm certain you all have or will need this in the future!! The scenario is essentially to have a line item summary method that is a formula and is DIFFERENT than the formula of the line item. Add a custom formula for…
L2 3.3.5 Wrong result INV 01 for begining inventory and shiping time weeks
Hello, can you help me for find mistakes: 1. Begining inventory 2. And wrong result for shipping time weeks = 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product] Here is my results: I can't find misstakes. Everything seems correct. Thank you.
Selective Access to Time Scale
It will be helpful to have selective access to timescale as well as there are different people looking into historical data and projection data. We don't want to show projection months data to people. We tried with filters but people can break the filters by pivoting the view from classic and NUX pages as those views…
Formula Help
Hi - Please could you help me tidy this forumla so that its accepted by Anaplan? IF Type = Supplier Type.Purchase Order (IF 'Forecasted total Value £ (E)' - 'Supplier PO Value (B4)' > 0 THEN 0 ELSE 'Forecasted total Value £ (E)' - 'Supplier PO Value (B4)') OR Type = Supplier Type.Subcontractor (IF 'Forecasted total Value £…
How to hide parent items in a child hierarchy pulldown?
hi! How do I hide parent items in a child hierarchy pulldown? Can i do it using dependency? Please help me.
Model Size Related Issue
Hi All, We have been trying to add a dimension of users to a module in Anaplan. However, it gives the below mentioned error. We have tried to reduce the model size and have made to ~20gb but are still receiving the error. Can we somehow convert the model size and workspace size in the below image attached to gb, to…

Modeling

Discussion List