5 Replies Latest reply: Jun 10, 2010 9:38 AM by kart RSS

    Request chaning/flow in OBIEE Answers?

    778373
      In OBIEE Answers, is it possible to save the value of a request and reuse this value for further
      calculations?

      In other words, I want to use the results of request(s) as the data source for another request.

      The use case is like this:
      1. Use OBIEE Answers to get the value of a metric. There are multiple such metrics. Create one request per metric and save all such requests.
      2. Use the requests saved in step 1 to derive a higher layer of metrics. Save these requests.
      3. Use the requests saved in step 2 to derive a higher layer of metrics. Save these requests.
      And so on.

      Then I want to show these metrics on the dashboard with drill down navigation.

      Appreciate your help.

      Thank you.
        • 1. Re: Request chaning/flow in OBIEE Answers?
          kart
          similar kind of this is possible.

          as they said create a request for each metric and save it.

          now in your final metric calculation you can use the low level meric value as a filter condition.

          go to advanced filter options and select filter based on other request and select the column.

          regards,
          karthick
          • 2. Re: Request chaning/flow in OBIEE Answers?
            Vinodh NK
            Yes, you can do that by using filter based on other request option.

            Please find the below links, on how to use this option.

            http://www.rittmanmead.com/2009/06/03/obiee-and-the-use-of-sub-query/

            http://nerdsofobiee.wordpress.com/2010/03/05/combining-obiee-answer-requests-in-presentation-layer/



            Thanks,
            Vino
            • 3. Re: Request chaning/flow in OBIEE Answers?
              778373
              Hi all,

              Thanks for the reply.
              But this doesn't seem to solve the problem.
              Let me put it in other words:

              Result-1:
              Metric_A X <-- single row resulting from a request in OBIEE Answers

              Result-2:
              Metric_B Y <-- again single row resulting from a request in OBIEE Answers


              Result-3 (to be derived from above two results)
              Metric_C a*X + b*Y

              where a, b are constants.

              and so on...

              Edited by: user2363628 on Jun 10, 2010 2:18 AM
              • 4. Re: Request chaning/flow in OBIEE Answers?
                kart
                then why cant you use the expression you used for X and Y in your last metric directly?

                eg.

                X = sum(col1)
                Y= sum(col2)
                user2363628 wrote:

                Result-3 (to be derived from above two results)
                Metric_C a*X + b*Y
                so Metric_C a*(sum(col1)) + b*(sum(col2))
                • 5. Re: Request chaning/flow in OBIEE Answers?
                  kart
                  But it is not possible to use the result of another request directly in your column expression as you are expecting. you need to go for some work arounds like the above one.