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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Umsatz_Einsatz_STK_2022.imr
TITLE,Umsatz_Einsatz_STK_2022.imr
BEGIN SQL
select T1."Acct Nr_ori" as c1,
	   T1."Ledger Accts Name" as c2,
	   T1."Marke_1" as c3,
	   T1."Modell" as c4,
	   T1."Abnehmergruppe" as c5,
	   T1."Ebene1" as c6,
	   T1."Ebene2" as c7,
	   '' as c8,
	   '' as c9,
	   '' as c10,
	   '' as c11,
	   T1."Jahr" as c12,
	   T1."Mandant" as c13,
	   T1."Kürzel" as c14,
	   T1."KST" as c15,
	   T1."Marke" as c16,
	   T1."Plan" as c17,
	   T1."Stück" as c18,
	   T1."Art" 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
from "UE_EW_Gesamt_2022" T1
where (((T1."Art" IS NULL) and (T1."Stück" <> 0)) and (T1."Kürzel" IN ('EW')))

END SQL
COLUMN,0,Acct Nr Ori
COLUMN,1,Ledger Accts Name
COLUMN,2,Marke 1
COLUMN,3,Modell
COLUMN,4,Abnehmergruppe
COLUMN,5,Ebene1_ori
COLUMN,6,Ebene2_ori
COLUMN,7,Ebene3
COLUMN,8,Ebene4
COLUMN,9,Ebene5
COLUMN,10,Ebene6
COLUMN,11,Jahr
COLUMN,12,Mandant
COLUMN,13,Kürzel
COLUMN,14,Kst
COLUMN,15,Marke
COLUMN,16,Plan
COLUMN,17,Stück_ori
COLUMN,18,Art
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