Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How prompt date format change
Hi,
OBIEE App, How can I change that my date prompt will always stay in format dd.mm.yyyy?
This slq format dd.mm.yyyy but prompt format mm.dd.yyyy.
I am client user, please in fix client page NLS/ SQL or other set command ?
Fix help
Thank you.
Comments
-
Hi @User_SOJXT ,
In OBIEE/OAS, DATETIME columns in prompts are formatted according to your locale (the custom format that you set up in the SQL is basically ignored if you don't change the data type to VARCHAR).
Please follow this procedure to update the default locale for your account:
- Login to OBIEE
- Click on your profile icon (top right corner of the page)
- Click on My Account
- Select the Preferences tab and set the Locale to something different (e.g. "English - United States" if you want to display months before days in dates)
- Click OK
0 -
Thank you. work perfect.
New problems -> OBIEE promt sapmle 1,2 promt replace '1','2'. easy method ?
There are 70 billion rows of records and there is a performance problem when in list
Thank you.
rtrim(Varchar_ID ) In
( select rtrim(deger ) as deger from( select regexp_substr('@{ID_BAR}[@]{TRIM(0)}','[^,]+', 1, level) as deger
from dual
connect BY regexp_substr('@{ID_BAR}[@]{TRIM(0)}', '[^,]+', 1, level)
is not null))
and '@{ID_BAR}[@]{TRIM(0)}' !='0' -- promt null then false
0 -
Hi @User_SOJXT ,
I'm glad that the solution I posted worked for you. You can mark it as correct in order to help other people with the same issue.
For the new question, since it's not related to the original topic, I suggest you to create a new thread.
0
