Skip to Content
0
Former Member
Oct 17, 2008 at 10:17 PM

Language localization

17 Views

Hi folks, I'm seeking some info on this.

We are working on localizing universes for language based on user who

is running the report.

Is it possible to do one of the following in spirit of having a BO

design time variable for language and have it replaced by the

appropriate value associated to the user running the report BEFORE it

gets processed by Oracle.

For example:

select * from employee

where employee.language (+)= '-999999999999'

and dept.language (+)= '-999999999999'

and employee.deptno = dept.deptno

replace '-999999999999' by a oracle user session variable before

processing by the database so that the output query is the following if

the variable contains 'en':

select * from employee

where employee.language (+)= 'en'

and dept.language (+)= 'en'

and employee.deptno = dept.deptno

OR alternately have BOBJ somehow replace a substitute variable by the

appropriate value

select * from employee

where employee.language (+)= '&userlanguage'

and dept.language (+)= '&userlanguage'

and employee.deptno = dept.deptno

by

select * from employee

where employee.language (+)= 'en'

and dept.language (+)= 'en'

and employee.deptno = dept.deptno

- where 'en' is the value of the user logging into oracle.

FYI, we cannot overload @dbuser and @dbpass because we already use

these variables for actual logon