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 laterBusiness 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.
- "Time"."Per Name Year"
- "Base Facts"."Revenue"
- CASE WHEN "Products"."LOB" = 'Games' THEN "Base Facts"."Revenue" ELSE 0 END
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 |