This discussion is archived
1 Reply Latest reply: Jan 15, 2013 12:43 PM by Srini VEERAVALLI RSS

OBIEE 11 measures

JuMae Newbie
Currently Being Moderated
How does OBIEE handle one-to-many joins in measures? Ex. I have 2 Fact tables (event and participant) where 1 "event" can have 0 or many "participants". When an event has more than 1 participant my measures are inflated.
so I have a measure in the event fact that gives me a time difference in days. So for 1 event the measure is 5 days. However, this event is tied to 3 particpant fact records. So my "total difference" is reflected as 15 days, when really it is still just 5
so 5 days is the correct answer, but obiee gives me 15. is there something special we typically do to handle this?


Please Advise
  • 1. Re: OBIEE 11 measures
    Srini VEERAVALLI Guru
    Currently Being Moderated
    I would say its rpd development issue. To see where its going wrong; I would suggest to write a manual sql query to get 5 and compare the same query with bi generated physical query which results 15.

    That would answer your question.

    Let me know if needed.

    Edited by: Srini VEERAVALLI on Jan 15, 2013 2:43 PM

Legend

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