HTML table inside OBIEE table column results into multiple tabs in Excel 2007+ export

Aman Singhai

Hi,

I am using HTML table as Column Value in DDR report

E.g.:

SELECT
'!!!!' as id,
1 as SEQ,
1 as SEQ2,
'<table bgcolor="#FFCC99" style="width:100%; height:100%;"><tr><td>Title</td></tr></table>' as "Column Name",
'<table bgcolor="#FFCC99" style="width:100%; height:100%;"><tr><td>Report Name</td></tr></table>' as Value,
'<table bgcolor="#FFCC99" style="width:100%; height:100%;"><tr><td><font color="#FFCC99">-</font></td></tr></table>' as Result
from
Dual

UNION ALL

SELECT
'!!!!' as id,
2 as SEQ,
1 as SEQ2,
'<table bgcolor="#FFCC99" style="width:100%; height:100%;"><tr><td>Time</td></tr></table>' as "Column Name",
'<table bgcolor="#FFCC99" style="width:100%; height:100%;"><tr><td>'||to_char(sysdate,'DD-Mon-YYYY HH12:MM:SS AM')||'</td></tr></table>' as Value,
'<table bgcolor="#FFCC99" style="width:100%; height:100%;"><tr><td><font color="#FFCC99">-</font></td></tr></table>' as Result
from
Dual

I changed the column's data format to HTML.

This is working fine in OBIEE and Export to Excel 2003, but when I am exporting it to Excel 2007+ same table is coming in multiple parts in different tabs.

OBIEE Version: 11.1.1.7.141014

Any idea, how to fix this?

Thanks,

Aman Singhai

3266027

Hi Aman,

Did you get resolution for this ? Recently even I am facing same issue.

Thanks,

Nimit Kumar