How do you use the CA Business Intelligence (CABI) Week() Function to filter tickets opened in the past week

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Introduction 

Currently there is no CA Service Desk Manager (CA SDM) PDM function that can be used to filter CA SDM tickets opened in the past week.

This document explains how to use the CABI WEBI built-in function Week() for this purpose.

Question

How do you use the CA Business Intelligence (CABI) Week() Function to filter tickets opened in the past week

Environment

CA Service Desk Manager 2.x with CABI 3.X

CA Service Desk Manager 14.1 with CABI 4.X

Answer

1. Run the CABI WEBI report to return results. Make sure that the field "Open Date" is included in the report.

   

<Please see attached file for image>

2. Create a variable called "Current Week" defined as "=Week(CurrentDate())" 

   

<Please see attached file for image>

3. Create a variable called "Week Open Date Only" defined as "=Week([Open Date])"

   

<Please see attached file for image>

4. Create a variable called "Last Week" defined as "=([Week Open Date Only]-[Current Week])".

   

<Please see attached file for image>

   5. Apply the "Last Week" filter to the WEBI report and choose its value as '-1'.  The resultant results will show 

    the CA SDM tickets opened since last week.

   

<Please see attached file for image>

Additional Information:

By choosing different values in Step #5, other weeks reports can be generated. For example, choosing a value of '0' will result in CA SDM tickets opened during the current week.

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: