Monthly Archives: October 2009

instantOLAP: The ROWNUM() function and grouping

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. […]