My Oracle Support Banner

OBIEE 11g: OBIEE Analyses Does Not Display Measure Values Without Filters (Doc ID 2472517.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Goal

OBIEE Analyses does not display measure values when there are no filters defined in the report.

Example :

created a simple Analysis in OBIEE with two dimension columns , "Campaign Name" and "Email Name", and two measure columns "Total Delivered" and "Unique Opens". 

The issue is that OBIEE returns data with some values missing for "Total Delivered"

If we add an extra filter of "Email Name" on those specific email names that have missing "Total Delivered" values, then the Analysis will return the data without missing value on that email names.


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!


In this Document
Goal
Solution
References


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