COGNOS QUERY
STRUCTURE,1,1
DATABASE,Locosoft_GC
DATASOURCENAME,C:\GlobalCube\System\LOCOSOFT\IQD\zeit\employee_list.imr
TITLE,employee_list.imr
BEGIN SQL
select T1."employee_number" as c1,
	   RSUM(T1."employee_number") as c2,
	   T1."validity_date" as c3,
	   T1."is_latest_record" as c4,
	   T1."subsidiary" as c5,
	   RSUM(T1."subsidiary") as c6,
	   T1."has_constant_salary" as c7,
	   T1."name" as c8,
	   T1."initials" as c9,
	   T1."customer_number" as c10,
	   RSUM(T1."customer_number") as c11,
	   T1."mechanic_number" as c12,
	   RSUM(T1."mechanic_number") as c13,
	   T1."salesman_number" as c14,
	   RSUM(T1."salesman_number") as c15,
	   T1."is_business_executive" as c16,
	   T1."is_master_craftsman" as c17,
	   T1."employment_date" as c18,
	   T1."termination_date" as c19,
	   T1."leave_date" as c20,
	   T1."is_flextime" as c21,
	   RSUM(T1."is_flextime") as c22,
	   T1."break_time_registration" as c23,
	   T1."productivity_factor" as c24,
	   RSUM(T1."productivity_factor") as c25,
	   '1' as c26,
	   '' as c27,
	   CASE WHEN (T1."mechanic_number" IS NOT NULL) THEN ('Monteur') ELSE null END as c28
from "dbo"."employees" T1
where ((T1."leave_date" >= DATE '2016-01-01') or (T1."leave_date" IS NULL))

END SQL
COLUMN,0,Employee_ID
COLUMN,1,Summe  (Employee Number) Nr.1
COLUMN,2,Validity Date
COLUMN,3,Is Latest Record
COLUMN,4,Subsidiary
COLUMN,5,Summe  (Subsidiary) Nr.1
COLUMN,6,Has Constant Salary
COLUMN,7,Name
COLUMN,8,Initials
COLUMN,9,Customer Number
COLUMN,10,Summe  (Customer Number) Nr.1
COLUMN,11,Mechanic Number
COLUMN,12,Summe  (Mechanic Number) Nr.1
COLUMN,13,Salesman Number
COLUMN,14,Summe  (Salesman Number) Nr.1
COLUMN,15,Is Business Executive
COLUMN,16,Is Master Craftsman
COLUMN,17,Employment Date
COLUMN,18,Termination Date
COLUMN,19,leave_date
COLUMN,20,Is Flextime
COLUMN,21,Summe  (Is Flextime) Nr.1
COLUMN,22,Break Time Registration
COLUMN,23,productivity_factor
COLUMN,24,Summe  (Productivity Factor) Nr.1
COLUMN,25,Client_DB
COLUMN,26,Department
COLUMN,27,Zuordnung_Funktion