General OBIEE

Get Involved. Join the Conversation.

Topic

    Will Murphy
    Days on Hold Calculation
    Topic posted June 4, 2016 by Will MurphyBlue Ribbon: 750+ Points, last edited June 4, 2016, tagged OBI Answers, OBIEE Answers, Reports, SQL 
    54 Views, 2 Comments
    Title:
    Days on Hold Calculation
    Summary:
    Need a days on hold formula for Legacy environment
    Content:

    Hello - does anyone happen to have a days on hold formula for OBI in the legacy recruiting environment? 

    Comment

     

    • Kiran Shenvi

      Hi,

      If you are looking for Req. Total Days on Hold then in OBI Recruiting its as below :

      EVALUATE('RL_REQTIMEBETWEEN_FNC(%1,LOCALTIMESTAMP,%2,0,0,0,NULL)' AS DOUBLE,"Requisition Dates"."Req. Creation Date","Requisition Identification"."Req. Identifier")-EVALUATE('RL_REQTIMEBETWEEN_FNC(%1,LOCALTIMESTAMP,%2,1,0,0,NULL)' AS DOUBLE,"Requisition Dates"."Req. Creation Date","Requisition Identification"."Req. Identifier")

      Regards,

      Kiran Shenvi