Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dashboard with multiple BI Publisher reports export to excel is blank is there any solution on it?
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.
Answers
-
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
_xfparameter 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-F45046D316842 -
The functionality is not currently supported in the application.
1 -
Ok...Thanks for the reply.
0 -
Thanks
0 -
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.
0 -
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
0 -
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?
0
