Export to Excel in OTBI Dashboard

Ankit.Mahajan

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):

Bhaskar Konar

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,

Ankit.Mahajan

Awesome.

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

Appreciate your help!!

Bhaskar Konar

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,