My Oracle Support Banner

OBIEE 12c: Union Analysis with Operator "is ranked first" may Return Unexpected Result (Doc ID 2454242.1)

Last updated on APRIL 15, 2021

Applies to:

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

Symptoms

Union analysis with Operator "is ranked first" may return Unexpected Result.

This symptom can be reproduced by steps below:

 

1. Create 2 analysis with Operator "is ranked first" as following.

Analysis 1:

 

        Product Type is equal to / is in Cell Phones; Fixed
        AND Per Name Year is ranked first 1

 

2.  Combine Result based on Union ,intersection and difference operations 

 

        Product Type is equal to / is in Audio; Camera
        AND Per Name Year is ranked first 1

 

3. Union analysis was created as following.

     

     In this case, the Column referenced by Operator "is ranked first":"Time"."Per Name Year", is not specified in criteria of analysis.

      

 

     Then the Operator "is ranked first" may return total values unexpectedly.

             Unexpected Result                                                                                                                                                 Excepted Result

                                                                                                   

      

Changes

 Upgrade from 11g to 12c.

Cause

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
Symptoms
Changes
Cause
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.