OTBI Usage tracking issue

Prateek Dhawan

I am getting issue in OTBI Usage Tracking wherein I had used the above Subject areas - OTBI Usage Tracking , however for some reason its not showing the data for recent weeks.

Is their any job or setting that we need to enable for the same ?

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24987/otbi-usage-tracking-issue

HI @Prateek Dhawan,

Not aware of any special settings or jobs but this SA only holds last 6 months of data.

Please take a look into the following doc and following post which might be useful

https://docs.oracle.com/en/cloud/saas/human-resources/25a/faohb/OTBI-Usage-Real-Time-SA-97.html#Description

Real Time OTBI Usage & Performance — Cloud Customer Connect

Just to make sure BI cache or browser cache is not creating the issue, please clear the BI Cache and browser cache & cookies, logout & close the browser and then again have a fresh login to check if there's any betterment.

Hope this help.

Thank you.

Prateek Dhawan

Thanks . Have Tried suggested steps . However no luck

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/65310#Comment_65310

Hi Prateek,

Quick questions:

Are you getting any data with usage SA?

Are there any particular set of reports or subject areas that you are not getting for recent weeks?

Are you getting any other data for the recent weeks? like not getting any data from say 5 of this month for any reports. OR getting data for few reports but not for all?

Thank you.

Prateek Dhawan

Are you getting any data with usage SA?- yes

Are there any particular set of reports or subject areas that you are not getting for recent weeks?- not coming data from any SA from particular date but before able to see data before that

Are you getting any other data for the recent weeks? like not getting any data from say 5 of this month for any reports. OR getting data for few reports but not for all?

Not getting data from any SA from particular date(say mid of Feb) but before able to see data before that

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/65316#Comment_65316

Hi Prateek,

Thanks for the details.

If possible please attach your report xml / catalog here so that will try to replicate the issue in our instance to see if we are facing the same.

Thank you.

Prateek Dhawan

Thanks Bhaskar

Following are the steps that can be used to recreate issue

Steps to recreate

--- Open the Fusion analytics application
--- Click on Catalog -- Create Analysis
--- Select Subject Area -"OTBI Usage Real Time"
--- Select columns in the Criteria Tab
Year,
Calendar Month,
User Name,
Report Start Date,
Report End Date,
Report Execution Count

-- Click on Results Tab
Sort the same by Report Start date DESC

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/65519#Comment_65519

Hi Prateek,

Thanks for the details. I've tried in my instance and it is working fine and bringing the Real Time Data.

Here's the report output that I received.

Thank you.

Bhaskar Konar

Hi @Prateek Dhawan,

Please find below the report xml that have been used for the above report output.

XML -- OTBI Usage.txt

Thank you.

Prateek Dhawan

Thanks for quick reply.

Have used the same xml , however still no luck

Have tried on other environment and have similar issue in that

We are using the application ver

Oracle Fusion Cloud Applications25A (11.13.25.01.0)

Is their any ESS standard job or some table config setting that we can check .?

Have tried clearing cache

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/65576#Comment_65576

Hi @Prateek Dhawan,

I'm not able too replicate the issue in our instances and the data is coming fine for us.

I would recommend to raise with Oracle Support with all associated details and get their valuable suggestions.

Thank you.