My Oracle Support Banner

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 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

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


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