Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
An error should occur when saving an analysis that causes incorrect results in CASE WHEN
Chihiro Imaizumi
Rank 1 - Community Starter
Description
Due to the operation of Doc ID 2320983.1 (Bug 18257510), the result is incorrect when using CASE WHEN. I want an error to occur so that CASE WHEN cannot save an analysis that would result in incorrect results.
Specifically, if the column referenced by CASE WHEN is not included in the criteria tab and the result may be incorrect, please raise an error.
reference:
OBIEE 12c: Column with CASE Statement May Return Unexpected Result (Doc ID 2320983.1)
Use Case and Business Need
Due to the operation of Doc ID 2320983.1 (Bug 18257510), the result is incorrect when using CASE WHEN.
Incorrect results are a very serious problem, and I want you to make sure that errors occur so that users do not misuse them and cause incorrect results.
Original Idea Number: 382fb29340
Tagged:
2