4 Replies Latest reply: Apr 2, 2013 10:34 PM by nk54 RSS

    How to Model the Latest Relation in 1:M Relationship in OBIEE?

    893032
      Hi all,
      We have one to many relationship in our oltp system. Let's suppose one service request and many service request activities.

      For service request activities there are huge data.

      One requirement is user wants to see the only latest activity of the request and analysis it with service request together. What's the best practice to modeling this kind of requirement?

      Currently I have a fact table which hold the service request activities data, and service request will he the dimension. One way I can figure out is I can set a flag for the latest activity daily bases which will be used to filter out other records. But because the service request activities fact is huge volume data. There may be performance issue.

      Thanks.
      Alvin