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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Umsatz_Einsatz_2023.imr
TITLE,Umsatz_Einsatz_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,
	   T1."Ebene3" as c9,
	   T1."Ebene4" as c10,
	   T1."Ebene5" as c11,
	   T1."Ebene6" 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,
	   CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END as c20,
	   T1."Plan" / 12 as c21,
	   T1."Plan" / 12 as c22,
	   T1."Plan" / 12 as c23,
	   T1."Plan" / 12 as c24,
	   T1."Plan" / 12 as c25,
	   T1."Plan" / 12 as c26,
	   T1."Plan" / 12 as c27,
	   T1."Plan" / 12 as c28,
	   T1."Plan" / 12 as c29,
	   T1."Plan" / 12 as c30,
	   T1."Plan" / 12 as c31,
	   T1."Plan" / 12 as c32,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c33,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c34,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c35,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c36,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c37,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c38,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c39,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c40,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c41,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c42,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c43,
	   (CASE WHEN (T1."Kürzel" IN ('EW')) THEN (0) ELSE (T1."Stück") END) / 12 as c44,
	   CASE WHEN (T1."Marke_1" IN ('Maxxus')) THEN (('MX')) ELSE (T1."Marke") END as c45
from "UE_EW_Gesamt_2023" T1
where ((T1."Art" IS NULL) and (T1."Plan" <> 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
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,Stück
COLUMN,20,Wert1
COLUMN,21,Wert2
COLUMN,22,Wert3
COLUMN,23,Wert4
COLUMN,24,Wert5
COLUMN,25,Wert6
COLUMN,26,Wert7
COLUMN,27,Wert8
COLUMN,28,Wert9
COLUMN,29,Wert10
COLUMN,30,Wert11
COLUMN,31,Wert12
COLUMN,32,Stk1
COLUMN,33,Stk2
COLUMN,34,Stk3
COLUMN,35,Stk4
COLUMN,36,Stk5
COLUMN,37,Stk6
COLUMN,38,Stk7
COLUMN,39,Stk8
COLUMN,40,Stk9
COLUMN,41,Stk10
COLUMN,42,Stk11
COLUMN,43,Stk12
COLUMN,44,Marke