My Oracle Support Banner

Obiee 12c - Analysis Results Are Wrong After Upgrading From 11g To 12c Due To Excluded/Hidden Columns (Doc ID 2526556.1)

Last updated on AUGUST 15, 2019

Applies to:

Business Intelligence Answers Option - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

When there are excluded / hidden columns in the dashboard or report, the analysis in 12c is forming different physical query and showing totally different results when compared to 11g. The database results for OBIEE 11g and 12c are same  in the DB, but the query formation is 12c is different when excluded / hidden columns are present in the analysis. The column with the incorrect results contains a Case statement.

Oracle Business Intelligence Product Version 12.2.1.4.0
Found 2 reports where this is occurring.

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


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