GAPS/Portal/System/IQD/Belege/OptiControl_Zeit.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,OptiControl_Zeit
DATASOURCENAME,D:\Gaps\Portal\System\IQD\Belege\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,
	   (rtrim(T1."NACHNAME")) || ', ' || (rtrim(T1."VORNAME")) as c17,
	   ((rtrim(T1."NACHNAME")) || ', ' || (rtrim(T1."VORNAME"))) || ' - (' || ((substring(T1."KOSTSTELLE" from 3 for 2))) || ')' as c18,
	   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 c19,
	   T1."ISTSTDOP" * 0.8 * (CASE WHEN (T1."PROFIT2" = 'Auszubildender') THEN (0.5) ELSE (1) END) as c20,
	   '1' as c21,
	   '3' as c22,
	   (substring(T1."KOSTSTELLE" from 3 for 2)) as c23,
	   'Umsatzerlöse' as c24,
	   'VE Service' as c25,
	   'VE Mechanik' as c26,
	   'VE ME Lohn' as c27,
	   'Lohn ME' as c28,
	   '' as c29,
	   '' as c30,
	   '' as c31,
	   '' as c32,
	   '' as c33,
	   '' as c34,
	   '' as c35,
	   '' as c36,
	   '' as c37,
	   '' as c38,
	   '' as c39,
	   '' as c40,
	   '' as c41,
	   '' as c42,
	   '' as c43,
	   'Umsatzerlöse' as c44,
	   'VE Service' as c45,
	   'VE Mechanik' as c46,
	   'VE ME Lohn' as c47,
	   '' as c48,
	   ((rtrim(T1."NACHNAME")) || ', ' || (rtrim(T1."VORNAME"))) as c49,
	   '' as c50,
	   (((rtrim(T1."NACHNAME")) || ', ' || (rtrim(T1."VORNAME"))) || ' - (' || ((substring(T1."KOSTSTELLE" from 3 for 2))) || ')') as c51,
	   '' as c52,
	   'Opti Time' as c53,
	   'Opti Time' as c54
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_OT
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,Monteur_OC
COLUMN,17,Monteur_OC_Standort
COLUMN,18,Standort_OC
COLUMN,19,Zielwert_Std
COLUMN,20,Rechtseinheit
COLUMN,21,Kostenstelle
COLUMN,22,Betrieb
COLUMN,23,Ebene1
COLUMN,24,Ebene2
COLUMN,25,Ebene3
COLUMN,26,Ebene4
COLUMN,27,Ebene12
COLUMN,28,Ebene13
COLUMN,29,Ebene14
COLUMN,30,Ebene21
COLUMN,31,Ebene22
COLUMN,32,Ebene23
COLUMN,33,Ebene24
COLUMN,34,Ebene25
COLUMN,35,Ebene26
COLUMN,36,Ebene31
COLUMN,37,Ebene32
COLUMN,38,Ebene33
COLUMN,39,Ebene34
COLUMN,40,Ebene35
COLUMN,41,Ebene36
COLUMN,42,Ebene37
COLUMN,43,Ebene51
COLUMN,44,Ebene52
COLUMN,45,Ebene53
COLUMN,46,Ebene54
COLUMN,47,Ebene55
COLUMN,48,Konto
COLUMN,49,Text
COLUMN,50,Acct Nr
COLUMN,51,Ebene5
COLUMN,52,Type Acctt
COLUMN,53,Susa