1 Reply Latest reply on Jan 15, 2013 8:43 PM by SriniVEERAVALLI

    OBIEE 11 measures

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