oracle.sbo inputdateformat

[former_member589710]

Hi there, my oracle.sbo file does not have the parameter for

inputdateformat

. Can someone send me the full syntax to add this parameter and where in the file it is located?

[former_member589710]

fyi I am updating it as get an error when usgin the date in webi as a condition in the query:

ORA-01843: not a valid month

[former_member589710]

or should I update it to this?

<Parameter Name="USER_INPUT_DATE_FORMAT">'DD-MON-YYYY'</Parameter>
<Parameter Name="USER_INPUT_NUMERIC_SEPARATOR">.</Parameter>
<Parameter Name="DATABASE_DATE_FORMAT">DD-MON-YYYY</Parameter>

[former_member589710]

thanks I found this, what is the QT folder?

My database format is 0-JAN-2016, it is datatype timestamp, can you please confirm what I update to?

ORIGINAL

<Parameter Name="USER_INPUT_DATE_FORMAT">'dd-MM-yyyy HH:mm:ss'</Parameter>
<Parameter Name="USER_INPUT_NUMERIC_SEPARATOR">.</Parameter>
<Parameter Name="DATABASE_DATE_FORMAT">DD-MM-YYYY HH24:MI:SS</Parameter>

NEW?

<Parameter Name="USER_INPUT_DATE_FORMAT">'dd-MM-yyyy HH:mm:ss'</Parameter>
<Parameter Name="USER_INPUT_NUMERIC_SEPARATOR">.</Parameter>
<Parameter Name="DATABASE_DATE_FORMAT">DD-MON-YYYY</Parameter>

[ayman_salem]

You do not have to add it.

All extension parameters can be found in the file "oracle.prm" under the directory "...........\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle\extensions\qt" (<Parameter Name="USER_INPUT_DATE_FORMAT">'dd-MM-yyyy HH:mm:ss'</Parameter>)