My Oracle Support Banner

OBIEE 12c: On SmartView, When the Table of BIEE Analysis is Inserted Using 'Insert as Excel Table', Previous Values will be Left After Refreshing. (Doc ID 2477387.1)

Last updated on MARCH 03, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version to [Release 12c to 12g]
Information in this document applies to any platform.


When you connect to OBIEE 12c from SmartView and insert any tables of BIEE analysis using 'Insert as Excel Table' option, although refreshing the object after filtering the target analysis from OBIEE, the previous values will be left on SmartView.

[Steps to reproduce]

1.Launch Excel with Smart View and sign in a private connection.

2.Insert an analysis using 'Insert as Excel Table' option in catalog pain.


Analysis example:

3.Filter the analysis to narrow down the results (ex. YEAR < 2009) from OBIEE and save.

  That filters the data correctly in OBIEE.

4.Refresh the analysis from SmartView, but it does not reflect in the smartview.


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.