In addition to charts on a dashboard we have a request to have a crosstab which would be populated by some entries queried out of an error log. It's basically a detail query with mostly text data. I have tried making a pivot widget for this using both a cube and kpi source, and while succeeding with the KPI, it leaves a lot to be desired.
Firstly, the cube is a no go. As far as I can tell the MDX subsystem in IRIS does not handle empty cells efficiently like other MDX systems such as Oracle's and Microsoft's.
.png)

.png)


