OBIEE 12c: Total Values May Not Appear When 'First' Aggregation Rule is Set for Measure
(Doc ID 2573396.1)
Last updated on AUGUST 22, 2019
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On OBIEE 12c:
Total values may not appear in a pivot table or a table view when 'First' aggregation rule is set for measure.
This symptoms may be observed when all of the following conditions are true:
- Using Pivot Table or Table view.
- 'First' Aggregation rule is set for measure.
- Null value cells are present prior to non-null (actual first) value
The 'First' Aggregation rule can be set in a view of an analysis using the More Options menu in the Layout pane:
Example of actual results:
Example of expected results:
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