0 Replies Latest reply: Feb 22, 2013 3:24 AM by 977558 RSS

    OBIEE- Calculating Min and Max Values

    977558
      Hi Friends,

      I have an Issue with regards to calculating Min/Max Values.

      In my Data base we dont have Message Count. So we created a Logical column in BMM Layer called "Message Count" based on the column "Out/In No" i.e by creating count of it i.e (Count(out/in no)) in BMM

      To calculate Inbound Messages we writing -- filter(Message count using messagetype ='i') at report level
      To calculate Outbound Messages we writing -- filter(Message count using messagetype ='o') at report Level
      To calculate Total Messages we writing----- "Message Count".

      But Now we had an issue to calculate "Min Inbound/Max Inbound/Min Outbound/Max Outbound/Avg In/Avg Out" types of Messages.
      To make it clear definition for MIN and MAx is Like This.

      Say Ravi received(Inbound) messages      2
      Say Roy received(Inbound) messages      5
      Say Kiran received(Inbound) messages   11 on a particular date.

      So for that particular date Min Inbound is 2
      So for that particular date Max Inbound is 11
      and Avg Inbound will be (2+5+11)/3

      On this basis we have to implement it in OBIEE. For any more clarifications please reply to my thread.

      Please reply to my Issue ASAP as it is critical and I am out of time.

      Thanks in Advance.

      Regards