COGNOS QUERY
STRUCTURE,1,1
DATABASE,ARIntelligence
DATASOURCENAME,C:\GlobalCube\System\ARI\IQD\Sievers-Group\dMitarbeiter.imr
TITLE,dMitarbeiter.imr
BEGIN SQL
select '001' as c1,
	   T1."No_" as c2,
	   T1."Last Name" as c3,
	   T1."First Name" as c4,
	   T1."Function Code" as c5
from "Vogl7x"."dbo"."BMW AH Vogl$Employee" T1

END SQL
COLUMN,0,Mandant ID
COLUMN,1,Personalnummer
COLUMN,2,Zuname
COLUMN,3,Vorname
COLUMN,4,Function Code