This discussion is archived
1 Reply Latest reply: Jun 3, 2013 2:36 AM by KNYadav RSS

Clicking 'return' after drill down refreshes whole page ?

exel_cs Newbie
Currently Being Moderated
Hello All

I have created a simple dashboard with one page called 'Analysis'.

On this analysis page i have included 2 reports both of whcih use drill downs :

Report 1 - Sales by Time (Year- Quarter- Month- Week - Date )

Report 2 - Sales by Industrial Class (Industrial Class - Group - Customer)

For example :

Drilling DOWN from year to quarter > month > week >date on report 1 is ok .

However to drill back UP from date *(Lowest Level)* to year *(Highest Level)* you have to click on the return link. By doing this the whole page refreshes therefore in turn refreshing both report 1 and report 2


Is there an way around this so the whole page does not refresh , but instead only refreshing the report the drill down is used on


Please could you suggest any solutions

Many thanks

Edited by: exel_cs on 23-May-2013 07:09

Edited by: exel_cs on 23-May-2013 07:11

Edited by: exel_cs on 03-Jun-2013 02:18
  • 1. Re: Clicking 'return' after drill down refreshes whole page ?
    KNYadav Explorer
    Currently Being Moderated
    Two possible ways,

    1. If you are using OBIEE 11g, use Hierarchy Columns to create your report. In this way you can see information from Top level to lowest level without navigating anywhere and without refreshing your page. Refer below link for more information;

    http://www.rittmanmead.com/2010/07/obiee-11gr1-hierarchical-columns-and-enhancements-to-pivot-table-views/
    http://www.rittmanmead.com/2010/10/oracle-bi-ee-11g-navigation-passing-parameters-using-hierarchical-columns/

    2. If you are using 10g, Open the target (after navigating from base report) report on new window. (No need to click go back, close the window which is not required ;) )

    Mark correct/helpful if it helps.

    Thanks,
    Kashi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points