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

View Selector Export

#Mayur

Hello Guys,

OBIEE version: 11.1.1.9.0.

I have created analysis which contains view selector (View Selector contains 10 views).

View selector is placed on dashboard without any dashboard filter.

I am trying to export them in different tab of Excel.

Anyone please help on this? How to export the all 10 views in 10 different excel tabs?

Thank you,

Best Regards,

#Mayur

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

What you wish for is simply not how the tool works. It is not an Excel dump tool. The tool which is more geared towards exports is BI Publisher. Any dashboard can be fitted eith a custom print layout.

https://docs.oracle.com/middleware/bi12214/biee/BIEUG/GUID-C2A13986-0BC2-4083-8075-C6EB2522858D.htm#GUID-C7610312-8B5E-4…

#Mayur

Thanks Christian for your reply.

I have achieved it using the JavaScript code.

I have added the JavaScript code in the Dashboard and mentioned the path which I have to extract.

JavaScript Code is like below,

<a href="javascript:void(null)" onclick="return saw.dashboard.exportToExcel('<Report_Catalog_path>', true);"><center>Export</Center></a>

It is working fine as Expected.

Thanks

Best Regards,

#Mayur

3263470

Mayur, We are trying to achieve same thinng, can you please provide exact format of Catalog Path.

Thanks

Viresh

#Mayur

Hi Viresh,

Add the dashboard catalog path like,

'\shared folder\dashboard_folder\Dashboard_Name'

Hope this will help.

Thanks.

Best Regards,

#Mayur

3263470

Thanks but it did not work for me, tried all different possibility..we are on 12c.

#Mayur

Hi Viresh,

It's working in OBIEE version: 11.1.1.9.0.

Not sure about 12c.

Thanks.

Best Regards,

#Mayur

Gianni Ceresa

You have the export to Excel of the whole dashboard in the menu (assuming you have the privileges required). Look at the code it has behind and do the same.

A lot changed in 12c compared to 11g in the front-end JS, don't expect a code of 11g to work the same in 12c.