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 Export to Excel

Received Response
2
Views
5
Comments
user1738691
user1738691 Rank 1 - Community Starter
edited Aug 13, 2024 5:18PM in Oracle Analytics Cloud and Server

I have a table displayed on a dashboard. The business prefers the "Fixed headers with scrolling content" option for the table over "Content paging" because the column headings are not visible upon scroll-down when using the Content Paging option. However, when a table set to Fixed Headers is exported to excel, only that portion of the table displayed on the dashboard is exported to excel. The business needs the entire table to export. Is there a solution for this?

Answers

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

    Please read this and have the courtesy of spending a bit more time than the 30 seconds it takes to type out the phrases above if you expect other people to spend a lot of time solving your problem in the job you're being paid for...for free. Courtesy is still a thing. Thanks.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Do you have the Print Rows Option for the view set to "All"?

    pastedImage_0.png

  • user1738691
    user1738691 Rank 1 - Community Starter

    Hi Jerry.  Good grief, I had it set to All on the view, but not on the dashboard. That is all it took.  Thanks so much!!

  • user1738691
    user1738691 Rank 1 - Community Starter

    I felt the question was fairly straightforward and didn't require additional detail. Another (courteous) responder was able to comprehend it and answer it quickly, but nonetheless thanks for your response.  "Courtesy is still a thing."  Great advice, perhaps we ALL need to consider it.

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

    Sarcasm seems to get lost in text too it seems.