OBIEE 12c: Behavior Of $-N Syntax In New Calculated Item Differs Between 11g And 12c
(Doc ID 2305432.1)
Last updated on DECEMBER 22, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.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
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