Option to display list properties on a grid

Customers very often request reports in which to show together properties and Time dimension as columns, similar to what they are used to see in an Excel:

2022-09-29 09_50_29-OPTION B_ Test Dummy Line Items.xlsx - Excel.png

As of today, this is quite difficult to build in Anaplan. The most common solutions to deliver this requirement are:

  • OPTION A: Nest Time with line items on the columns and only show the properties in the first Time Period (and manually hide the property line items in the rest of the columns). Downside: requires quite some manual work to set up the view and sometimes it is not sustainable, since Time dimension can change, and the view needs to be re-adjusted by a Model Builder.

2022-09-29 09_34_46-Spanish Morning Coffee ☕ _ Microsoft Teams.png

  • OPTION B: Create dummy Time line Items together with properties. Downside: cannot use the benefits of native Time dimension, plus a mapping module from dummy time to real time is needed to connect to other modules.

2022-09-29 09_24_38-Calendario - fabio.casalegno@sonum-int.com - Outlook.png

These solutions are not optimal and can go against the Sustainability of good model design. Moreover, none of these two options work when you need to display properties AND filter the columns dynamically (e.g. depending on Version, display some months for Budget and other months for Forecast). The reason is that only number-formatted line items can be part of a line item subset.

Synchronized scrolling on the UX has made this possible using two parallel tables but, when there are many properties/months, horizontal scrolling is not user-friendly, and end-user filtering applies to only one of the tables:


2022-09-29 09_46_39-Spanish Morning Coffee ☕ _ Microsoft Teams.png

A very easy solution would be to allow the option to display list properties on a grid. This should not be a very complex functionality to implement, in fact, it is already implemented for exports, where you can select the labels. Ideally, end-users would also be able to filter/sort on these columns, like normal line-items. Keeping consistency with the Planual recommendations, list properties should reference a system module in which this data is stored. This would also give some purpose to list properties, which today are barely used.

2022-09-29 09_38_59-Option B_ Dummy Line Items _ Anaplan.png

This solution would benefit the broad community: end-users would be able to have a more complete and friendly interface for their planning, and model builders would not need to think of suboptimal solutions to deliver this type of report.

18 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!