Language localization

[Former Member]

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

[Former Member · Accepted solution]

Hi George,

You can create a pre-defined filter in the universe such as:

employee.language (+)= @prompt('Enter language?','A',,mono,free)

Then, set the filter option "Use filter as mandatory in query" on and set the option "Apply on universe" on.

Whatever your query is you will always be prompted to select a language and the FROM and WHERE clause will be filled appropriately.

Regards,

Didier

[Former Member]

Hi Didier, thanks for your reply.

Is there a way to force this filter on all queries in Xir2? The filter options are only available in R3.

Thanks in advance. George