My Oracle Support Banner

OBIEE 11g: After Adding Column to the Excluded Section of a Report, Data May be Blank (Doc ID 2274791.1)

Last updated on JUNE 01, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


After adding column to the Excluded section of a report,

        Before:                                                                                                                          After:



data for the column (Billed Qty )becomes blank.

Before:                  After



Issue will be reproduced by :

1. Column to be calculated is dropped to Measures

2. Subtotal or Total is valid in the view

3. Had dropped another column(s) to Excluded Area (excluded columns are not relevant to  existing Columns and Measures in current view)

Example to reproduce by using  Sample Sales Lite.:

  1. Connect in BIEE and create a new Analysis using Sample Sales Lite.
  2. Select Product, Company, Revenue & Billed Quantity
  3. Navigate to the Results tab
  4. Edit the Table View & click on Product Sum and choose 'After' to add a Subtotal after Product.
  5. Click on the Billed Quantity icon and choose Aggregation Rule and select None.
  6. In the data above, you will now see that there are Subtotals for Revenue and the Subtotal for Billed Qty is blank.
    This is the correct results we want since Aggregation Rule as "None".
  7. Now add Per Name Week to the Excluded Area.
  8. The column Billed Qty now becomes blank. This is the issue here.




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.