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 MARCH 31, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.160419 and later
Information 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

Cause

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