InstantOLAP is a lightweight reporting and OLAP system. It’s made for OLAP reports. But if we have a non-aggregating query, we can still list all the rows by using the ROWNUM() function, which helps iterating over the result set. But we’re not able to use a dimension for grouping the rows of the result set.
I’ll give an example: imagine we have rows describing some customers. Each customer is in exactly one customer category. What we now want to have is a list of all these customers, but grouped by customer category. And because we have a dimension for the customer category, we want a separate table for each category. The naive solution seems to put the customer category dimension as an iteration into the outer block of the pivot table. But this will not work because ROWNUM() – an thereby the LINE_DIMENSION – is the only dimension used for iteration.