GAPS/Portal/System/IQD/Planung/Kosten_2022.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Kosten_2022.imr
TITLE,Kosten_2022.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
from "Kosten_Gesamt_2022" 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,PK7
COLUMN,12,PK8
COLUMN,13,PK9
COLUMN,14,PK10
COLUMN,15,PK11
COLUMN,16,PK12