This discussion is archived
5 Replies Latest reply: Jun 10, 2010 2:38 AM by kart RSS

Request chaning/flow in OBIEE Answers?

778373 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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.

Legend

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