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

book

Article ID: 36433

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS 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>

All_Tickets3.jpg

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

   

<Please see attached file for image>

Current_Week3.jpg

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

   

<Please see attached file for image>

Week_Open_Date_Only3.jpg

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

   

<Please see attached file for image>

Last_Week3.jpg

   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>

Last_Week_Tickets3.jpg

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:

Attachments

1558722399923000036433_sktwi1f5rjvs16wfg.jpeg get_app
1558722398101000036433_sktwi1f5rjvs16wff.jpeg get_app
1558722396166000036433_sktwi1f5rjvs16wfe.jpeg get_app
1558722394284000036433_sktwi1f5rjvs16wfd.jpeg get_app
1558722392154000036433_sktwi1f5rjvs16wfc.jpeg get_app