OBIEE 12.2.1.3 export to excel, alignment missing (not looking like as in report)

Joe_obieeoas

Hi Gurus,

Our user ran a report and exported result to excel, once he opened and looked into the export excel, noticed lot of alignment missing compared to the report output viewed on browser page.

Please note here report output has some word headings as well in the body (you can imagine for example a paystub which has many columns in the left side, center and to the right side of page)

If he tried exporting to (.mht) format, it looks as expected but have to change lot of agents.

Can you please throw some suggestions how to fix these misalignments in excel itself..

Thanks in advance.

[Deleted User]

When you say "report" do you really mean a BI Publisher "report" object or are you taling about an Answers "analysis"? Words have meaning and precision is important!

A "report" made with BI Publisher is explicitly geared towards pixel perfect reporting for exact output in physical form or Excel output etc. Hence the name "Publisher".

An "analysis" is made for on-screen consumption and when exported will be adjusted as its primary goal is to visualize data and at export, serve numbers. Its primary goal isn't to be pixel perfect and it nexer will be pixer perfect. That's what BI Publisher is for.

For this reason, OBIEE comes with both options at your disposal and it's just a question of what you choose yourself to serve which purpose.

So you have an issue when your "report" is really a BI Publisher "report" and it's not outputting the correct format. If you're using an analysis and the output is slightly different, then this is normal behaviour. It's about the right tool for the right job.

Joe_obieeoas

Thanks Chris. Its an "analysis", not a report.