SAP Analytics Cloud Analytic Applications offer a way to create interactive dashboards or even “mini-applications” based on analytical and planning data by putting your logic into script code. It offers some standard control types that you can drag and drop onto your canvas to build the user interface – texts, links, buttons, images, checkboxlists…
But when it comes to the display of more complex data types, your options are quite limited with the standard widgets available.
Crosstabs can display tabular data, however this data needs to be available as fact data in your model, and you have no direct control from script. What you actually need is a table display widget that will display a classic, native UI5 table, not a crosstab indeed. Ideally with the possibility to diplay links, buttons, icons and other types of controls in the table call. Maybe even supporting sorting, grouping and search. Something like this:
And for mobile applications you probably want this rather as a list than a table, to fit it on a portrait display – or into a the left side panel of a “master-detail” screen layout on a monitor:
So how can you achieve that? At the time of writing this blog post the only way to go would be a custom widget.
Want to know more? Get in touch!