COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planner_2022
DATASOURCENAME,D:\GAPS_BMW\Portal\System\IQD\AHR\Belege\Planner_2022_KER_Ums_Monteur.imr
TITLE,Planner_2022_KER_Ums_Monteur.imr
BEGIN SQL
select T1."BETRIEB NR" as c1,
	   T1."ZEILE MIT BEZ" as c2,
	   T1."BEREICH" as c3,
	   T1."VSTUFE 1" as c4,
	   T1."JAN" as c5,
	   T1."FEB" as c6,
	   T1."MAR" as c7,
	   T1."APR" as c8,
	   T1."MAI" as c9,
	   T1."JUN" as c10,
	   T1."JUL" as c11,
	   T1."AUG" as c12,
	   T1."SEP" as c13,
	   T1."OKT" as c14,
	   T1."NOV" as c15,
	   T1."DEZ" + T1."PERIODE13" as c16,
	   '213' as c17,
	   T1."KONTO" as c18,
	   T1."JAHR" as c19,
	   CASE WHEN (T1."BETRIEB NR" IN ('82')) THEN ('60') WHEN (T1."BETRIEB NR" IN ('81')) THEN ('90') ELSE (T1."BETRIEB NR") END as c20,
	   'prod. Personal' as c21,
	   (od_left(T1."ZEILE MIT BEZ",4)) as c22,
	   CASE WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6000' AND '6040') THEN ('WMOM') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6050' AND '6078') THEN ('WMOE') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6090' AND '6110') THEN ('WMOK') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6130' AND '6150') THEN ('WMOL') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6170' AND '6190') THEN ('WMOM') ELSE null END as c23,
	   T1."JAHR" as c24,
	   CASE WHEN (T1."BETRIEB NR" IN ('81','82')) THEN ('2') ELSE ('1') END as c25,
	   (CASE WHEN (T1."BETRIEB NR" IN ('82')) THEN ('60') WHEN (T1."BETRIEB NR" IN ('81')) THEN ('90') ELSE (T1."BETRIEB NR") END) as c26,
	   T1."GESAMT" as c27,
	   T1."PERIODE13" as c28,
	   T1."ZEILE" as c29
from "Planner_2022_V1_Plan.csv" T1
where (((T1."VSTUFE 1" IN ('Umsatzerlöse','Umsatzerlöse')) and (T1."ZEILE MIT BEZ" LIKE '6%')) and ((CASE WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6000' AND '6040') THEN ('WMOM') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6050' AND '6078') THEN ('WMOE') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6090' AND '6110') THEN ('WMOK') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6130' AND '6150') THEN ('WMOL') WHEN (((od_left(T1."ZEILE MIT BEZ",4))) BETWEEN '6170' AND '6190') THEN ('WMOM') ELSE null END) IS NOT NULL))

END SQL
COLUMN,0,Betrieb Nr_ori
COLUMN,1,Zeile Mit Bez
COLUMN,2,Bereich
COLUMN,3,Vstufe 1
COLUMN,4,Jan
COLUMN,5,Feb
COLUMN,6,Mar
COLUMN,7,Apr
COLUMN,8,Mai
COLUMN,9,Jun
COLUMN,10,Jul
COLUMN,11,Aug
COLUMN,12,Sep
COLUMN,13,Okt
COLUMN,14,Nov
COLUMN,15,Dez
COLUMN,16,Version
COLUMN,17,Konto
COLUMN,18,Jahr
COLUMN,19,Betrieb Nr
COLUMN,20,produktiv/unproduktiv
COLUMN,21,Zeile
COLUMN,22,Monteur_Gruppe
COLUMN,23,Datum
COLUMN,24,Hauptbetrieb
COLUMN,25,Standort
COLUMN,26,Gesamt
COLUMN,27,Periode13
COLUMN,28,Zeile