Retrieve user locale

[nayitian]

Hi

I am trying so hard to add a query item, which can retrieve user's locale information(en, fr...), it's going to be used as an individual reporting column. Can any one shed some lights on how to do it, or if it's even possible to do.

Thank you.

[Grim]

See if this helps:
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m1
/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.c8pp_inst.10.1.1.doc%2Fc_map_contl.html

Edit:
Other finds...

http://www-01.ibm.com/support/docview.wss?uid=swg21340429

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_fm.10.1.1.doc%2Fc_use_parameters_model_multilingual_data.html

[nayitian]

Hi Grim

Thank you for such quick help.
However, it won't work. In FM model, I can run the Macro the retrieve user locale, but I cannot use it as a query item.

[blom0344]

You can use the the locale within case expressions to translate codes to multilingual output:

Use the syntax:

# sq( $runLocale)#

Example:

case when
(# sq( $runLocale)# = 'en') then 'bubblegum'
else 'liquorice'
end

[nayitian]

Awsome!  Thank you soooo much. You literally saved my life.