Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Able to Export Dashboard to Excel by Prompted Link or Go URL

Submitted
11
Views
3
Comments
Swee Eng Khor
Swee Eng Khor Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

INTEL

Description

We have created an SR on this, SR 3-22999163921 : BI Dashboard Url to directly download as Excel and it is mentioning this is not supported althrough Oracle Documentation mentioned it can be done.

According to the documentation, Prompted Link feature enables to download a dashboard to Excel.

  - Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition
    What Are Prompted Links?

When trying to execute a prompted link to download a dashboard to Excel by following the basic syntax of the prompted link, the specified dashboard will be rendered, but will not be downloaded to Excel.

Go URL command provides export of an analysis to Excel. However it cannot export a dashboard to Excel.

Use Case and Business Need

Able to have a button with the URL to directly download the excel file.

We would like to create a button and add in the PD page with the download url to ease the user experience

Original Idea Number: 6029fb68f9

1
Up
1 votes

Submitted · Last Updated

Comments

  • SantoshKumarBhairi
    SantoshKumarBhairi Rank 6 - Analytics Lead

    see if this works:

    add text box and embed this code:

    <a href="javascript:void(null)" onclick="return saw.dashboard.exportToExcel('@{dashboard.path}', '@{dashboard.currentPage}', false);">Export Dashboard</a>

    for more info, check this https://cloudcustomerconnect.oracle.com/posts/8e4ef1fc6a?commentId=282709#282709

  • Swee Eng Khor
    Swee Eng Khor Rank 1 - Community Starter

    This is to directly embed into the BIP dashboard page, and in the dashboard, there is already a action to export the dash board. We are looking at the Item Page with a button link do directly download the excel without launching the dashboard.

  • Swee Eng Khor
    Swee Eng Khor Rank 1 - Community Starter

    This is to directly embed into the BIP dashboard page, and in the dashboard, there is already a action to export the dash board. We are looking at the Item Page with a button link do directly download the excel without launching the dashboard.