C11/System/AUTOLINE/IQD/NW/VS_Vehicle_Specification_Kosten.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_AUTOLINE
DATASOURCENAME,C:\GlobalCube\System\Autoline\IQD\nw\VS_Vehicle_Specification_Kosten.imr
TITLE,VS_Vehicle_Specification_Kosten.imr
BEGIN SQL
select distinct c19 as c1,
	   c18 as c2,
	   c17 as c3,
	   c16 as c4,
	   XSUM(c23 for c15) as c5,
	   XSUM(c22 for c15) as c6,
	   XSUM(c21 for c15) as c7,
	   XSUM(c20 for c15) as c8,
	   c15 as c9
from 
(select (T1."VehicleTypeNU" || (cast_numberToString(cast_integer(T1."VehicleQuoteNumber")))) as c15,
	   T1."Client_DB" as c16,
	   T1."VehicleTypeNU" as c17,
	   T1."VehicleQuoteNumber" as c18,
	   T1."OptionType" as c19,
	   CASE WHEN (T1."AnalysisCode" <> 'V') THEN (T1."ActualCost") ELSE (0) END as c20,
	   (CASE WHEN (T1."AnalysisCode" = 'V') THEN (T1."ActualCost") ELSE (0) END) as c21,
	   (CASE WHEN (T1."AnalysisCode" <> 'V') THEN (T1."EstimatedCost") ELSE (0) END) as c22,
	   (CASE WHEN (T1."AnalysisCode" = 'V') THEN (T1."EstimatedCost") ELSE (0) END) as c23
from "AUTOLINE"."import"."VS_VehicleSpecification" T1
where (T1."OptionType" = 'N')
) D1
order by c9 asc,c2 asc

END SQL
COLUMN,0,Optiontype
COLUMN,1,Vehiclequotenumber
COLUMN,2,Vehicletypenu
COLUMN,3,Client Db
COLUMN,4,Gesch_Kosten_Stuetzung
COLUMN,5,Gesch_Kosten_Gesamt
COLUMN,6,Tatsaechl_Kosten_Stuetzung
COLUMN,7,Tatsaechl_Kosten_Gesamt
COLUMN,8,FZG_Nr