My Oracle Support Banner

OBIEE 12c : Smartview – When Insert as Excel Pivot,Blank Sheet are Generated (Doc ID 2617283.1)

Last updated on DECEMBER 11, 2019

Applies to:

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


On Oracle Business Intelligence Enterprise Edition and later versions.

If you insert a pivot table with [Insert as Excel Pivot],Blank Sheets are Generated.

The default number of sheets varies depending on the Office version.
Until to Office 2010 (2007, 2010), it opens 3 sheets by default.
Since 2013 (2013, 2016), it opens 1 sheet by default.

In case of 1 sheet,
Blank Sheet2 is generated, and the pivot table is inserted into Sheet4. 

In case of 3 sheets,
Blank Sheet4 is generated, and the pivot table is inserted into Sheet6.




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.