OBI TIMEZONE: OPERA CLOUD VS OPERA R&A Timing ARE NOT MATCHING

Agil

Hi team,

My time in Opera is Different from time in the report generated in R&A . R&A uses GMT time zone.

I am based in Doha (GMT+3), so the report is showing data 3 hours behind my time. How can I fix this issue? The report time setting is correct in OBI.

Ram-Oracle

@Agil Please also verify the below documentation about timezones related to data

https://docs.oracle.com/middleware/1221/biee/BIESG/configtimezones.htm

Ram-Oracle

@Agil Please login to /analytics,check Right hand side profile icon ,my account ,preferences tab and change the timezone and see if it is fixing the issue.

if it is not resolving the issue ,please share more details. Report criteria screenshot and filters applied and timezone of database

From oas server ,please check for instanceconfig.xml in obips folder and check for tags like below and share the current settings.Note: The below tags are references only

<TimeZone>

<DefaultDataOffset>0</DefaultDataOffset>

</TimeZone>

Note: Please refer below doc id and for oracle analytics server ,the patches may not apply.

OBIEE 12c: Database Data Time Is Not Taken And Data Timezone Is Shifted In The Analysis Results (Doc ID 2254874.1)

Agil

Dear Ram, Thank you for your prompt reply. Timezone is correct in profile/my account section.

Please see screenshot for report criteria and filters. How can i access to obips folder ?

Agil

@Ram-Oracle . Thanks for your support. Look forward to hearing from you.

Ram-Oracle

@Agil Please navigate to ..\domainhome\config\fmwconfig\biconfig\OBIPS

edit instanceconfig.xml using VI editor or use more command or check in winscp and navigate to the location and edit the file with notepad++ and verify <Timezone> tags .

Also please confirm the timezone of your database source for which your report is pointed to .