How to get list of users

Question

Hi All,

How to get a list of users that have logged in to the application(OBIEE) in the past 6 months and also how to  get metrics on the individual dashboards and reports -OBIEE

Thanks,

Sulochana

Naeem Akhtar · Answer

Dear

You can achieve this by following below MOS Note.

OBIEE 11g: How To Extend Usage Tracking Tables S_ETL_DAY And S_ETL_TIME_DAY Past Jan 2016 (Doc ID 2073512.1)

Please mark if helpful.

Regards

Naeem K.

Sulochana · Answer

Yes we can achieve by using usage tracking . Here s_ETL_day table i am not able to see 2017 information what might be the issue for this?

Naeem Akhtar · Answer

Dear,

You can achieve this by Usage Tracking.

You can follow below link if not enabled already. (11g)

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html

Please mark if helpful.

Regards

Naeem Akhtar