Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How to enable Export options underneath or on each metrics added in one analysis

Received Response
3
Views
6
Comments
Ruvina Khan
Ruvina Khan Rank 5 - Community Champion
in Oracle Transactional Business Intelligence

I have created a analysis that has a compound layout i.e. multiple metric are there. Now, I want to have the export feature on all the metrices rather than one single export at the bottom of the analysis when i go in the preview mode and not in the edit mode.

What am trying to achieve is, suppose i have columns like person name, number, total person who completed a task and total person who doesn't complete a task. So, i the tabular format the last 2 columns will either show 1 or 0 and in the pie or any other type it shows the total or percentage. Now, I want whatever section i select on the pie, it shows me the data behind that and not the complete export of that analysis.

Is it possible to achieve it in OTBI

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi Ruvina,

    Yes that is what the report links do out of the box. If you have an analysis with in your results a layout with multiple views, for example a table view and a chart view, then when you view that analysis layout on a page, the report links to export "Formatted" at the bottom of that analysis on that page will export all the views on that layout in your analysis.

    If you want to have a link underneath each of multiple views then you will need to create multiple layouts in your analysis each with a different view then add your analysis to your page multiple times each time selecting a different layout rather than the default layout.

    For example

    default layout with 2 views and 2 layouts each with 1 view

    Alternative you can user Page Options to Print or Export to get all analysis on that page

  • Ruvina Khan
    Ruvina Khan Rank 5 - Community Champion

    Hi @Nathan CCC ,

    Thanks for the response.

    I don't want to pull it over a page or dashboard. Is there a way to have it on the analysis level only?

    Thanks,

    Ruvina

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi, Your design should be for your users to be using dashboards to interact with analytics and reports in OTBI.

  • Ruvina Khan
    Ruvina Khan Rank 5 - Community Champion

    Hi @Nathan CCC,

    Yes, I agree with that but this analysis which we are developing is not that large that we would need a full dashboard for this. We prefer using the dashboard if we have multiple pages needed. It is just 1 analysis with around 4 metrices within it.

    So, just trying to explore if we have any functionality within it to get export there inside the analysis only.

    Thanks, for your help

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi, You can create a dashboard with one page just with 1 analysis on it. That is ok.

  • Ruvina Khan
    Ruvina Khan Rank 5 - Community Champion

    Thanks for the suggestion,@Nathan CCC