My Oracle Support Banner

OBIEE 12c : Column with CASE Statement May Return Unexpected Result (Doc ID 2320983.1)

Last updated on DECEMBER 06, 2018

Applies to:

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

Goal

Column with CASE Statement may return 0(zero) or unexpected result.

Create an analysis with CASE statement as following.



In this case, the case statement refer to column:"Products"."LOB", is not specified in criteria of analysis. Then the case statement may return zero unexpectedly. 

Solution

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
Goal
Solution


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