4 Replies Latest reply: Nov 25, 2012 7:53 PM by BIDev RSS

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

    BIDev
      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
          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
            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
              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
                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...