Oracle Transactional Business Intelligence

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

Export to Excel in OTBI Dashboard

Received Response
1074
Views
3
Comments

Summary:

How to export all pages in a table analysis within a dashboard

Content (required):

We have developed a OTBI dashboard which contains a table based analysis. User wants to export all the rows in the analysis but whenever we do "export to excel" --> "export entire dashboard". it only exports the current display page in the table and not the entire analysis. How can I setup my dashboard such that it exports all the rows in the analysis just the way we export directly from analysis.

Version (include the version you are using, if applicable):

22D

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 8 - Analytics Strategist

    Hi @Ankit.Mahajan

    Probably you need to enable the download data options for that Report in the Dashboard Page.

    Please find below steps.

    Edit the Dashboard Page --> Go to the Section where the Report exists

    Click on ‘XYZ’ as highlighted below.

     Click on ‘Report Links’.


     Click on ‘Customize’ and then select ‘Export’

     


     Save the Page.

    Execute the Dashboard. Now the following ('Export') should be available at the bottom of page.


     Hope this help.

    Cheers,

  • Rank 1 - Community Starter

    Awesome.

    Thanks a lot, it worked. I was looking into all the options but somehow missed report links.

    Appreciate your help!!

  • Rank 8 - Analytics Strategist

    Hi @Ankit.Mahajan

    Glad it worked & solved your problem.

    Would you mind accepting the answer that solve your issue? It'll help the fellow community members in future.

    Thank You.

    Cheers,

Welcome!

It looks like you're new here. Sign in or register to get started.