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 27, 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

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?

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!


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