GAPS/Portal/System/IQD/Belege/SKR_Absatzkanal.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51_Struktur
DATASOURCENAME,C:\Gaps\Portal\System\IQD\Belege\SKR_Absatzkanal.imr
TITLE,SKR_Absatzkanal.imr
BEGIN SQL
select T1."EBENE21" as c1,
	   T1."EBENE22" as c2,
	   T1."EBENE23" as c3,
	   T1."EBENE24" as c4,
	   T1."EBENE25" as c5,
	   T1."EBENE26" as c6,
	   T1."EBENE27" as c7,
	   T1."EBENE28" as c8,
	   T1."EBENE29" as c9,
	   T1."EBENE30" as c10,
	   CASE WHEN (T1."EBENE22" IN ('100 - Bilanz')) THEN ('100') ELSE ((od_left(T1."EBENE22",2))) END as c11
from "Absatzkanal.csv" T1
where ((CASE WHEN (T1."EBENE22" IN ('100 - Bilanz')) THEN ('100') ELSE ((od_left(T1."EBENE22",2))) END) BETWEEN '00' AND '99')

END SQL
COLUMN,0,Ebene21
COLUMN,1,Absatzkanal_mit_Bez
COLUMN,2,Ebene23
COLUMN,3,Ebene24
COLUMN,4,Ebene25
COLUMN,5,Ebene26
COLUMN,6,Ebene27
COLUMN,7,Ebene28
COLUMN,8,Ebene29
COLUMN,9,Ebene30
COLUMN,10,Absatzkanal