COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Kosten_2018.imr
TITLE,Kosten_2018.imr
BEGIN SQL
select T1."Acct Nr" as c1,
	   T1."Jahr" as c2,
	   T1."Mandant" as c3,
	   T1."KST" as c4,
	   T1."Plan Kosten" as c5,
	   T1."Plan Kosten" / 12 as c6,
	   (T1."Plan Kosten" / 12) as c7,
	   (T1."Plan Kosten" / 12) as c8,
	   (T1."Plan Kosten" / 12) as c9,
	   (T1."Plan Kosten" / 12) as c10,
	   (T1."Plan Kosten" / 12) as c11,
	   (T1."Plan Kosten" / 12) as c12,
	   (T1."Plan Kosten" / 12) as c13,
	   (T1."Plan Kosten" / 12) as c14,
	   (T1."Plan Kosten" / 12) as c15,
	   (T1."Plan Kosten" / 12) as c16,
	   (T1."Plan Kosten" / 12) as c17,
	   (T1."Plan Kosten" / 12) as c18
from "Kosten_gesamt_2018" T1
where (T1."Plan Kosten" <> 0)

END SQL
COLUMN,0,Acct Nr
COLUMN,1,Jahr
COLUMN,2,Mandant
COLUMN,3,Kst
COLUMN,4,Plan Kosten
COLUMN,5,PK1
COLUMN,6,PK2
COLUMN,7,PK3
COLUMN,8,PK4
COLUMN,9,PK5
COLUMN,10,PK6
COLUMN,11,PK6
COLUMN,12,PK7
COLUMN,13,PK8
COLUMN,14,PK9
COLUMN,15,PK10
COLUMN,16,PK11
COLUMN,17,PK12