OBIEE 11g: After Adding Column to the Excluded Section of a Report, Data May be Blank

(Doc ID 2274791.1)

Last updated on JUNE 14, 2017

Applies to:

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

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms