QaaWS displays dates in US format
My customer has date objects. These are stored in UK format (dd/mm/yyyy) everywhere at the database, universe. When he creates a webi report it also shows the date in UK format however if he tries to create a similar query in Query as a web service, the result set is displayed in US format (mm/dd/yyyy). the same behaviour is noticed for LOVs. I have checked the regional settings of the client machine and it does not effect QAAWS. Also I have been able to replicate the issue at my end.
I have also tried checking "Migration Forced" at the universe level and then exporting the universe but nothing changes. List of values which comes in webi are UK but in QAAWS it is coming in US which creates a conflict while fetching the data because at the database format is UK.
However, in XI3.0, dates are displaying correcly using the same workflow.
Please see the screenshots attached.
Is anyone aware of this issue? is there any configuration file in order to force the locale language?
Awaiting your prompt reply,