Hi there,
The problem
we are building our front end based on NUX Pages in a NUX App. When it comes to creating dashboards for QAS or management reporting there are a ton of features and display options missing. To name a few:
- boxplot diagrams
- month to month transition in waterfall diagrams
- controll over legend size and content in donut diagrams
- relabeling line items
- retrieving color information for dimension member from a configuration table
- Time series animation
- ....
The list goes on and on and on. With the current paste of feature deployment I doubt, that we will have any form of comparable design options as there are in competing product, like Power BI, Tableau, SAC, ThinkCell, etc., any time soon.
A solution
So, my suggestion would be to have new widget, which can display R-plots. Therefore:
- The widget excepts an Anaplan view as data source
- It has a title, description and title color, like any other NUX widget
- It has a text box for entering the R-code, which should be executed
- Last code line must return a plotable object, like ggplot
- The R-Code is executed on server site, while building the webpage containing the NUX-Page.
- Some serious security measures have to be done by the Anaplan devs, to prevent a custom code execution meltdown. But that’s not a domain I understand anything meaningful of.
The idea is not new. In fact, SAP implemented such a widget in their product (SAP Analytics Cloud - blogpost to that feature)
Final Thoughts
One could argue that the mentioned dashboard solution (Power BI, etc.) are not comparable products to Anaplan and hence all the missing features are not relevant. In reality the user, doesn't care with which technology the presented graphical information was compiled. In our company there are lots of departments using all kind of technology to build dashboards. In the current state the majority leans towards using Power BI for creating and publishing reports. In conclusion most decision makers will derive their requirements for the graphical presentation based on things they have seen so far. Most of this requirement can not be fulfilled by the NUX Page design options. If Anaplan does not provide these options in the foreseeable future, other solutions will be sought. Most of them will lead to downloading the planning results and processing them elsewhere. Which is from an architectural point of view complete nonsense and will lead to a delay between planning and presenting / decision making