C11/System/LOCOSOFT/IQD/Zeit/Employee_List.iqd

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
from "dbo"."employees" T1

END SQL
COLUMN,0,Employee Number
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