OBIEE 11g: Custom Numeric Format M for Millions is not Exported to Excel
Last updated on FEBRUARY 08, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 and later
Business Intelligence Server Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
If you use the following custom format in a numeric column
then the value 2500000 has the expected format 2.5M. When you export the Analytics results to Excel 2007 then the custom format is not retained.
In stand-alone Excel, the format required is:
to display 2.5M for the numeric value 2500000. But this custom format with M in quotes in OBIEE gives a parser exception error when exported to Excel.
However, the format
In comparison the OBIEE custom format
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