My Oracle Support Banner

OBIEE 12c: Why are Values with Full Precision E​xported to Excel? (Doc ID 2528978.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 to 12.2.1.4.0 [Release 11g to 12g]
Oracle Analytics Cloud
Information in this document applies to any platform.

Goal

We have the analysis whose column is using 'Decimal Places' of 'Data Format' in the Column Properties.

ex)

 


When opening this analysis, the formatted values are displayed as follows:

 

But when exporting this analysis to "Excel 2007 +", the data with all precision can be seen.
In this case, customer can see 711387.2736 instead of formatted value 711387.27.



Why?

Solution

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