I have a requirement to change the time zone dynamically in the OTBI analysis filters based on daylight saving times. Can someone please help me with a solution. Thank you
Hi @User_MLN1R,
Welcome to the Oracle Analytics Community.
Can you please take a look into the following post?
In OTBI How to set TIMEZONE using Data format setting properties? — Oracle
And follow the suggestions from Dimple-Nagesh (please see below) to see if it resolve your issue.
Can you please confirm the values of the following as Admin user: Login to OSC --> Username --> Set preferences --> Regional --> TimeZone --> Check what is the value set (attach the screenshots of the same) Login to BI --> username --> Myaccount --> General Preferences --> Timezone --> Should be greyed out and should show the same value as in OSC (attach the screenshots of the same) Login to BI --> username --> Myaccount --> BI Preferences --> Timezone --> Should show the same value as in OSC (attach the screenshots of the same) If all the above are not same, please set it to the same value and run the Scheduled process "Refresh Denormalised Time Dimension Table for BI" Login to OSC --> Navigator --> Scheduled Process --> Dropdown --> search --> Refresh Denormalised Time Dimension Table for BI" --> OK --> Submit. Wait until success, then logout and clear your browser cache, relogin and restest the issue
Hope this help.
Thank you.
@User_MLN1R , Welcome to the Oracle Analytics Community!
As per my understanding, OTBI doesn’t have a native “automatic DST adjustment” functionality. Hope above suggestion works for you. Otherwise, you might need to explore system session variables such as TIMEZONE, DATA_TZ, and DATA_DISPLAY_TZ. Here is the Oracle OTBI documentation for more details. Hope it helps!
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
