GAPS/Portal/System/IQD/Planung/Umsatz_Einsatz_STK_2023.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Umsatz_Einsatz_STK_2023.imr
TITLE,Umsatz_Einsatz_STK_2023.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,
	   T1."Ebene1" 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."Plan" as c18,
	   T1."Stück" as c19,
	   'verkaufte Stückzahlen' as c20,
	   CASE WHEN (T1."Ebene2" IN ('EW Gebrauchtwagen')) THEN ('Gebrauchtwagen') WHEN (T1."Ebene2" IN ('EW Neuwagen')) THEN ('Neuwagen') 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,
	   CASE WHEN (T1."Marke_1" IN ('Maxxus')) THEN (('MX')) ELSE (T1."Marke") END as c34
from "UE_EW_Gesamt_2023" T1
where (((T1."Art" IS NULL) and (T1."Stück" <> 0)) and (T1."Kürzel" IN ('EW')))

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_ori
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_ORI
COLUMN,17,Plan
COLUMN,18,Stück_ori
COLUMN,19,Ebene1
COLUMN,20,Ebene2
COLUMN,21,Wert1
COLUMN,22,Wert2
COLUMN,23,Wert3
COLUMN,24,Wert4
COLUMN,25,Wert5
COLUMN,26,Wert6
COLUMN,27,Wert7
COLUMN,28,Wert8
COLUMN,29,Wert9
COLUMN,30,Wert10
COLUMN,31,Wert11
COLUMN,32,Wert12
COLUMN,33,Marke