Sunday, February 8, 2015

Oracle BIEE 11g – Sub Totals and Pivot Calculations

February 8, 2015 Manish Chaturvedi

    This post is a reappraisal of another a while back by Venkat from RittmanMead, which can be read here. The original post had laid out behind the scene handling of Summary and Grand Totals in Pivot tables.

The main take away is that as of OBI 10.1.3 Sub Totals and Pivot Table calculations are frequently handled by the BI Server – with only the basic Select pushed to the database. Intermediate results used to derive the calculations and totals are found in tmp files on the BI Server, raising questions about both performance and scalability.

So has anything changed how OBIEE generates SQL (both Logical and Physical) as far as Summary Reports and Sub Totals are concerned?