Date format according to user region

[Former Member]

Hi All,

I have an explorer where data is coming from hana cubes, what i want is :- if a user in usa opens the information space than date should be displayed as mm-dd-yy and for an Indian user it should be dd-mm-yy

I am using bo 4.1 sp3.

thanks in advance,

Yash

[Former Member]

Hi Yash,

On the SAP HANA side you must have enabled translations into the different languages for the text. At the same time the date format should also change.

As a test change the locale of the HANA client and retrieve date results:

http://scn.sap.com/thread/3301295

Then according to the Users BI launchpad locale settings, it should format in Indian locale.

Here a link which states that at least the numeric format can also be changed directly in Explorer (I haven't checked the date).

https://ideas.sap.com/ct/ct_a_view_idea.bix?idea_id=81DAB90F-6096-4F78-BB3B-384D1826F337

Denis