COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\zeit\Verr_ben_Zeit_Monteur_S_Aftersales.imr
TITLE,Verr_ben_Zeit_Monteur_S_Aftersales.imr
BEGIN SQL
select distinct c9 as c1,
	   c8 as c2,
	   XSUM(c11 for c8) as c3,
	   XSUM(c10 for c8) as c4
from 
(select (T1."VorgangsNummer") as c8,
	   T1."Filial_ID" as c9,
	   (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) as c10,
	   (T1."AnzAW" / 10) as c11
from ("\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."ZEITERF2" T1 left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."personal" T2 on T2."Personalnummer" = T1."MonteurNr")
where ((not T1."VorgangsNummer" IN (-1,0)) and (T2."Personalart" IN ('Monteur                  ')))
) D1
order by c2 asc

END SQL
COLUMN,0,Filial Id
COLUMN,1,Vorgangsnummer
COLUMN,2,Summe_verr_Zeit
COLUMN,3,Summe_ben_Zeit