C11/System/ARI/IQD/Belege/GCStruct_Kontenrahmen.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GCStruct
DATASOURCENAME,C:\GlobalCube\System\ARI\IQD\Belege\GCStruct_Kontenrahmen.imr
TITLE,GCStruct_Kontenrahmen.imr
BEGIN SQL
select T1."KONTO_NR" as c1,
	   T1."KONTO_BEZEICHNUNG" as c2,
	   T1."KONTO_ART" as c3,
	   T1."KOSTENSTELLE" as c4,
	   T1."STK" as c5,
	   T1."KONTO_1" as c6,
	   T1."KONTO_2" as c7,
	   T1."KONTO_3" as c8,
	   T1."KONTO_4" as c9,
	   T1."KONTO_5" as c10,
	   T1."EBENE1" as c11,
	   T1."EBENE2" as c12,
	   T1."EBENE3" as c13,
	   T1."EBENE4" as c14,
	   T1."EBENE5" as c15,
	   T1."EBENE6" as c16,
	   T1."EBENE7" as c17,
	   T1."EBENE8" as c18,
	   T1."EBENE9" as c19,
	   T1."EBENE10" as c20
from "Kontenrahmen.csv" T1

END SQL
COLUMN,0,Konto Nr
COLUMN,1,Konto Bezeichnung
COLUMN,2,Konto Art
COLUMN,3,Kostenstelle
COLUMN,4,Stk
COLUMN,5,Konto 1
COLUMN,6,Konto 2
COLUMN,7,Konto 3
COLUMN,8,Konto 4
COLUMN,9,Konto 5
COLUMN,10,Ebene1
COLUMN,11,Ebene2
COLUMN,12,Ebene3
COLUMN,13,Ebene4
COLUMN,14,Ebene5
COLUMN,15,Ebene6
COLUMN,16,Ebene7
COLUMN,17,Ebene8
COLUMN,18,Ebene9
COLUMN,19,Ebene10