-
SOS : A modeling question
Hello Everybody , I have two lists in Anaplan , let's name them countries with all the countries in it and a second list called products with all the products that a company have. I want to give the possibilty for the user if he check a country , he will see only the products in his country. So my question how we can do…
-
Summary Calculations With the User List
Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…
-
Allow for line item subset to be more than just number formatted
Description of the enhancement required: Line Item Subsets are often used to build filter modules, as an alternative to using the Show/Hide functionality. Using a Boolean against a Line Item Subset on a filter module makes it very easy to select which columns should be shown or hidden on a dashboard. An example of the…
-
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
Clickable Image Links
We would like to put an image on the UX dashboard, which can be clicked on to navigate to a specific link. Is this possible to do?
-
Remove 10 million item limit from the ISFIRSTOCCURRENCE function
Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.
-
Insert multiple Items to a list from UX
Old UX had capability to add multiple items to a list from any published module grid. This capability is missing in new UX. UX only provide option to use Form type action but only allows adding 1 list item at a time.
-
Allowing Documents (pdf, excel, word, ppt) attachments in Anaplan
It will be helpful if there is capability to attach Documents (pdf, excel, word, ppt) in Anaplan. Many planning decisions/inputs need supporting documents as attachments.
-
Line Item Subset Formatting
This post is a bit of getting ideas to work around but also see if people are experiencing similar issues. I think it would be a good idea if Line Item Subsets could inherit the formatting and time settings from the source modules that they come from. In the situation where you had a KPI which was a %, a number and a…
-
New Model Experience: Re-open last closed tab
Often when you are model building or analysing an issue, you close a tab (be it a dashboard or a module) and realise you should have kept it open. Often that then means having to go away and search for the object again. It would be really useful if like on internet browsers like Chrome, you had the option to re-open the…
-
Black Box Timesum Drilldown
One of the best things about anaplan is the ability to drill through the model to see where values come from. sadly, anaplan is now quite limited in how you aggregate over time. at some point changes were made that more else require you to use the timesum function to aggregate over time specifically (SUM: does not work).…
-
Global Find & Replace
I would like the ability to perform a model wide find and replace of a word. I should have the option to include text boxes, dashboard names, module names, line item names, action names, help text, tool tips, and literally ANYWHERE else in the model this word or string occurs. It should basically behave like Excel's find…
-
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
-
dependent dropdown multiple condition
Hi, Is there a way to make a line item( dropdown list format) to have multiple conditions? example : I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? GL account is dependent on both the cost center selected and the account type…
-
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
-
Failed to retrieve field list from the selected data source. Please check your import settings and
Hi I'm received this error and it took a while to work out what it was. In the "Source Models" it was pointing to the wrong environment, this is confusing because I could still see the "Saved Views" to click on, it would bail out straight after that with the error. The complete error is: "Failed to retrieve field list from…
-
Show the last date and time a process was run on a dashboard
We have a process to import live orders, and it takes a little time to import the data, it is used up to 7 staff members, and as they are working from home a great deal they sometimes all run the process one after each other, which can be draining on the system and my mood It can be run 40 times a day and only needs to be…
-
Eliminating Sparsity
Summary: Sparse cells within an Anaplan model are cells that do not contain and are not expected to contain data. The platform still needs to allocate memory space to these cells even though they are not used. The trick is being able to identify and combat these cells in existing models as well as preventing them when…
-
Designing models that scale
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. One of the aspects which determine whether a model will meet the need of the business is how well it can scale. Whether the constraint is balancing numerous concurrent users, or having dimensions with high indices, or both and…
-
Dependent Dropdown Issue
Hi, I have built a dependent dropdown but its not functioning properly. I have a hierarchy which follows the certain order: Entity>Segment>Product Below is my segment hierarchy Below are my line items which are list formatted When I am selecting the top level of Entity, my segment dropdown is showing entity list and on…
-
how to pull values from one module to another module with no common dimension?
I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
-
The ability to add a dynamic sub total to a grid
I would like the ability to add a dynamic subtotal to a grid, so when rows are filtered out the total is updated on the fly
-
Sync on Selection - Multiple dimension Cell based
I understand how synchronization on selecting a list on grid works, I am trying to see if I can make it work on multiple dimension. eg, if I have a grid with list on my row as well as column. Is it possible to select a intersection cell and be able to synchronize select both list? Any tricks for that.
-
Model Sparsity - Combination of Dimensions
I have a question about reducing sparsity in a model by using numbered lists to combine a series of dimensions. I am using ledger data that has information by supplier and by department over time. If I create a module that is dimensioned by these I end up with a huge amount of sparsity as most suppliers are just used by 1…
-
Create Demand Export Module and Create a Saved View - DEM04
Let me know, if it is right! Is the time scale right?
-
Driver Line Item for Action Button
I have condition in card where user can input negative value. But when the value is negative, the button will disable to click. I have data Product as Context Selector, Time Period Month in Column, and Line Item to input Order Quantity Review in Row. User will input number of order quantity review, but when the value is…
-
Please change the layout of blueprint view!
The New UX is great and has drastically improved the end-user experience however, the model builder experience has really lagged behind. Anaplan models should be as easy to build as they are to use. There are some really easy wins to be had that will drastically improve the experience for model builders, in this…
-
Modelling Ideas
Hi All, Is it possible it have a view like this in Anaplan? (Q1-Q4- Time range - how to fit in GAP in the same row). Revenue, GM, OPEX, EBIT will be line items and ASI,PMO,PPT will be list. Please give suggestions on how this can be implemented. Thanks in Advance.
-
Edit Multiple 'Source Model' Settings for Pages Simultaneously
The ability to edit the source model of multiple pages at once would be a huge quality of life update for page builders. Currently, model builders have to edit settings for each page one-by-one. This idea proposes that page builders can apply the same change to multiple pages at once: image below shows how this could work.