Month Ago Function Returns Incorrect Values in OBIEE 11g (Doc ID 1352535.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
***Checked for relevance on 06-Nov-2013***

Symptoms

Month ago function was used in an OBI 10G report and the report shows the values correctly.
After migration to 11.1.1.5  the same report shows the values incorrectly: The value returned for the month ago column does not match the value from the base measure for the previous month.

Changes

Upgrade to 11.1.1.5.

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