COGNOS QUERY
STRUCTURE,1,1
DATABASE,OptiControl_Zeit
DATASOURCENAME,D:\Gaps\Portal\System\IQD\Serv_Teile\OptiControl_Zeit.imr
TITLE,OptiControl_Zeit.imr
BEGIN SQL
select T1."DATUM" as c1,
	   T1."PNR" as c2,
	   T1."VORNAME" as c3,
	   T1."NACHNAME" as c4,
	   T1."KOSTSTELLE" as c5,
	   T1."NAME" as c6,
	   T1."ISTSTDOP" as c7,
	   T1."SOLLTAGOP" as c8,
	   T1."VON" as c9,
	   T1."BIS" as c10,
	   T1."PROFIT1" as c11,
	   T1."PROFIT2" as c12,
	   0.8 as c13,
	   CASE WHEN (T1."PROFIT2" = 'Auszubildender') THEN (0.5) ELSE (1) END as c14,
	   65 as c15,
	   T1."ISTSTDOP" * 0.8 * (CASE WHEN (T1."PROFIT2" = 'Auszubildender') THEN (0.5) ELSE (1) END) * 65 as c16,
	   (substring(T1."KOSTSTELLE" from 3 for 2)) as c17,
	   (rtrim(T1."NACHNAME")) || ', ' || (rtrim(T1."VORNAME")) as c18,
	   ((rtrim(T1."NACHNAME")) || ', ' || (rtrim(T1."VORNAME"))) || ' - (' || ((substring(T1."KOSTSTELLE" from 3 for 2))) || ')' as c19,
	   CASE WHEN (((substring(T1."KOSTSTELLE" from 3 for 2))) = '01') THEN ('01 - Uslar') WHEN (((substring(T1."KOSTSTELLE" from 3 for 2))) = '02') THEN ('02 - Holzminden') WHEN (((substring(T1."KOSTSTELLE" from 3 for 2))) = '03') THEN ('03 - Einbeck') ELSE null END as c20,
	   T1."ISTSTDOP" * 0.8 * (CASE WHEN (T1."PROFIT2" = 'Auszubildender') THEN (0.5) ELSE (1) END) as c21,
	   T1."DATUM" as c22
from "Export.csv" T1
where (((T1."KOSTSTELLE" IN ('000111','000211','000311')) and (T1."PROFIT1" = 'Werkstatt')) and ((T1."PROFIT2" IN ('Auszubildender')) or (T1."PROFIT2" IS NULL)))

END SQL
COLUMN,0,Datum
COLUMN,1,Pnr
COLUMN,2,Vorname
COLUMN,3,Nachname
COLUMN,4,Koststelle
COLUMN,5,Name
COLUMN,6,Iststdop
COLUMN,7,Solltagop
COLUMN,8,Von
COLUMN,9,Bis
COLUMN,10,Profit1
COLUMN,11,Profit2
COLUMN,12,Faktor Produktiv
COLUMN,13,Anrechnung MA
COLUMN,14,Std_Satz
COLUMN,15,Zielwert
COLUMN,16,Standort_OC_Teil
COLUMN,17,Monteur_OC
COLUMN,18,Monteur_OC_Standort
COLUMN,19,Standort_OC
COLUMN,20,Zielwert_Std
COLUMN,21,Transact Date