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 DECEMBER 04, 2018

Applies to:

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

Symptoms

When you connect to OBIEE 12c from SmartView 11.1.2.5.810 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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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