COGNOS QUERY
STRUCTURE,1,1
DATABASE,ARIntelligence
DATASOURCENAME,C:\GlobalCube\SYSTEM\ARIntelligence\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."Last Name" as c4,
	   T1."First Name" as c5,
	   '1' as c6,
	   '10' as c7,
	   T1."Name" || '10' as c8,
	   T1."Name" as c9
from "Automag7x"."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,Last Name
COLUMN,4,First Name
COLUMN,5,Hauptbetrieb
COLUMN,6,Standort
COLUMN,7,Name_Standort
COLUMN,8,Serviceberater