CA Service Management

Thank you for raising it Tammy.

I just submitted an 'idea' for this --- please vote!

https://communities.ca.com/ideas/235713700

That is true Tammy.   All in all PdmToday should be expanded from product functionality aspect for both Last Quarter (The True Last Quarter) and Last Week (The true Last week).  Maybe this is something that can be voted on by other folks in the community as well via a new Idea?

_R

Hi Raghu,

I'll pass along the information to Joyce, who does our reporting.  But the suggestion for 'Last Week' sounds like you'd have to have a formula for every field on the report (which can be many), rather than a filter for the entire report.  So I don't that's going to be practical for us to do.

Tammy

Tammy,

LAST_WEEK: Maybe this would help for WEBI Reports: Is there a way to report against Last Full Week's data in CA Service Desk Manager (CA SDM) using CA Business Intelligence (CABI) reports?

Out of the box CA SDM Universe in CABI exposes filters like Last 30 days, Last 7 days etc.,  but there is no direct option to report against the real Last Week. This document shows a way to expose this functionality over a Web Intelligence (WEBI) Report.

Take an example of a WEBI report, which has Open Date and Ref Num fields from Incident Details class of the CA SDM Universe.

Click on Open Date field on the right hand pane and then add this formula:

    =If [Open Date] <= RelativeDate(LastDayOfWeek(CurrentDate()); -7)

    And [Open Date] >= RelativeDate(LastDayOfWeek(CurrentDate());-13)

    Then [Open Date]

Then click on Ref Num field on the right hand pane and then add this formula:

    =If [Open Date] <= RelativeDate(LastDayOfWeek(CurrentDate()); -7)

    And [Open Date] >= RelativeDate(LastDayOfWeek(CurrentDate());-13)

    Then [Ref Num]

Now it should only show the Open Date and Ref Num of data for the real Last Week.

NOTE:

The significance of -13 and -7 are explained below. You could tweak the numbers to adjust to last week or last minus 2 week or last minus 3 week etc.,

RelativeDate(LastDayOfWeek([Field1]);-13) --> Start of Day of Last week's first day

RelativeDate(LastDayOfWeek([Field2]);-7) --> End of Day of Last week's last day

LAST_QUARTER

I don't think we have an easy one around this yet.   Maybe something like above needs to be written as a combination of WEBI Formula + Universe Filter  unless anyone have other ideas.

If its a defined approach (ex: 1st Quarter,  2nd Quarter etc.)  we have it documented in the CA Business Intelligence for CA Service Desk Manager   Chapter 15.

/* Sample start date ranges for testing in pdm_isql */

SELECT ref_num,

PdmToday(-1,-1) AS Yesterday_Start,

PdmToday(-1,1) AS MonthToDate_Start,

PdmToday(-1,1,-1) AS PreviousMonth_Start,

PdmToday(-1,1,1) AS FirstQuarter_Start,

PdmToday(-1,1,4,-1) AS LastYrSecondQuarter_Start

FROM in;

/* Sample end date ranges for testing in pdm_isql */

select ref_num,

PdmToday(1,-1) AS Yesterday_End,

PdmToday() AS MonthToDate_End,

PdmToday(1,31,-1) AS PreviousMonth_End,

PdmToday(1,31,3) AS FirstQuarter_End,

PdmToday(1,31,6,-1) AS LastYrSecondQuarter_End

FROM in;

Anyone know how to create a filter for 'Last Week' (always Monday through Sunday)?   We're also in need of one for 'Last Quarter'.

Tammy

Thanks Fred for sharing this information

Fred...........

Thanks for sharing your CABI/BOXI report writing experise with the rest of the community.

Much appreciated!