Modeling

Ability to Merge and / or Replace a dashboard with another dashboard
I would like to be able to replace a dashboard with another dashboard and have Anaplan automatically make all the changes needed to make the replacement be and act as though it was the original the whole time i.e. do all the renaming, change all actions, filters, permission etc. WHY When trying to prevent new features on…
Poisson function
My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold. In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and…
Customize Model Filters
Consider allowing customers to customize the filter categories. App, Geography, Planning Cycle, Environment, and Business Function do not fit our use cases or model categories.
Default Home Page to list view
We would like the ability to default the tiles screen to the list view for all of our users. This view is a lot more user-friendly than the tile view, we have had an abundance of requests for model access when the users do not realize that they just need to scroll to the right to see additional pages of tiles.
Custom Format for Lists
Currently all list items default to text. It would be helpful to add them as dates, numbers, etc.
NULL Number Format
Null option for number format. Currently when a number in undefined, it will populate the module as a 0 instead of a blank. A work around is required to convert all of the numbers into text, and then make undefined numbers "N/A". The ROUND(TEXT()) function also causes a large number of unnecessary decimals.
Default Dropdown Selection
Ability to set a default selection in a list dropdown (similar to how you can in tables and graphs). Allow different default selections on different dashboards.
Dynamic synchronization based on list-formatted line item
Dynamically synchronize published tables based on a list-formatted line item page selector. This would save space since we wouldn't have to dimensionalize the model but could use a list-formatted line item.
Keep Dashboard Tables Anchored
When making inputs to large tables, the dashboard will scroll back to the top after making an entry. The ability to have the dashboard stay anchored while entering information would save time for users. We are having to use the maximize feature for each table to input data.
Mapping on Codes
Allow for mapping on codes in a list that is not numbered.
Maintain Flat File Mapping in Copied Models & Model Mappings
When we move models from workspace to workspace, the Anaplan model to model connections remain intact, but all flat files need to be reuploaded and mapped. This causes a large amount of work per model that we move. Adding this feature would make the workspace governance process run much more smoothly.
Automatic Sum in Drilldown View
Ability to select multiple cells in a drill down window and see the sum on the back end, as you can on a dashboard.
Boolean Format Options
When boolean is selected as a line item format, there should be an option to have single or multiple selections allowed. Currently, the default is to allow multiple selections. For instance, for single-selection, once one line item has been checked, all of the other line items have a greyed out checkbox that cannot be…
Sorting Users in Anaplan
Hi Guys Does anyone know a way to sort users in anaplan . I am talking about the User setup / Access Area . I don't want to delete users and re-add sorted lists as it will generate email notifications to users . Cheers
Referencing Model Calendar in Formula
Hi all, I am trying to see if there is a way to reference the model calendar in a formula. I want to return the fiscal year that the week is in. e.g Week 1 FY19 Result would be FY19 The intention is to use this to lookup other data, E.g IF Fiscal year = FYxx then... I have a Timing - Calendar Module (screenshot below) if…
How to read only 8 previous months data of current month.
Hi, I have created a master time dimension setting module where my current month(Boolean line item) is selected as June 18. I want all the 8 previous months value to be read by a second line item from an input module(second module having data for all period) Amount(line item) should have the values of only 8 previous month…
Getting data by line item into a dimension and generalising a complex formula
I want to calculate some values in my "Forecast" using a formula that is almost the same for each value. The only difference is that each row in the "Forecast" module gets an initial seed value from a different line item in the "Base Data" module. The formula I want to use is actually a lot more complicated than shown in…
Using different versions in formula
Hi, I'm trying to create a formula that has 2 different views of forecasts. My current and my previous. Current is pulling in fine. Struggling to create a formula that says Fcst V2 = Previous months Forecast. So if Current forecast is p4. I want my FCST V2 to equal my p3 Current forecast.
How to add a header name in module grid view
Hi Experts, I want to know how to add a header name in module grid view. As shown in the red circle in the picture. Or, I want to export this spreadsheet, so header name only in export is also welcomed. thanks in advance. Regards, Tsuyoshi
If statement not reading periods prior to forecast start
Hi All, I was wondering if someone could help with below. if statement not reading dates prior to forecast start period. Forecast start period is Mar -19 Below should return 0 rather than Mar -19, why is the if statement not reading the first part of the statement? What do I need to change to get it to work? IF…
Right-Click on an applied filter ---> take me to the module
When Opening a filter, It would be really helpful if I saw a filter I wanted to dig further into and be able to right-click and open the module it's coming from. Currently a user has to back out of the filter view, and go there manually. When there are a few filters I have to screenshot this view temporarily because I…
Don't block manual input if a line item doesn't contain all dimensions of the module
Example: We have a model that is based on dimension A and months and contains 2 line items: -Line item 1 (manual input): applies only to dimension A -Line item 2 (has a formula): applies to dimension A and months If we publish this module to a dashboard with month as page selector, it is not possible to change the value of…
Right-click a part in a formula ---> take me to that module / List / etc.
Similar to some other feature requests I've made... 1. Open From Drill Down (delivered) 2. Open From Filter View it would help model building workflow if I could right-click a module or list that appears in a formula and it give me the option to open the module, or show the list. Again, this is so I don't have to leave…
Add a tab for saved module views in Model Settings -> Modules
Description of enhancement: To add List of modules' views in the Model Settings menu. It would be great if it can include: View name Model name Actions’ names then view is used as a source Dashboards where used An example of the enhancement: It may be very similar with the Modules list. A story for why they want the…
Custom Filter
Hi Experts, I have a requirement.i am confusing how to resolve this kindly help on this. In One module Row Axis - Product and Customer lists Column axis - Lime Item and time lists Page Axis - Measure list There are 5 line items. For each line item i want to saw different time periods that also based on user selection. For…
Equivalent to LOOKUP Function but for a Text formated Line Item?
Hi All, I have an Import Module which has a Number and a Text Line Item. I have created another module with the Dimensions Provided Service and Cost Centre and in the Import Module created List fomatted Line Items for those 2 Dimension. I have successfully pulled across the Number formatted Line item from the Import Module…
SUM on non-shared Dimensionality
Hi, I have a Target module which is Dimensionalised by Line Items and Time and a Source module which is dimensionalised by a numbered list and 3 line items (1 is direct input and 2 are List Formatted (1 being Time, 1 being Line Item Sub-set of the Target module Line Items) In my Target module I wish to return the Direct…
Time Formatted Line Item - Custom Time Range
Hi, Is there a way to use Custom Time Ranges when creating a Time Period formatted Line Item? I wish to display only a certain number of periods as a selection option but currently all periods are the default Many thanks Mark
Extend the number of future years
For the purpose of calculating lease contracts in IFRS 16 it's sometimes needed to have wide time ranges in the model. Currently, the amount of future years is limited up to 50 years and past years up to 20 years (link). This means you have a maximum time range of 70 years. We experience that some lease contracts extend 70…
Consolidated Module (with list output type to combine)
Hi, I have 3 modules, all sharing the same dimensions (period, transaction# and employee list). The first 2 modules contains line item "metric" both with output type list (same list), I need to see all the data in all line items of module 1 and module 2 - it should be consolidated in module 3. In module 3, it has the same…

Modeling

Discussion List