COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Umsatz_Einsatz_STK_2018_GuV.imr
TITLE,Umsatz_Einsatz_STK_2018_GuV.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,
	   CASE WHEN (T1."Ebene2" IN ('VE Gebrauchtwagen')) THEN ('Gebrauchtwagen') WHEN (T1."Ebene2" IN ('VE Neuwagen')) THEN ('Neuwagen') ELSE null END as c20,
	   T1."Stück" / 12 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,
	   'verkaufte Stückzahlen' as c45,
	   CASE WHEN (T1."KST" = 1) THEN ('Neuwagen') WHEN (T1."KST" = 2) THEN ('Gebrauchtwagen') ELSE null END as c46,
	   CASE WHEN ((T1."KST" = 1) and (T1."Abnehmergruppe" IN ('NW verb. UN'))) THEN ('NW verb. UN') WHEN (T1."KST" = 1) THEN ('1 - Endverbraucher') WHEN ((T1."KST" = 2) and (T1."Abnehmergruppe" IN ('GW verb. UN'))) THEN ('GW verb. UN') WHEN (T1."KST" = 2) THEN ('1 - Endverbraucher') ELSE null END as c47
from "UE_EW_gesamt_2018" T1
where ((((T1."Art" IS NULL) and (T1."Stück" <> 0)) and (T1."KST" IN (1,2))) and (T1."Kürzel" = 'VE'))

END SQL
COLUMN,0,Art
COLUMN,1,Acct Nr Ori
COLUMN,2,Ledger Accts Name
COLUMN,3,Marke 1_GuV
COLUMN,4,Modell_GuV
COLUMN,5,Abnehmergruppe_GuV
COLUMN,6,Ebene1_GuV
COLUMN,7,Ebene2_ori
COLUMN,8,Ebene3_GuV
COLUMN,9,Ebene4_GuV
COLUMN,10,Ebene5_GuV
COLUMN,11,Ebene6_GuV
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,Ebene2
COLUMN,20,Stk1_GuV
COLUMN,21,Stk2_GuV
COLUMN,22,Stk3_GuV
COLUMN,23,Stk4_GuV
COLUMN,24,Stk5_GuV
COLUMN,25,Stk6_GuV
COLUMN,26,Stk7_GuV
COLUMN,27,Stk8_GuV
COLUMN,28,Stk9_GuV
COLUMN,29,Stk10_GuV
COLUMN,30,Stk11_GuV
COLUMN,31,Stk12_GuV
COLUMN,32,Wert1_GuV
COLUMN,33,Wert2_GuV
COLUMN,34,Wert3_GuV
COLUMN,35,Wert4_GuV
COLUMN,36,Wert5_GuV
COLUMN,37,Wert6_GuV
COLUMN,38,Wert7_GuV
COLUMN,39,Wert8_GuV
COLUMN,40,Wert9_GuV
COLUMN,41,Wert10_GuV
COLUMN,42,Wert11_GuV
COLUMN,43,Wert12_GuV
COLUMN,44,Ebene31
COLUMN,45,Ebene32
COLUMN,46,Ebene33