C11/System/ARI/IQD/Service/Time_Clock_Entry_fuer_ben_AW.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,ARIntelligence
DATASOURCENAME,C:\GlobalCube\System\ARI\IQD\Service\Time_Clock_Entry_fuer_ben_AW.imr
TITLE,Time_Clock_Entry_fuer_ben_AW.imr
BEGIN SQL
select distinct c13 as c1,
	   c12 as c2,
	   c11 as c3,
	   c10 as c4,
	   XSUM(c14 for c9) as c5,
	   c9 as c6
from 
(select ((T1."Service Order No_" || '_' || (rtrim((cast_numberToString(cast_integer(T1."Service Job No_")))))) || '_' || (T1."Resource No_" || ' - ' || T2."Name")) as c9,
	   T1."Service Order No_" || '_' || (rtrim((cast_numberToString(cast_integer(T1."Service Job No_"))))) as c10,
	   T1."Service Job No_" as c11,
	   T1."Service Order No_" as c12,
	   T1."Resource No_" || ' - ' || T2."Name" as c13,
	   ((cast_float(T1."Duration"))) as c14
from "Gottstein7x"."dbo"."AH Gottstein$Employee" T2,
	"Gottstein7x"."dbo"."AH Gottstein$Time Clock Entry" T1
where (T2."No_" = T1."Employee No_")
and ((((T1."Date" >= TIMESTAMP '2022-01-01 00:00:00.000') and (T1."Sorting" = 0)) and (T1."Canceled" = 0)) and (T1."Service Order No_" <> ''))
) D1
order by c6 asc,c4 asc

END SQL
COLUMN,0,Resource No
COLUMN,1,Service Order No
COLUMN,2,Service Job No
COLUMN,3,Order_job_No
COLUMN,4,Summe_Order_Job
COLUMN,5,Order_job_resource