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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.