My Oracle Support Banner

OBIEE 12c: On SmartView, When The Table of BIEE Analysis Is Inserted, the Value of The Aggregation May Be Different Between 'Insert as Excel Table' Option and 'Insert' Option. (Doc ID 2431763.1)

Last updated on NOVEMBER 07, 2019

Applies to:

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


When you connect to Oracle BI EE from SmartView and insert any tables of BIEE analysis using 'Insert as Excel Table' option, the measures may not be expected.  The value of aggregation may be different from the output of the BIEE Analytics, or the output via 'Insert' option on SmarView.


 You change the value of 'Aggregation Rule' in Analytics other than the default on 'Results' tab.


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.