COGNOS QUERY
STRUCTURE,1,1
DATABASE,Locosoft_GC
DATASOURCENAME,C:\GlobalCube\System\LOCOSOFT\IQD\Serv_Teile\Serviceberater_Rechnung.imr
TITLE,Serviceberater_Rechnung.imr
BEGIN SQL
select distinct T1."invoice_type" as c1,
	   T1."invoice_number" as c2,
	   T2."order_taking_employee_no" as c3,
	   T2."order_delivery_employee_no" as c4,
	   T1."invtype_invnr" as c5,
	   T3."employee_number" as c6,
	   T3."name" as c7,
	   (od_left((cast_numberToString(cast_integer(T3."employee_number"))),4)) || ' - ' || T3."name" as c8
from (("LOCOSOFT"."dbo"."order_positions" T2 left outer join "dbo"."invoices" T1 on T2."order_number" = T1."order_number") left outer join "LOCOSOFT"."dbo"."employees" T3 on T2."order_taking_employee_no" = T3."employee_number")
where ((T1."invoice_type" BETWEEN 2 AND 6) and (T2."order_date" >= TIMESTAMP '2019-01-01 00:00:00.000'))
order by c5 asc,c2 asc

END SQL
COLUMN,0,Invoice Type
COLUMN,1,Invoice Number
COLUMN,2,Order Taking Employee No
COLUMN,3,Order Delivery Employee No
COLUMN,4,Invoice_Type_Invoice_Number
COLUMN,5,Employee Number_Employees
COLUMN,6,Name_Employees
COLUMN,7,Serviceberater