OBIEE 11g: The Sort Order in an Analysis is not Implemented When it is Used in an 'is based on results of another analysis' Filter (Doc ID 2076864.1)

Last updated on NOVEMBER 18, 2015

Applies to:

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

Symptoms

Consider a simple testcase with 2 Analyses as below:

Analysis1: This returns the "top" Products where the RSUM Revenue is > 75% of the TOTAL Revenue
   Criteria columns include: Revenue, RSUM, Product Number, Top Products
       Revenue has an explicit Sort Ascending specified
       RSUM has a column formula like: RSUM(Revenue)
       Top Products has a column formula like: CASE WHEN 100*(RSUM(Revenue)/SUM(Revenue)) > 75 THEN Product Number END

Analysis2: This returns results for the "top" Products, as determined by Analysis1
   Criteria columns include: Product Number
      Product Number has a Filter with:
          Operator: is based on results of another analysis
          Saved Analysis: Analysis1
          Relationship: is equal to any
          Use values in Column: Top Products

When Analysis1 is executed, you see 3 values for Top Products: 3, 4, 19

When Analysis2 is executed, you see 5 values for Product Number: 16, 17, 18, 19, 20

Analysis2 returns incorrect results as it is not being filtered "correctly" (based on the results of Analysis1).

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