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 laterInformation 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.0Found 2 reports where this is occurring.