Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Language localization

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question