COGNOS QUERY
STRUCTURE,1,1
DATABASE,Navision2
DATASOURCENAME,C:\gaps_bmw\Portal\System\IQD\Service\Serviceberater_Struktur_MA-Stamm_LBS.imr
TITLE,Serviceberater_Struktur_MA-Stamm_LBS.imr
BEGIN SQL
select T1."No_" as c1,
	   T1."Name" as c2,
	   T1."Resource Group No_" as c3,
	   T1."Department Code" as c4,
	   T1."Last Name" as c5,
	   T1."First Name" as c6,
	   '1' as c7,
	   '10' as c8,
	   T1."Name" || '10' as c9,
	   T1."Name" as c10
from "DMS1"."dbo"."Automag GmbH$Resource" T1
where (T1."Resource Group No_" = 'SB')

END SQL
COLUMN,0,No
COLUMN,1,Name
COLUMN,2,Resource Group No
COLUMN,3,Department Code
COLUMN,4,Last Name
COLUMN,5,First Name
COLUMN,6,Hauptbetrieb
COLUMN,7,Standort
COLUMN,8,Name_Standort
COLUMN,9,Serviceberater