C11/System/WERWISO/IQD/Zeit/Ben_Zeit_Monteur_S_offene_Auftraege.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\zeit\Ben_Zeit_Monteur_S_offene_Auftraege.imr
TITLE,Ben_Zeit_Monteur_S_offene_Auftraege.imr
BEGIN SQL
select distinct c1 as c1,
	   c2 as c2,
	   c3 as c3,
	   c4 as c4,
	   XMAX(c6 for c2) as c5
from 
(select c12 as c1,
	   c10 as c2,
	   XSUM(c14 for c10) as c3,
	   XSUM(c13 for c10) as c4,
	   c11 as c6
from 
(select (T1."VorgangsNummer") as c10,
	   T1."Datum" as c11,
	   T1."Filial_ID" as c12,
	   (((((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 c13,
	   (T1."AnzAW" / 10) as c14
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                  '))) and (T1."VorgangsNummer" > 0))
) D2
) D1
where (c4 IS NOT NULL)
order by c2 asc

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