My Oracle Support Banner

Column with CASE Statement May Return Unexpected Result (Doc ID 2320983.1)

Last updated on APRIL 08, 2024

Applies to:

Oracle Analytics Cloud - Version March 2023 and later
Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
Oracle Analytics Server - Version 2023 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.