My Oracle Support Banner

OBIEE 12c: Custom Numeric Format Measure Showing As Text While Exporting To Excel 2007+ (Doc ID 2453654.1)

Last updated on OCTOBER 11, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

On:Oracle Business Intelligence Enterprise Edition

The Issue can be reproduced by following the below steps :

1) Create sample report with Fact and dimension table (example: Product Number, Actual Unit price and Avg Order Size)

2) Edit the measure column (Eg: Avg Order Size)

3) Apply Override Default Data Format for Measure
       a) Treat Numbers: Custom
       b) Custom Numeric Format: #,#0.0;#,#0.0;0

4) Save it

5) Export to Excel 2007+

6) The format of the numeric field is getting converted to text field

 

Changes

 Upgraded from Obiee 11.1.1.9.5 to 12.2.1.2.0

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.