-
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.
-
Collapsible Textboxes with ability for users to pin it open
For more complex dashboards, showing informative instructions can take up some major screen real estate. I find on first pass a user may want detailed instructions, but after they know how the dashboard works, they want them out of the way, instead of always having to scroll past them. As a model builder, I would like the…
-
Dynamically Update Module Views when filter using line item contents change
On some dashboards showing large amounts of information, we will have a smaller "Smart Filter module" where the user can select values for line items in it. Once selected the main data table's filters will filter based on the Smart Filter module, the trouble is the user has to refresh the page to see the filters reapplied.…
-
Enhanced Textbox Styling & Formatting Options
I would like to be able to apply common styling to text in text fields to help me provide end users with a better user experience. Specifically, I'd like the ability to change the size of the text field itself, the text alignment, text color, font, style, size etc. Also the ability to turn off the auto-appearing scrollbars…
-
Ability to set textbox style & size when adding it, and at a specific location
I would really like the ability to select what size and style of textbox I'm adding at the point when I'm adding it. Currently when adding a textbox it is added at full page width, defaults to "Normal" style, and is added to the very top of the page. Usually when I'm adding textboxes, it will usually end up being a small…
-
Header & Footer zones on dashboards that don't scroll
In our model, we use navigation action buttons to help a user see "where they are" in a workflow with respect to other similar pages. Usually this amounts to ~4-5 buttons near the top of the dashboard in an order logical to the workflow, which are in the same order across all of the workflow's pages. Unforunately when a…
-
Use three versions in model
Hi, I'm trying to build a rolling forecast model that has actuals, budget, latest estimate and forecast with the following dates: Current month = jul 2015 Budget = currenlty available for 2015, should be updated every year Latest estimate = sum of actuals and remaining budget in the current year (2015) according to the…
-
Anaplan function equivalent Excel MATCH function
Dear Anaplaners, What is the Anaplan equivalent function for the "Match" Excel function. I have a list "Age braket": 0 to 10 years 11 to 20 years 21 to 30 years Above 30 years I have 2 line items: Age : format number Age range : format: list "Age bracket" If "Age" is 25 , I would like to edit a formula in "Age range" with…
-
Formula to number a line item to create an order 1,2,3 etc.
I am creating a module that will be a template to import into our ERP. One of the line items is called 'Journalnum' which essentially needs to start at 1 and every line thereafter will be 2, 3 4, etc. E.g. in excel cell A1 is journal number 1 and cell A2 will be a formula to equal A1+1. There are 1000+ lines in the…
-
Display few months of data based on time selection
Hi All, I am working on particular client requiremnt. Where, the user dashboard has time as page selector (weekly format). Each time the user selects the particular week, I need to display that particular month and last 2 previous month data (not weekly). Note : In other words, I have a "movingsum" formula which is…
-
Year over Year Growth
Hi - I'm trying to calculate year over year growth in the time summary lines for my fiscal years. I can calculate year/year growth for each quarter (we are viewing our year by qtr only) using the offset function - (Revenue - OFFSET(Revenue, -4, 1)) / OFFSET(Revenue, -4, 1). However, Anaplan doesnt' allow the offset…
-
Effect of Deleting Module Views
All, I currently have a module that is taking about 30% of my workspace and I am looking into ways to bring the data usage down. I had a couple of questions about multiple views that I saved for this module: * Does bringing down the number of views bring down my data usage? * Is there a way in Anaplan to see which…
-
Simple Sum
Hi I have 2 modules, EPOS Daily Module which has EPOS data stored with a 'cust-bvfsku' and a date, updated on a daily basis. Then I have a top level module EPOS Sales List Module, which has a single line for each unique Cust-BVFSKU, and a start and end date. I want to SUM the p_unit Qty from the top module into P_Sales in…