My Oracle Support Banner

Smartview Analysis Using Multiple Sub-Totals Errors With 'OBIEE:Assertion failure: !(pageStartRec > 0)..' (Doc ID 2687357.1)

Last updated on JULY 09, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version to [Release 12g]
Information in this document applies to any platform.


Report with multiple sub-totals on dimensions throws the below error in SmartView. The issue could be reproduced as follows.

Steps to Reproduce:

  1.  Open Excel with SmartView installed, Set up a private connection to OBIEE.
  2.  Create a sample Analysis with two duimensions and one measure in a table view with two Sub-totals on dimensions and a grand total.
    The results display in OBIEE fine.
  3. Pull the Table view of this Analytics in the SmartView.
  4. The below error gets displayed.
  5. Uncheck one Sub-total in the Analysis and the results display fine in the SmartView.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.