nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Dashboard with multiple BI Publisher reports export to excel is blank is there any solution on it?

User_SXVU3

When using the Export entire workbook to excel, the exported excel sheet creates all the correct worksheet pages and headings however, the data is blank.

Each report can be exported to excel individually however, when we export to excel the entire dashboard the data does not export.

Find more posts tagged with

BI Publisher Report Templates

Accepted answers

All comments

Federico Venturin - Oracle

Hi @User_SXVU3 ,

Unfortunately, this is the expected behaviour.

As an alternative, you can a) replace Publisher reports with analyses, or b) add a link near each Publisher report, so users can click on it to download the report in the desired format.

Please refer to this page to create the links to your Publisher reports (you have to use the _xf parameter in the URL to specify the output format): https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/access-reports-url.html#GUID-F788B306-99F6-432E-BCD5-F45046D31684

RanaAshutosh-Oracle

The functionality is not currently supported in the application.

User_SXVU3

https://community.oracle.com/products/oracleanalytics/discussion/comment/50440#Comment_50440

Ok...Thanks for the reply.

User_SXVU3

https://community.oracle.com/products/oracleanalytics/discussion/comment/50439#Comment_50439

Thanks

Federico Venturin - Oracle

Hi @User_SXVU3 ,

You're welcome!

If you are happy with the proposed solutions, would you mind to mark my comment and @RanaAshutosh-Oracle's one as the answers? In this way other people with the same issue can easily find them.

User_SXVU3

https://community.oracle.com/products/oracleanalytics/discussion/comment/50447#Comment_50447

Your Publisher reports with analyses is working, but if we take two title box side by side and export it in excel then , the space between them(design time) is consider as a seperate cell in the excel , but data is populated

Federico Venturin - Oracle

Hi @User_SXVU3 ,

Can you please share a screenshot of how the analyses look in the dashboard and another one with the issue in Excel?