COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Umsatz_Einsatz_STK_2017.imr
TITLE,Umsatz_Einsatz_STK_2017.imr
BEGIN SQL
select T1."Art" as c1,
	   T1."Acct Nr_ori" as c2,
	   T1."Ledger Accts Name" as c3,
	   T1."Marke_1" as c4,
	   T1."Modell" as c5,
	   T1."Abnehmergruppe" as c6,
	   'verkaufte Stückzahlen' as c7,
	   T1."Ebene2" as c8,
	   '' as c9,
	   '' as c10,
	   '' as c11,
	   '' as c12,
	   T1."Jahr" as c13,
	   T1."Mandant" as c14,
	   T1."Kürzel" as c15,
	   T1."KST" as c16,
	   T1."Marke" as c17,
	   T1."Stück" as c18,
	   T1."Stück" as c19,
	   '' as c20,
	   CASE WHEN (T1."Ebene2" IN ('VE Neuwagen')) THEN ('Neuwagen') WHEN (T1."Ebene2" IN ('VE Gebrauchtwagen','VE Gebrauchtwagen
')) THEN ('Gebrauchtwagen') ELSE null END as c21,
	   T1."Stück" / 12 as c22,
	   T1."Stück" / 12 as c23,
	   T1."Stück" / 12 as c24,
	   T1."Stück" / 12 as c25,
	   T1."Stück" / 12 as c26,
	   T1."Stück" / 12 as c27,
	   T1."Stück" / 12 as c28,
	   T1."Stück" / 12 as c29,
	   T1."Stück" / 12 as c30,
	   T1."Stück" / 12 as c31,
	   T1."Stück" / 12 as c32,
	   T1."Stück" / 12 as c33,
	   T1."Stück" / 12 as c34,
	   T1."Stück" / 12 as c35,
	   T1."Stück" / 12 as c36,
	   T1."Stück" / 12 as c37,
	   T1."Stück" / 12 as c38,
	   T1."Stück" / 12 as c39,
	   T1."Stück" / 12 as c40,
	   T1."Stück" / 12 as c41,
	   T1."Stück" / 12 as c42,
	   T1."Stück" / 12 as c43,
	   T1."Stück" / 12 as c44,
	   T1."Stück" / 12 as c45
from "UE_EW_gesamt_2017" T1
where ((T1."Art" <> 'Summenzeile') and (T1."Stück" <> 0))

END SQL
COLUMN,0,Art
COLUMN,1,Acct Nr Ori
COLUMN,2,Ledger Accts Name
COLUMN,3,Marke 1
COLUMN,4,Modell
COLUMN,5,Abnehmergruppe
COLUMN,6,Ebene1
COLUMN,7,Ebene2_ori
COLUMN,8,Ebene3
COLUMN,9,Ebene4
COLUMN,10,Ebene5
COLUMN,11,Ebene6
COLUMN,12,Jahr
COLUMN,13,Mandant
COLUMN,14,Kürzel
COLUMN,15,Kst
COLUMN,16,Marke
COLUMN,17,Plan
COLUMN,18,Stück_ORI
COLUMN,19,Feld2
COLUMN,20,Ebene2
COLUMN,21,Stk1_ori
COLUMN,22,Stk2
COLUMN,23,Stk3
COLUMN,24,Stk4
COLUMN,25,Stk5
COLUMN,26,Stk6
COLUMN,27,Stk7
COLUMN,28,Stk8
COLUMN,29,Stk9
COLUMN,30,Stk10
COLUMN,31,Stk11
COLUMN,32,Stk12
COLUMN,33,Wert1
COLUMN,34,Wert2
COLUMN,35,Wert3
COLUMN,36,Wert4
COLUMN,37,Wert5
COLUMN,38,Wert6
COLUMN,39,Wert7
COLUMN,40,Wert8
COLUMN,41,Wert9
COLUMN,42,Wert10
COLUMN,43,Wert11
COLUMN,44,Wert12