Option To Include NULL Values In Answers Is Not Working As Expected (Doc ID 2065112.1)

Last updated on JUNE 05, 2016

Applies to:

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

Symptoms

Option to include NULL values in answers is not working as expected


You have an analysis which has hierarchies involved. When there is no data in the back end fact table then the hierarchy members will not show up in the analysis.
You tried enabling the option to "Include NULL values" under Data tab of Analysis properties in Analytics. After enabling this option, the analysis returns NULL values for all the existing hierarchy members.

Cause

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 hundreds of Community platforms