大量电子OBIEE报告

Question

当我试图查看数据模型中的数据时，它看起来非常好。

589062382

12075132

https://ibb.co/TLrDWgS

但当我试图查看报告时，报告中出现了大量数据'E‘。

5.89062382E8
1.207513E2

https://ibb.co/ZmDWJvV

如何避免这种情况？

下面是我用来创建报告的步骤。

Datamodel -> Create Report ->

Select Data 
        Create Report Using Existing data model
        Guide Me
Select Layout
            Potrait
            Table
Create Table
                Drag and Dropped Columns
Save Report 

Answer 1

如果使用TO_CHAR将数字转换为字符串，则会显示整个数字。如果你愿意，你甚至可以用逗号等来格式化它。

示例查询

WITH n AS (SELECT 123456789123456789 AS num FROM DUAL)
SELECT num                                                AS with_e,
       TO_CHAR (num)                                      AS as_string,
       TO_CHAR (num, 'FM$999,999,999,999,999,999.00')     AS formatted_string
  FROM n;

示例结果

               WITH_E             AS_STRING               FORMATTED_STRING
_____________________ _____________________ ______________________________
  1.23456789123457E17 123456789123456789    $123,456,789,123,456,789.00