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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,SKR51_Struktur
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\SKR_Marke.imr
TITLE,SKR_Marke.imr
BEGIN SQL
select T1."EBENE41" as c1,
	   T1."EBENE42" as c2,
	   T1."EBENE43" as c3,
	   T1."EBENE44" as c4,
	   T1."EBENE45" as c5,
	   T1."EBENE46" as c6,
	   T1."EBENE47" as c7,
	   T1."EBENE48" as c8,
	   T1."EBENE49" as c9,
	   T1."EBENE50" as c10,
	   (od_left(T1."EBENE41",2)) as c11
from "Marke.csv" T1
where ((((od_left(T1."EBENE41",2))) BETWEEN '00' AND '99') or (((od_left(T1."EBENE41",2))) IN ('00','99','DI','KI','RN')))

END SQL
COLUMN,0,Marke_mit_Bez
COLUMN,1,Ebene42
COLUMN,2,Ebene43
COLUMN,3,Ebene44
COLUMN,4,Ebene45
COLUMN,5,Ebene46
COLUMN,6,Ebene47
COLUMN,7,Ebene48
COLUMN,8,Ebene49
COLUMN,9,Ebene50
COLUMN,10,Marke