OBIEE 12c : Incorrect Totals And Subtotal for a TODATE Based Measure When Applying Filter Is Not Null On Another Measure Column
(Doc ID 2361157.1)
Last updated on JULY 17, 2021
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On Oracle Business Intelligence Enterprise Edition (OBIEE) 126.96.36.199.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.
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