Ssrs 2012 iif issue

SSAS and SSRS
4

Then use a stored procedure to get your data as follows

create proc report_sp(@homeLanguage char(5))
as
begin

select *
  from terms t
  join translations tr on t.termid = t.termid
  join languages l on l.languageId = tr.languageId

  where LanguageCode = @homeLanguage
end

go

report_sp 'es-ES';
go