cancel
Showing results for 
Search instead for 
Did you mean: 

QM status tracking Report

Former Member
0 Kudos
86

Hi Experts,

I have a requirement for a report in BW showing different Status counts per Weeks as shown in below

Status Week1 WeeK2 Week3---n(Date Range as Per User)

S1 10 10 15

S2 9 11 15

For eg In Week1 10 Notification were having Status (S1)

Currently we have Developed a ABAP Query to fetch All the Status Changes for a Notification to the Data Source(QMEL+JCDS).

I'm ABAP consultant so please advise is it possible to filter the data according to the dates and sum it based on Status in BW?

or is there any other way?

Regards,

kb

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I assume this is a cross tab report.

in this case I would expect the raw data to look like

Status Date

S1 week1

S1 week1

S1 week1

S1 week3

S1 week3

S2 week1

S2 week2

S2 week2

S2 week3

S2 week3

S1 week4

the filter in the report would look for date <> week4

and the result would be

Status Week1 Week2 Week3

S1 3 0 2

S2 1 2 2

is this what we are talking about?