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,
	   CASE WHEN (T1."Filial_Nr" = '1') THEN ('Neu W') WHEN (T1."Filial_Nr" = '2') THEN ('BH TOY') WHEN (T1."Filial_Nr" = '3') THEN ('HB TOY') WHEN (T1."Filial_Nr" = '4') THEN ('LB TOY') WHEN (T1."Filial_Nr" = '5') THEN ('Berge') WHEN (T1."Filial_Nr" = '6') THEN ('BH REN') WHEN (T1."Filial_Nr" = '7') THEN ('HB REN') WHEN (T1."Filial_Nr" = '8') THEN ('Stade TOY') WHEN (T1."Filial_Nr" = '9') THEN ('Taxi Werk') WHEN (T1."Filial_Nr" = '10') THEN ('Wandsbek') ELSE null END as c4
from "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."Filialen" T1

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