COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\serv_teile\Filialen_GC.imr
TITLE,Filialen_GC.imr
BEGIN SQL
select T1."Filial_Id" as c1,
	   T1."Filial_Nr" as c2,
	   T1."Name_1" as c3,
	   (substring(T1."Name_1" from 1 for 10)) as c4
from "\\ahk-wws01\wwsDaten\WerWiSoTabs\Kleinemeier\Mandant.add"."Filialen" T1

END SQL
COLUMN,0,Filial Id
COLUMN,1,Filial Nr
COLUMN,2,Name 1
COLUMN,3,Name_GC