OBIEE 12c: Behavior Of $-N Syntax In New Calculated Item Differs Between 11g And 12c

(Doc ID 2305432.1)

Last updated on OCTOBER 06, 2017

Applies to:

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

Symptoms

When you set $-N(e.g. "$-1 - $-2") in New Calculated Item, the results displayed differ between 11g and 12c.

    ref:
    Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition
    New Calculated Item dialog
    Function

 

In this test case;
1) Data exists only until 2002/1.
2) At 11g, there is no data from 2002/2, so the result is 2001/2 - 2000/2 at Previous year difference.
    At 12c, even though there is no data after 2002/2, it seems to be calculated like 2002/2(data is "0") - 2001/2 at Previous year difference.

Setting:

     

Result of 11g:

     

Result of 12c:

    

 

Changes

 Upgrade from 11g to 12c

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