OBIEE 12c: Inserting Report with Hidden Header into Smartview on PPT and Excel Fails with Error"Object reference not set to an instance of object" (Doc ID 2699744.1)

Last updated on DECEMBER 14, 2023

Applies to:

Symptoms

Trying to insert a pivot table has no header (hidden) using Smartview into PowerPoint or Excel fails with below error:

However, the pivot table that have a header can be inserted successfully in PowerPoint or Excel.

This can be reproduced at will using Sample Sales lite rpd as mentioned below:

Case 1 (Without Header)

1. With Sample Sales create a report with Product ,Product Type and  Revenue
2. Click Results ->New View-> Pivot Table and Close the Table View
3. Edit Pivot Table.
4. On the Layout, drag and drop P1 Product, P2 Product Type from Rows section to Measures Label under Column section.
5. Click on the More options (gear icon) to the right of Measure Labels and click on Hidden.
6. Click on done
7. You can see that the resulting report dont have any header (Product,Product Type,Revenue)
8. Save this report as "Without Header"

Case 2 (With Header)

1. With Sample Sales create a report with Product ,Product Type and Revenue
2. Click Results ->New View-> Pivot Table
3. Close the Table View
4. Edit Pivot Table.
5. On the Layout, drag and drop Product, Product Type from Rows section to Measures Label under Column section.
6. Click on done
7. You can see that the resulting report have headers :Product,Product Type,Revenue
8. Save this report as "With Header"

Now open Microsoft powerpiont 2013->Smart View->Panel and set the connections.
Insert the report->With Header==> It is successfully Inserted
Now Insert the report->Without Header==>Errors with "Object reference not set to an instance of object"

Cause

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