OBIEE 12c : Incorrect Totals And Subtotal for a TODATE Based Measure When Applying Filter Is Not Null On Another Measure Column
Last updated on JUNE 27, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On Oracle Business Intelligence Enterprise Edition (OBIEE) 188.8.131.52.0 version, Analytics
- Totals and subtotal are calculating incorrect results when a applying a filter in the criteria as measure is not null
- When there is a filter applied in the criteria that a measure (say - Revenue) is not null, then the Grand Total and Sub-Total calculation for a Period Rolling Measure is incorrect.
- When the filter is removed, then the calculation of Grand Total and Sub-Total are correct for the Period Rolling Measure.
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