C11/System/LOCOSOFT/IQD/Serv_Teile/ben_AW_Order_Number.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_LOCOSOFT
DATASOURCENAME,C:\GlobalCube\System\LOCOSOFT\IQD\Serv_Teile\ben_AW_Order_Number.imr
TITLE,ben_AW_Order_Number.imr
BEGIN SQL
select T1."order_number" as c1,
	   SUM(T1."duration_minutes") as c2
from "dbo"."times" T1
where (T1."order_number" <> 0)
group by (T1."order_number")
order by c1 asc

END SQL
COLUMN,0,Order Number
COLUMN,1,Summe_Duration_Minutes