Modeling

Partioned Dashboard Elements
BLUF: Different users require minor variations to dashboards - due to the complex structure of the underlying data sometimes it would be beneficial to compartmentalise simple elements of the dashboard so they are only linked to whatever visual elements are displayed. E.g. * Recently we have been asked to provide an update…
Time Dependent Hierarchies
Hi, I would like to have time dependent hierachies for financial consolidation purposes. It would help us when we have changes on the ownership structure from one month to other.
More granular forumula scope for versions
Description of enhancement: Ability to set formula scope for selected versions rather than just the limited options of All/Actual/All except Actual/Current. Business case: This would give us the ability to control what versions applied to a given formula. Would allow us to create snapshots. Would allow us to work in two…
Make Users List import available for Deployed Mode Models
Description of the enhancement required: It should work in the same way as for Standard model, could you please make available Users List import for Deployed Mode Models? Currently user access settings can be amended manually only. A story for why they want the enhancement: We have one list which includes 10596 items. This…
Hide column time members without using Filter
Hi Experts, I am new to ANAPLAN.Please kindly suggest me .How to solve the below requirement The Requirement is like as followes, They are three Versions 1)Actual 2)Plan 3)Forecaste. I Developed Filter module.In Filter module we have plan,forecaste list items. user select plan version If Plan list item is 1 those columns…
Anaplan Certification Types
Hello Friends, Can someone help me about what types of Anaplan Certifications are available? Are all of them chargeable? And what is the minimum cost for any Anaplan certification? Thank You. Regards, Sammy.
Values from multiple line items into one line item split by a dimension
Not sure if this is possible. I have multiple line spread across multiple modules. I want to be able to bring all the values into one line item in a seperate module which it split by a dimension reprenting each of the unique line items. So I have: Module 1 with Line Item A Module 2 with Line Item B I want Module 3 with…
How to override columns without using filter
How to override columns without using filter
How to hide column using formula
How to hide columns using formula and which formula to use. For example, if my column value is equal to 0, it should automtically hide those columns and if cell value if equal to 1 then it should display the values of that column.
Ability to set different summary options for each list a line item applies to
Currently, at a line item level, it is possible to set a specific summary option for Time. It would be beneficial in terms of space and performance to be able to do so for each list a line item applies to. For example, we often have a list called "scenario" with a top level item so that we can create scenarii by "copy…
Changing Current year
Hi, I am working for a client for which we need to change the current year in time settings from 2018 to 2019. We have one future year and one prior year in the settings. I want to know whether updating the year will impact any structure of modules, reports, live model synchroisation etc.? or I am good to change the…
SUM Question...
I need a hand on this, should be something easy, hopefully someone can help me. I have a LIST of 62 items (Products) These products has their transactional data in another LIST. I have a Module A with 4 categories of these items. 2 Categories are coming as they are in the Product List, the other 2 are determined based on…
Pretty Printer bottom when creating formulas
Hi, It could be very usefull if we had a pretty printer formula when creating formulas. I know we can check the formula indented when clicling on Drill Down, but it will be help us when we are developing formulas. Regards, Fayelle
Allow history export summary only
When the model history is shown on the screen it is as a summary. When it is exported as a file it contains all the details. For some uses this is too much data and it would be good to have the option to export as a summary, just like the data shown in the dialog.
Time Range Selection on Module Creation
Allow model builders to select a TIME or a specific time range that's been setup while in the 'New Module' window, when first creating a module - to avoid having to change in blueprint mode later to all line items.
Change Time Range start month from Jan (calendar years) to March/April (financial years).
IDEA: Allow Time Ranges with Financial Years to be applied to Input / Output Modules - i.e change Jan commencement to Apr. Within the Financial Services Industry, it is common that the format of Reports / Outputs, as well as Inputs, use the Financial year (e.g year ending 31st March). To allow this functionality, the…
How to get "hierarchyEntityLongId" (List id which appears if you copy-paste list format to excel)
Hi all, Excel is very handy for "mass" analysis/amendments of line items. However, for List formatted line items I get List ID (instead of name) in "Format" column. It happens both when you copy-paste or export blueprint for all line items. It is very annoying to manually map these IDs to list names. Screenshots are below.…
When I Create a New Action / Module / Dashboard take me to it in the list
When creating an Open Dashboard action in a very long list of actions, the action gets created and the list gets scrolled all the way back up to the top. Our Actions list is over 1500 items long, we have hundreds of processes, imports, exports and other actions to scroll through making this simple task of adding a new open…
Module sparsity leading to size and performance impact. We are looking for alternative approach.
Dear community, I am having issues with modules I created to analyze the planning results. Due to the high sparsity of the data model, I get a lot of cell combinations, most of them empty but leading to high memory and performance impact. I will explain the model setup that leads to the issue, hoping someone knows how to…
Functional areas: add a column which indicates which modules belong to each functional area
It would serve as the "refenrenced by" column, to identify quickly which modules belong to which functional area. This would enable to remove unused functional areas more quickly and identify if some modules are in the wrong area
How to give a group of dates as a condition?
Hi, I am trying to build a training diary that should prompt an error message whenever public holidays are being selected. For example , there are 10 public holidays in a year. I need an error message to be prompted while choosing any of the 10 days. How do I use these dates in my formula conditions? For example, the dates…
Limit on Input values
I want a certain limit on the total of my input data: * List of 5 products * Input Module in which a percentage can be inputted per product * The total of the percentages can't be more than 100% Is there a way to show a certain error message once the input results in a percentage of more than 100%? Thanks! Faas
Find date related to boolean line item
I have build a module with time over the columns and a flag as a line item. Now I want to extend this flag to an x amount of periods, starting from the date flagged in the current flag. In order to do this I would like to find the date attached to the TRUE value of the flag, then sum the amount of periods to this date, and…
Check dependency on a dashboard before deleting a module
I have been cleanning up a model and deleting modules I thought I did not need. I was doing it based on the field "Referenced By" however, this field only considers module references. I would like to suggest "Referenced By" includes everywhere where a module is used, for instance, dashbboards. This way, someone cannot…
"Merge Heading" Feature to Group/Separate Same Line Items
1. Adding The Merge Header Feature, or "Line Item Header 1" will allow us to group Line Items wit hthe Same name in the module, using the same line iem, and organize the structure overall in a way that is more efficient to build and report. 2. Merging the Line Item Headers will shorten the Names of the Line items and make…
Workflow email
Hi, Is it possible to customize the email template sent from the workflow view? Thanks!
How to run a process from another model?
The title is pretty self explanatory, but if I have model A and model B, is it possible to create a process in model B to runs a process in model A?
Text Calendar
Hi, Lets start with a picture I have a module with brands, promotions and periods and some text, and would like to present them similar to the above picture. I have not seen or used a module where text is displayed in periods, and before i started trying to work it out, wondered if there was any suggestions, advice or…
Generic app to convert flat ragged hierarchy to composite hierarchy
An example of the enhancement: It would be helpful if there is a generic app which can be used to convert flat ragged hierarchy to composite hierarchy. The only difference between ragged hierarchies are LEVELS. If we can define the required LEVELS in the app and load the ragged hierarchy, we should get composite hierarchy…
Open multiple models in 'tabs'
It would be extremely useful when working between models to be able to open them within side-by-side 'tabs' within one browser tab (a la Smartsheet), and avoid having to exit the model back to the dashboard.

Modeling

Discussion List