OBIEE 12c: Behavior Of $-N Syntax In New Calculated Item Differs Between 11g And 12c
Last updated on OCTOBER 06, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
When you set $-N(e.g. "$-1 - $-2") in New Calculated Item, the results displayed differ between 11g and 12c.
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition
New Calculated Item dialog
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.
Result of 11g:
Result of 12c:
Upgrade from 11g to 12c
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