Skip to Content
0
Former Member
Jun 29, 2009 at 04:27 PM

Error in DSO to DSO transfer

35 Views

hello all,

i have a dso1 from which i am loading the data in to dso2. dso1 has a transaction level data.

DSO 1 has key fields - ticket id.and data fields - status, priority,group, catagory, resolved month, recieved month.

DSO2 has key fields - group, catagory resolved month and data fields - resolved count (Key fig.)

DSO 2 gives me the total tickets resolved in month, group and catagory wise.

now while i load the data from DSO1 to DSO2 from change log table it gives the correct count, but from active data table it only loads the records with a perticular combination only once. so i get resolved count as 1 for all the records. which is wrong.

Example in DSO 1

Ticket ID ic00001 Status- resolved ; priority- High ,group-abc, catagory- x, resolved month-092007, recieved month-092007

Ticket ID ic00002 Status- resolved ; priority- medium ,group-abc, catagory- x, resolved month-092007, recieved month-092007

Ticket ID ic00003 Status- resolved ; priority- low ,group-abc, catagory- x, resolved month-092007, recieved month-092007

the result of Resolved count in DSO 2 should be 3

group-abc, catagory-x ;resolved month-092007 and data fields - resolved count (Key fig.)-3

The result I get is as under

group-abc, catagory-x ;resolved month-092007 and data fields - resolved count (Key fig.)-1

If the data is extracted thru change log I get correct result which is

group-abc, catagory-x ;resolved month-092007 and data fields - resolved count (Key fig.)-3

means formula for count of resolved ticket is correct

It is observed that while doing extraction of data transfered record and added record =1 while it should be Transferred = 3 and added = 1

Your prompt reply will be appreciated.

Regards