My Oracle Support Banner

OBIEE 12c: Is There a Way to Enable "Include Null values" Option Even When Using UNION to Join Two Subject Areas? (Doc ID 2415327.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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


When creating an analysis from 2 subject areas using UNION operator, the option to tick mark "Include Null Values" under: Criteria >Analysis properties > Data tab, is disabled. 

The similar symptom happens in following features:

Results tab > Edit Analysis Properties >
- "Include rows with only Null values"
- "Include columns with only Null values"

Is there a way to enable this "Include Null values" option even when using 2 or more subject areas?


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

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