Hi.

We have OBIEE 12.2.1.4

Yesterday we've faced an interesting issue. When our user tried to export analysis to Excel 2007 format he got zero-length file. We checked and got the same result. After some investigations we found that one field(varchar2) in one table has value 1025201636877.

We tried

1) To create New Bussines model with one logical table and one logical column with value 1025201636877. Then Drag and dropp to Pres layer, create analysis with one this field and to export to Excel 2007. We got ... Zero-length file

2) To change formula in this and another model and add this string instead of Members.

Export to Excel - Zero-length file.

Pdf and others works without problem