GAPS/Portal/System/IQD/NW/GCStruct_Verkäufer_Teams.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GCStruct_Teams
DATASOURCENAME,D:\Gaps\Portal\System\IQD\NW\GCStruct_Verkäufer_Teams.imr
TITLE,GCStruct_Verkäufer_Teams.imr
BEGIN SQL
select T1."KONTO_NR" as c1,
	   T1."KONTO_BEZEICHNUNG" as c2,
	   T1."KONTO_ART" as c3,
	   T1."EBENE11" as c4,
	   T1."EBENE12" as c5,
	   T1."EBENE13" as c6,
	   T1."EBENE14" as c7,
	   T1."EBENE15" as c8,
	   T1."EBENE16" as c9,
	   T1."EBENE17" as c10,
	   T1."EBENE18" as c11,
	   T1."EBENE19" as c12,
	   T1."EBENE20" as c13,
	   T1."KONTO_BEZEICHNUNG" || ' - ' || T1."KONTO_NR" as c14
from "Teamliste.csv" T1
where (T1."EBENE11" IS NOT NULL)

END SQL
COLUMN,0,Konto Nr
COLUMN,1,Konto Bezeichnung
COLUMN,2,Konto Art
COLUMN,3,Ebene11
COLUMN,4,Ebene12
COLUMN,5,Ebene13
COLUMN,6,Ebene14
COLUMN,7,Ebene15
COLUMN,8,Ebene16
COLUMN,9,Ebene17
COLUMN,10,Ebene18
COLUMN,11,Ebene19
COLUMN,12,Ebene20
COLUMN,13,Verkäufer_aus_Team