-
Reducing Model Size – Introduction to Sparsity
Summary: Unnecessary model size has a large impact on your Anaplan environment from using valuable space to slowing down key processes. Sparsity is one of the biggest causes of inflated models. Understanding what sparsity is and how it impacts a model is the first step in knowing how to reduce it. Course Objectives: By the…
-
Display the number of cells and Gb when insert a new module
As a model builder i would like to see in the upper right corner off the "insert module" window a field with the number of cells and Gb and the treshold of my workspace. This will be the first alert to avoid to reach the maximum limit of a workspace. This ratio 'size of the module' / ' size of the application' display in…
-
User List formula to include admins
A description of the enhancement required: Right now in the Anaplan if User List is used as a dimension, all non-admins can see themselves only. As for the admins, they can see all of the users in the dimension. Thus there is no way how to use personal filters (Booleans on user list dimension) for non-admin. Could you,…
-
User-defined, collapsible groups in Actions / Dashboards / Modules Lists
As a model builder, I would like to be able to create & name my own groups within Actions / Modules / Dashboards lists, as well as collapse those groups I don't want to view at the moment, to help me decluttter the Anaplan screen & better focus on what I'm trying to accomplish at that moment. Additionally, if I perform a…
-
Mousing-over part of a formula should show its current computed value
Normally when writing code I can troubleshoot my code by stepping through it piece by piece to see where things fall apart. In order to accomplish this in Anaplan i tend to have to create separate line items with pieces of my formula to see how they compute. To help a modelbuilder better troubleshoot formulas without…
-
Add CTRL + SHIFT + S Hotkey to search in Module / Dashboard / Actions Lists
Just like searching in a published module on a dashboard, for consistency when model building, I would like to be able to hit the same CTRL+SHIFT+S hotkey when looking through the list of modules / actions / dashboards etc. to quickly search, instead of having to manually click the search button.
-
SELECT unavailable
I have come across an issue where a line item is dependent on dimensions not part of the Module makeup, I would like to use the 2021 by month line item in a new summary module but seem to be forced to add in Reinvestment Group as a dimension where in reality I want only the top level view summarised only by GL account cost…
-
Using No data line item to enter comments (Admin)
Hi, a short tip ad trick to document the blueprint. I use No Data Line items, hidden in dashboard, to define distinct /homogenous chapter / parts in the blueprint. No Data line item are supposed to be No data, and they are, BUT you can nevertheless enter a formula in them. I use this feature to enter a text formula which…
-
How we can concatenate two number line items?
I have got two number line items as shown below. LineItem1 , LineItem2 , Result 1 2 1(2) 3 4 3(4) 7 10 7(10) I want to get the result as shown above for the two line items. Ideally i need a concatinated value. Could you please assist me in achieving the same in Anaplan.
-
Group option in RANK Function
Hi, I have a module with 3 or more lists, and Value and Rank line item. I want to rank Value for each combination of items in those 3 lists. However, I find that RANK function can only accommodate 1 list in the Group option. How can this be done? Regards, Andre
-
Schedule Module as Report
Beginner Question: Is there a functionality to schedule the export of the current view of a module to a specified user?
-
Show Total in Module even after applying filters
Hi All, In one of my moduel having a column "Rebate Payment Amount" which has values, and also we set the show TOTAL on Above for giving total aggregated values as single value, it works only if we didn't apply any filters on the remaining columns in the module. How to show the 'Total' i.e. sum of all rows for the column…
-
Ruler in design mode
Hi everyone, I think it would be useful to have a ruler on the top of the window in dashboard design mode. that ruler would help us positionning dashboard differents elements and make dashboard designing easier and fun. have a nice day Regards Patrick
-
Single Sign On(SSO) with new workflow method
Hi everyone, A question about how SSO works with new workflow method - since the new workflow method will enable an automatic notification email which contains the URL linking to the dashboards that the users need to update, how does it work with SSO? For instance, if an user doesn't have Anaplan logged in at the moment,…
-
Dynamic Cell Access or line items with formula
I have a module with imported data. Some line items need to be editable and some do not. to make a line item not editable It seems there are two ways to do this... 1. create extra line item that references, and then hide the line item i don't want to be editable 2. use dynamic cell access I'm wondering folks opinions of…
-
Retaining display names as item names when change a numbered list to unnumbered?
A list which has been used to dimension many input line items was incorrectly made a numbered list when it should have been a normal unnumbered list. I can change it to unnumbered but am left with the expected #123 number as the item name. What I now want to do is replace the #123 with the display name but so far I have…
-
PREVIOUSVERSION(Data) not showing prior forecast actual data - please help!
Anaplanners - I am using PREVIOUSVERSION(Data) to pull the previous forecast's data (formula in first pic). It's not pulling actuals before the current month as you can see in the second pic for May 2018. It seems to be working fine prospectively for June 2018 and pulling in the previous forecast's values for future…
-
TIME as a Line Item/Bulk copy time
Hi All I have a few modules which are being used to capture settings/variables which the users will select via a dashboard. The modules include the TIME dimension using the Quarter timescale as they want to potentially have different settings for each quarter. I want to give them the ability to copy the settings from one…
-
Dynamic changes on List Item
Hi Team, I am trying to do the currency conversion where countries will be reported in 3 currencies USD,Euro,LC Now if the country is suppose France then only Euro and USD should appear in the drop down list as Euro is the LC i.e. LC in the above list should dis appear. e.g. For France Only Euro and USD should appear…
-
Blank for numbers
Hi all, Perhaps a straightforward question, however I cannot find a direct answer. I would like to have a BLANK formula for numbers, so IF ... THEN BLANK. Currently I have IF ... THEN 0 ELSE ... , however it has to be blank instead of zero. Is there a certain formula that works for numbers? Kind regards, Mickel
-
charting with generic week numbers
I need to chart multiple years with one line for each year and the axis showing the week numbers. I've been looking off and on, through the forum, for about four months and no luck finding a solution. Please help. Thanks.
-
Need help with SUM and/or LOOKUP functions
I'll be using 'Formulas and functions' app as a base for this. We have 'Transaction Values' module: I created 'adv prod' list and 'T: map' module. It's goal is to assign basic products to advanced products: Any product can be assigned to no advanced product, to one or many. My goal is to write a formula for this simple…
-
Ability to scroll down in the Module Blueprint view (after adding Version Formulae)
As a Model builder, I will like to have the ability to scroll down in the Module Blueprint View. What is happening currently (refer screenshots attached) is that after we added 20 odd Version Formulae in our module, we're not able to see the Line items at all since the Verion Formula is only visible on screen. Its only…
-
Boolean true by default?
Is there a way to set a boolen line item as true by default, allowing the user to de-select items rather than select them? The module has a large number of dimensions - and is accessed on different dashboards - and so setting each of them to true isn't really practicle (even with the space bar trick) Thanks,
-
Monte Carlo Simulations
Dear Anaplanners, I would like to know if Monte Carlo Simulations are possible on the Anaplan platform ? I would appreciate to any kind of help pertaining to this topic. Thanks a lot. regards, Krishna Veera
-
field missing
. I have two modules with the same dimensions. I’m bring fields into the calculation module from the import module. I’m bring fields into the calculation module from the import module. This works fine for tons but not for percentage distribution. I created a test field and change time scale to year and the values show up…
-
Time Scale changes
Hello, Please do let me know if there a way to rename the Time period Label of Year? For eg FY2015, FY2016 etc. to 2015 or CY2015. Thanks, Suneesh
-
'Formula' sum for 'list'-formatted line item
Hi all, This article ( https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Summary_Methods.html ) claims that list formatted line items can have 'formula' as summary type. In reality it does not work for me. If I try to set summary type to formula - system tells me to enter formula first. I do that and try…
-
Hotkeys for copy across/down
A detailed description of the enhancement that is being requested: can the copy down/across function be added as hot keys (combination of keys on computer keyboard) How you hope the enhancement would assist in your business process(es)?: Some of our end users do use these functions pretty often. The enhancement is pretty…
-
Lookup between list formatted line item value in one module and list property in another module
Hi All, This is around a Top-Down allocation functionality being built for Demand adjustment. Based on the available capacity & resources the demand needs to be adjusted but instead of adjusting at the lowest level (Devices) the idea is to adjustment at another higher level(Packages) and the % adjustment flown down to the…