Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
24
Views
2
Comments
Joe_obieeoas
Joe_obieeoas Rank 5 - Community Champion
edited Aug 13, 2024 4:58PM in Oracle Analytics Cloud and Server

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Joe_obieeoas Rank 5 - Community Champion

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