C11/System/ARI/IQD/Service/Monteure_fuer_Anzeige_offene_Auftraege.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,ARIntelligence
DATASOURCENAME,C:\GlobalCube\System\ARI\IQD\Service\Monteure_fuer_Anzeige_offene_Auftraege.imr
TITLE,Monteure_fuer_Anzeige_offene_Auftraege.imr
BEGIN SQL
select distinct c1 as c1,
	   c2 as c2,
	   c3 as c3,
	   c4 as c4,
	   c5 as c5,
	   c6 as c6,
	   XRANK(c6 for c1) as c7
from 
(select T1."Order No_" as c1,
	   T1."Type" as c2,
	   T1."No_" as c3,
	   T2."Last Name" as c4,
	   T1."Entry No_" as c5,
	   (cast_float(T1."Qty_ Evaluated")) as c6,
	   XRANK(((cast_float(T1."Qty_ Evaluated"))) for T1."Order No_") as c8
from ("Vogl7x"."dbo"."BMW AH Vogl$Service Ledger Entry" T1 left outer join "Vogl7x"."dbo"."BMW AH Vogl$Employee" T2 on T2."No_" = T1."No_")
where (((((extract(DAY FROM (now()) - T1."Posting Date")) <= 120) and (T1."Order No_" LIKE 'W%')) and (T1."Type" = 2)) and (((cast_float(T1."Qty_ Evaluated"))) <> 0))
) D1
where (c8 = 1)
order by c1 asc

END SQL
COLUMN,0,Order No
COLUMN,1,Type
COLUMN,2,No
COLUMN,3,Last Name
COLUMN,4,Entry No
COLUMN,5,Qty Evaluated
COLUMN,6,RANG  (  Qty Evaluated  )