CA Service Management

  • Private Community

  • 1.  Excluding Weekends while calculating days open in CABI Report

    Posted Nov 24, 2017 09:54 AM

    Hello All,

    We have a requirement to pull a report based on the days open for Incident and Request. If days open > 3 and active=1, the ticket should appear in the report. However we also need to apply a trick to exclude saturdays and sundays from the calculation. That simply means if I run the report on Monday, it should not fetch any tickets opened on last thursday and friday as saturday and sunday came in between. Is it poosible to design a such report? Can someone help me with a sample SQL code or operation we need to perform to achieve this.

     

    Thanks

    ArunavaS



  • 2.  Re: Excluding Weekends while calculating days open in CABI Report
    Best Answer

    Broadcom Employee
    Posted Nov 27, 2017 10:42 AM

    The following SAP discussion might get you started:

     

    Working day formula that excludes weekends and holidays in WEBI 

     

    Has anyone else achieved anything similar within BOXI/CABI reports?



  • 3.  Re: Excluding Weekends while calculating days open in CABI Report

    Posted Nov 28, 2017 07:31 AM

    Thanks for the suggestion Paul. The mentioned link helped me to understand the weekend calculation process and I achieved it with the following code:

     

    PdmSeconds(PdmDownTime('BRM','Mon - Fri { 12:00 am - 12:00 am }',cr.open_date,PdmToday()))

     

    I felt it much easier while using CABI library functions to use.

     

    Thanks

    ArunavaS