This discussion is archived
4 Replies Latest reply: Nov 25, 2012 5:53 PM by BIDev RSS

How to navigate from summary report to the dynamical detail report?

BIDev Newbie
Currently Being Moderated
Hi Experts,

How to navigate from summary report to the dynamical detail report?
For example:
In summary report, it contains region,south,quantity,sales1,sales2,sales3 columns,
when customers click sales1, it will navigate to detail report like:
south,quantity,quantity, price,sales1
when customers click sales2, it will navigate to detail report like:
south,quantity,quantity, price,sales2
when customers click sales3, it will navigate to detail report like:
south,quantity,quantity, price,sales3

I do not want to create three detail report, is it possible to judge the dynamical columns(Sales1,Sales2,Sales3) in detail report?
  • 1. Re: How to navigate from summary report to the dynamical detail report?
    Sasi Nagireddy Expert
    Currently Being Moderated
    Hello Kobe,

    Below the URL Gudies you to navigate report to report.

    http://obiee101.blogspot.com/2010/01/obiee-navigating-from-report-to-report.html

    Please Mark Helpful if it sustains your requirement.

    Thanks,
    OBIEELearner.
  • 2. Re: How to navigate from summary report to the dynamical detail report?
    BIDev Newbie
    Currently Being Moderated
    Hi obieelearner ,
    Thanks for your reply.
    Maybe I do not express more clearly.

    Firstly, the Sales1,Sales2,Sales3 is not different,but column.
    The summary report contains five columns,such as
    region,quantitiy,Sales1,Sales2,Sales3 .
    North,7000,10000,8000,20000

    When users click any data in Sales1 column, it will navigate to Sales1 detail report,like:
    region,quantity,price,Sales1
    North,1000,10,10000

    When users click any data in Sales2 column, it will navigate to Sales1 detail report,like:
    region,quantity,price,Sales2
    North,2000,8,8000

    When users click any data in Sales3 column, it will navigate to Sales1 detail report,like:
    region,quantity,price,Sales3
    North,4000,5,20000

    I do not want to create three detail report, is it possible to implement one column to get the dynamical value,such as 'case when'?
    Mainly, I do not know which measure users click .
  • 3. Re: How to navigate from summary report to the dynamical detail report?
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Hi Kobe,

    Since you are using navigation for each Sales1,Sales2 and Sales3, try to pass a unique value (like S1,S2, and S3) to a variable or a place holder for each column so that in your detail report can know the Sales number(1,2, or 3)

    in Your detail report you
    Pull columns region,quantity,price, Sales
    In the last Sales column use expression like
    case
    when variable ='S1' then Sales1
    when variable ='S2' then Sales2
    when variable ='S3' then Sales3
    end

    You may need to little bit tweak it to know the OnClick event on any of the Sales

    If you like this approach pls mark ;)
  • 4. Re: How to navigate from summary report to the dynamical detail report?
    BIDev Newbie
    Currently Being Moderated
    Hi Veeravalli ,

    I am using the BI Content Navigation function, you said you can use variable in column, so I wan to know how to set the variable in measure for judging.
    If it is ok, how to get the click event in reports? Thanks very much...

Legend

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