Option To Include NULL Values In Answers Is Not Working As Expected
Last updated on JUNE 05, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.141014 and later
Information in this document applies to any platform.
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.
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