OBIEE 11g Aggregate function (like Count) on the column’s Aggregate Rule selection in pivot view is not displaying thousand separator
(Doc ID 2250596.1)
Last updated on FEBRUARY 13, 2019
Applies to:
Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.160419 and laterInformation in this document applies to any platform.
Symptoms
Customer reported the issue with thousand separator using the Pivot table in the report, if that column (and report) is from Logical Dimension table and aggregated in pivot view – even ‘Use 1000’s Separator’ check box is selected in the column properties
Changed the datatype to other than Integer eg., Double, Char Apply the aggregate function (like Count) on the column’s Aggregate Rule selection in pivot view Run the report. Then pivot table is not displaying thousand separator If I apply aggregate function in the column formula section in the Criteria tab with default selection in column’s Aggregate Rule in pivot view, then pivot table is displaying thousand separator
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |