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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Planung_2012
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Planung\Kosten_2018_GuV.imr
TITLE,Kosten_2018_GuV.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_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_GuV
COLUMN,6,PK2_GuV
COLUMN,7,PK3_GuV
COLUMN,8,PK4_GuV
COLUMN,9,PK5_GuV
COLUMN,10,PK6_GuV
COLUMN,11,PK7_GuV
COLUMN,12,PK8_GuV
COLUMN,13,PK9_GuV
COLUMN,14,PK10_GuV
COLUMN,15,PK11_GuV
COLUMN,16,PK12_GuV