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