This content has been marked as final. Show 3 replies
In NQsconfig check for DATE_TIME_DISPLAY_FORMA and other types below to that.
Database server settings(not related to BI) are same in both environments?
Edited by: Srini VEERAVALLI on Mar 21, 2013 1:27 PM
I checked both files. They both are in sync.
DATE_TIME_DISPLAY_FORMAT = "yyyy/mm/dd hh:mi:ss";
DATE_DISPLAY_FORMAT = "yyyy/mm/dd";
TIME_DISPLAY_FORMAT = "hh:mi:ss";
I checked nls date parameters in both the instances. They are same as DD-MON-RR
Edited by: DonBI on Mar 21, 2013 11:46 AM
In that case that might be the webcat format save using
Column properties->Data format->
and then SAVE button
<OracleBIData>\web\catalog\<CatalogName>\root\system\metadata in the files datatypeformats and datatypeformats.atr
Edited by: Srini VEERAVALLI on Mar 21, 2013 2:03 PM