GAPS/Portal/System/IQD/Plan/Zielprämie.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Plan\Zielprämie.imr
TITLE,Zielprämie.imr
BEGIN SQL
select T1."INVOICE DATE" as c1,
	   T1."WERT1" as c2,
	   T1."WERT2" as c3,
	   T1."WERT3" as c4,
	   T1."WERT4" as c5,
	   T1."WERT5" as c6,
	   T1."WERT6" as c7,
	   T1."WERT7" as c8,
	   T1."WERT8" as c9,
	   T1."WERT9" as c10,
	   T1."WERT10" as c11,
	   T1."WERT11" as c12,
	   T1."WERT12" as c13,
	   T2."ARBEITSTAGE_MONAT" as c14,
	   T2."MONAT" as c15,
	   T2."ARBEITSTAG" as c16,
	   CASE WHEN (T2."MONAT" = 1) THEN (T1."WERT1") WHEN (T2."MONAT" = 2) THEN (T1."WERT2") WHEN (T2."MONAT" = 3) THEN (T1."WERT3") WHEN (T2."MONAT" = 4) THEN (T1."WERT4") WHEN (T2."MONAT" = 5) THEN (T1."WERT5") WHEN (T2."MONAT" = 6) THEN (T1."WERT6") WHEN (T2."MONAT" = 7) THEN (T1."WERT7") WHEN (T2."MONAT" = 8) THEN (T1."WERT8") WHEN (T2."MONAT" = 9) THEN (T1."WERT9") WHEN (T2."MONAT" = 10) THEN (T1."WERT10") WHEN (T2."MONAT" = 11) THEN (T1."WERT11") WHEN (T2."MONAT" = 12) THEN (T1."WERT12") ELSE null END as c17,
	   (CASE WHEN (T2."MONAT" = 1) THEN (T1."WERT1") WHEN (T2."MONAT" = 2) THEN (T1."WERT2") WHEN (T2."MONAT" = 3) THEN (T1."WERT3") WHEN (T2."MONAT" = 4) THEN (T1."WERT4") WHEN (T2."MONAT" = 5) THEN (T1."WERT5") WHEN (T2."MONAT" = 6) THEN (T1."WERT6") WHEN (T2."MONAT" = 7) THEN (T1."WERT7") WHEN (T2."MONAT" = 8) THEN (T1."WERT8") WHEN (T2."MONAT" = 9) THEN (T1."WERT9") WHEN (T2."MONAT" = 10) THEN (T1."WERT10") WHEN (T2."MONAT" = 11) THEN (T1."WERT11") WHEN (T2."MONAT" = 12) THEN (T1."WERT12") ELSE null END) / T2."ARBEITSTAGE_MONAT" as c18,
	   T2."DATUM" as c19,
	   T1."HAUPTBETRIEB" as c20,
	   T1."STANDORT" as c21,
	   T1."KOSTENSTELLE" as c22
from "Planung_Kalender.csv" T2,
	"Ziele Teamprämie.csv" T1
where (T2."JAHR" = T1."INVOICE DATE")

END SQL
COLUMN,0,Jahr
COLUMN,1,Wert1
COLUMN,2,Wert2
COLUMN,3,Wert3
COLUMN,4,Wert4
COLUMN,5,Wert5
COLUMN,6,Wert6
COLUMN,7,Wert7
COLUMN,8,Wert8
COLUMN,9,Wert9
COLUMN,10,Wert10
COLUMN,11,Wert11
COLUMN,12,Wert12
COLUMN,13,Arbeitstage Monat
COLUMN,14,Monat
COLUMN,15,Arbeitstag
COLUMN,16,Plan_Monat
COLUMN,17,Plan_Tag
COLUMN,18,Invoice Date
COLUMN,19,Hauptbetrieb
COLUMN,20,Standort
COLUMN,21,Kostenstelle