GAPS/Portal/System/IQD/Plan/TZ_Plan.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Plan_2006_Inso
DATASOURCENAME,D:\GAPS\Portal\System\IQD\Plan\TZ_Plan.imr
TITLE,TZ_Plan.imr
BEGIN SQL
select T1."Vertragshändler" as c1,
	   T1."Betrieb" as c2,
	   T1."Kostenstelle" as c3,
	   T1."Version" as c4,
	   T1."Jahr" as c5,
	   T1."Verdichtung 9" as c6,
	   T1."Verdichtung 10" as c7,
	   T1."Verdichtung 11" as c8,
	   T1."Verdichtung 12" as c9,
	   T1."Verdichtung 13" as c10,
	   T1."Menge 1" as c11,
	   T1."Menge 2" as c12,
	   T1."Menge 3" as c13,
	   T1."Menge 4" as c14,
	   T1."Menge 5" as c15,
	   T1."Menge 6" as c16,
	   T1."Menge 7" as c17,
	   T1."Menge 8" as c18,
	   T1."Menge 9" as c19,
	   T1."Menge 10" as c20,
	   T1."Menge 11" as c21,
	   T1."Menge 12" as c22,
	   T1."Wert 1" as c23,
	   T1."Wert 2" as c24,
	   T1."Wert 3" as c25,
	   T1."Wert 4" as c26,
	   T1."Wert 5" as c27,
	   T1."Wert 6" as c28,
	   T1."Wert 7" as c29,
	   T1."Wert 8" as c30,
	   T1."Wert 9" as c31,
	   T1."Wert 10" as c32,
	   T1."Wert 11" as c33,
	   T1."Wert 12" as c34,
	   T1."Wert 1" as c35,
	   T1."Wert 2" + T1."Wert 1" as c36,
	   T1."Wert 3" + (T1."Wert 2" + T1."Wert 1") as c37,
	   T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1")) as c38,
	   T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1"))) as c39,
	   T1."Wert 6" + (T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1")))) as c40,
	   T1."Wert 7" + (T1."Wert 6" + (T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1"))))) as c41,
	   T1."Wert 8" + (T1."Wert 7" + (T1."Wert 6" + (T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1")))))) as c42,
	   T1."Wert 9" + (T1."Wert 8" + (T1."Wert 7" + (T1."Wert 6" + (T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1"))))))) as c43,
	   T1."Wert 10" + (T1."Wert 9" + (T1."Wert 8" + (T1."Wert 7" + (T1."Wert 6" + (T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1")))))))) as c44,
	   T1."Wert 11" + (T1."Wert 10" + (T1."Wert 9" + (T1."Wert 8" + (T1."Wert 7" + (T1."Wert 6" + (T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1"))))))))) as c45,
	   T1."Wert 12" + (T1."Wert 11" + (T1."Wert 10" + (T1."Wert 9" + (T1."Wert 8" + (T1."Wert 7" + (T1."Wert 6" + (T1."Wert 5" + (T1."Wert 4" + (T1."Wert 3" + (T1."Wert 2" + T1."Wert 1")))))))))) as c46,
	   'G.V.O.' as c47,
	   CASE WHEN (T1."Betrieb" = 'POS Mainzer Landstrasse') THEN ('01') WHEN (T1."Betrieb" = 'POS Nordwest-Stadt') THEN ('02') WHEN (T1."Betrieb" = 'POS Eschborn') THEN ('03') WHEN (T1."Betrieb" = 'POS Hanauer Landstrasse') THEN ('04') WHEN (T1."Betrieb" = 'POS Offenbach') THEN ('05') WHEN (T1."Betrieb" = 'POS Neu-Isenburg') THEN ('06') WHEN (T1."Betrieb" = 'POS Enkheim') THEN ('08') WHEN (T1."Betrieb" = 'POS Nürnberger Strasse') THEN ('09') WHEN (T1."Betrieb" = 'POS RSL') THEN ('07') ELSE null END as c48,
	   '6' as c49
from "TZ_imp_All_O21" T1
where (((T1."Verdichtung 10" <> 'Umlage Kostenstelle 8') and ((CASE WHEN (T1."Betrieb" = 'POS Mainzer Landstrasse') THEN ('01') WHEN (T1."Betrieb" = 'POS Nordwest-Stadt') THEN ('02') WHEN (T1."Betrieb" = 'POS Eschborn') THEN ('03') WHEN (T1."Betrieb" = 'POS Hanauer Landstrasse') THEN ('04') WHEN (T1."Betrieb" = 'POS Offenbach') THEN ('05') WHEN (T1."Betrieb" = 'POS Neu-Isenburg') THEN ('06') WHEN (T1."Betrieb" = 'POS Enkheim') THEN ('08') WHEN (T1."Betrieb" = 'POS Nürnberger Strasse') THEN ('09') WHEN (T1."Betrieb" = 'POS RSL') THEN ('07') ELSE null END) IS NOT NULL)) and (T1."Version" IN (107,110)))

END SQL
COLUMN,0,Rechtseinheit_ori
COLUMN,1,Betrieb_alt
COLUMN,2,Kostenstelle_ori
COLUMN,3,Version
COLUMN,4,Jahr
COLUMN,5,Ebene1
COLUMN,6,Ebene2
COLUMN,7,Ebene3
COLUMN,8,Ebene4
COLUMN,9,Ebene5
COLUMN,10,Menge 1
COLUMN,11,Menge 2
COLUMN,12,Menge 3
COLUMN,13,Menge 4
COLUMN,14,Menge 5
COLUMN,15,Menge 6
COLUMN,16,Menge 7
COLUMN,17,Menge 8
COLUMN,18,Menge 9
COLUMN,19,Menge 10
COLUMN,20,Menge 11
COLUMN,21,Menge 12
COLUMN,22,Wert 1_ori
COLUMN,23,Wert 2_ori
COLUMN,24,Wert 3_ori
COLUMN,25,Wert 4_ori
COLUMN,26,Wert 5_ori
COLUMN,27,Wert 6_ori
COLUMN,28,Wert 7_ori
COLUMN,29,Wert 8_ori
COLUMN,30,Wert 9_ori
COLUMN,31,Wert 10_ori
COLUMN,32,Wert 11_ori
COLUMN,33,Wert 12_ori
COLUMN,34,Wert 1
COLUMN,35,Wert 2
COLUMN,36,Wert 3
COLUMN,37,Wert 4
COLUMN,38,Wert 5
COLUMN,39,Wert 6
COLUMN,40,Wert 7
COLUMN,41,Wert 8
COLUMN,42,Wert 9
COLUMN,43,Wert 10
COLUMN,44,Wert 11
COLUMN,45,Wert 12
COLUMN,46,Rechtseinheit
COLUMN,47,Betrieb
COLUMN,48,Kostenstelle