COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_Navision
DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\nw\verkaeufer_aktiv_plan.imr
TITLE,verkaeufer_aktiv_plan.imr
BEGIN SQL
select T1."User ID" as c1,
	   T1."Employee No_" as c2,
	   T1."Salesperson" as c3,
	   T2."No_" as c4,
	   T2."First Name" as c5,
	   T2."Last Name" as c6,
	   T2."Name" as c7,
	   T2."Status" as c8,
	   T2."Inactive Date" as c9,
	   T2."Termination Date" as c10,
	   T2."Department Code" as c11,
	   (od_right(T2."Department Code",2)) as c12,
	   CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END as c13,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c14,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c15,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c16,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c17,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c18,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c19,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c20,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c21,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c22,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c23,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c24,
	   (CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN (216) ELSE (0) END) / 12 as c25,
	   '2016' as c26,
	   CASE WHEN (((od_right(T2."Department Code",2))) = '20') THEN ('GA') ELSE null END as c27,
	   T1."Salesperson" || ' - ' || T2."First Name" || ' ' || T2."Last Name" as c28,
	   'aktive Verkäufer' as c29
from ("NAVISION"."import"."User_Setup" T1 left outer join "NAVISION"."import"."Employee" T2 on ((((((T2."No_" = T1."Employee No_") and (T2."Status" = 0)) and (T2."Inactive Date" = TIMESTAMP '1753-01-01 00:00:00.000')) and (T2."Termination Date" = TIMESTAMP '1753-01-01 00:00:00.000')) and (T1."Salesperson" <> ' ')) and (T1."Salesperson" <> 'DIV')) and (T2."Client_DB" = T1."Client_DB"))
where ((((T1."Salesperson" <> ' ') and (not T1."Salesperson" IN ('DIV','BMWREL'))) and ((cast_float(T1."Salesperson")) BETWEEN 100 AND 999)) and (T2."Status" = 0))
order by c3 asc

END SQL
COLUMN,0,User Id
COLUMN,1,Employee No
COLUMN,2,Salesperson
COLUMN,3,No
COLUMN,4,First Name
COLUMN,5,Last Name
COLUMN,6,Name
COLUMN,7,Status
COLUMN,8,Inactive Date
COLUMN,9,Termination Date
COLUMN,10,Department Code
COLUMN,11,KST
COLUMN,12,Plan_Stück
COLUMN,13,Stk_1
COLUMN,14,Stk_2
COLUMN,15,Stk_3
COLUMN,16,Stk_4
COLUMN,17,Stk_5
COLUMN,18,Stk_6
COLUMN,19,Stk_7
COLUMN,20,Stk_8
COLUMN,21,Stk_9
COLUMN,22,Stk_10
COLUMN,23,Stk_11
COLUMN,24,Stk_12
COLUMN,25,Invoice Date
COLUMN,26,Fahrzeugart
COLUMN,27,Verkäufer_Plan
COLUMN,28,Verkäufer Gruppe